1、--采购到入库所经历的表--0.请购单--创建请购单方式有--a.从外挂系统导入请购的接口表PO_REQUISITIONS_INTERFACE_ALL,并允许请求(名称:导入申请)select * from po_requisitions_interface_all where interface_source_code = 'TEST KHJ';--b.在系统中创建请购单(路径:PO/申请/申请)--请购单头信息select prh.requisition_header_id, prh.authorization_s
2、tatus --未审批时为INCOMPLETE,审批完后为 from po_requisition_headers_all prh where prh.segment1 = '600000' and prh.type_lookup_code = 'PURCHASE';--请购单行信息select prl.requisition_line_id, prl.* from po_requisition_lines_all prl where prl.requisition_header_id in
3、 (select prh.requisition_header_id from po_requisition_headers_all prh where prh.segment1 = '600000' and prh.type_lookup_code = 'PURCHASE');--请购单分配行select * from po_req_distributions_all prda where prda.r
4、equisition_line_id in (select prl.requisition_line_id from po_requisition_lines_all prl where prl.requisition_header_id in (select prh.requisition_header_id from p
5、o_requisition_headers_all prh where prh.segment1 = '600000' and prh.type_lookup_code = 'PURCHASE'));--1.采购订单的创建(路径:PO/采购订单/采购订单)--po_headers_all 采购订单头表select pha.po_header_id, pha.segm