2014-06-03 Created By BaoXinjian

一、摘要

---

介绍一个完整的采购流程，包括操作与对应的底层数据表查询，流程包含了请购->采购->接受->入库

1. 开立请购单

2. 对请购单进行审批

3. 通过自动匹配产生采购单

4. 对采购单进行审批

5. 接收采购单

6. 进行入库交易

 

二、流程操作

---

1. 开立请购单

    (1). Path: PO-->申请-->申请

    

    请购单PLSQL    

            SELECT prh.requisition_header_id, prh.segment1, prh.type_lookup_code,

                        description, authorization_status, prl.requisition_line_id, line_num,

                        item_id, item_description, category_id, unit_meas_lookup_code,

                        unit_price, quantity, quantity_delivered, prl.destination_type_code,

                        destination_organization_id, deliver_to_location_id, to_person_id,

                        destination_subinventory, prl.vendor_id, prl.vendor_site_id,

                        prl.vendor_contact_id

             FROM po_requisition_headers_all prh, po_requisition_lines_all prl

           WHERE prh.requisition_header_id = prl.requisition_header_id

                AND prh.segment1 = '14302' 

 

2. 对请购单进行审批

    (1). 点击审批

    

    审批状态PLSQL

                SELECT segment1, authorization_status, wf_item_type, wf_item_key

                  FROM po_requisition_headers_all

                WHERE segment1 = '14302'    

    

3. 通过自动匹配产生采购单

    (1). 通过自动匹配功能产生

       

   

    请购单对应的采购单PLSQL

            SELECT pr_pha.requisition_header_id, pr_pha.segment1,

                        pr_pla.requisition_line_id, pr_pla.line_num, pr_pla.item_description,

                        po_pla.po_line_id, po_pla.line_num, po_pla.item_description,

                        po_pha.po_header_id, po_pha.segment1

            FROM po_requisition_headers_all pr_pha,

                        po_requisition_lines_all pr_pla,

                        po_line_locations_all pll,

                        po_lines_all po_pla,

                        po_headers_all po_pha

          WHERE pr_pha.requisition_header_id = pr_pla.requisition_header_id

              AND pr_pla.line_location_id = pll.line_location_id

              AND pll.po_line_id = po_pla.po_line_id

              AND po_pla.po_header_id = po_pha.po_header_id

              AND pr_pha.segment1 = '14302'

    (2). 产生的采购单

    

    po_headers_all  po_lines_all

    (3). 采购单发运信息

    

    po_line_locations_all

    (4). 采购单分配信息

    

    po_distributions_all

    

4. 对采购单进行审批

    SELECT segment1, authorization_status, wf_item_type, wf_item_key
      FROM po_headers_all
     WHERE segment1 = '6025'

 

5. 接收采购单

    (1). 接收题头

        

        rcv_shipment_headers

    (2). 接收事物处理

        

   rcv_shipment_lines

 

6. 进行入库交易

 

mtl_material_transactions

 

Thanks and Regards

ERP技术讨论群: 288307890
技术交流，技术讨论，欢迎加入
Technology Blog Created By Oracle ERP - 鲍新建