PO_从PO追溯PR的方式和表（分析）

2014-06-03 Created By BaoXinjian

一、汇总

---

从PR单回溯PO单的所需的方式和经过的表

1. 页面中从PO追溯PR的方式 

    (1). PO Header 及 Line 

    (2). PO Shipment 

    (3). PO Distribution

2. 通过SQL查询

     (1).汇总

     (2).各条追溯

 

二、分步解析

---

1. 页面中从PO追溯PR的方式 

    (1). PO Header 及 Line  

        

    (2). PO Shipment

        

    (3). PO Distribution

        

 

2. 通过SQL查询

    (1).汇总

        

    (2).各条追溯

        SELECT po_header_id

          FROM po_headers_all

         WHERE segment1 = '6050'

 

        SELECT po_line_id

          FROM po_lines_all

         WHERE po_header_id = 110369

 

        SELECT line_location_id

          FROM po_line_locations_all

         WHERE po_line_id = 173300

 

        SELECT req_distribution_id

          FROM po_distributions_all

         WHERE line_location_id = 264435

 

        SELECT requisition_line_id

          FROM po_req_distributions_all

         WHERE distribution_id = 206943

 

        SELECT requisition_header_id

         FROM po_requisition_lines_all

        WHERE requisition_line_id = 208424

 

        SELECT segment1

         FROM po_requisition_headers_all

       WHERE requisition_header_id = 181214

 

        SELECT pha. po_header_id,

               pla .po_line_id ,

               plla .line_location_id ,

               pda .REQ_DISTRIBUTION_ID ,

               prda .distribution_id ,

               prla .requisition_line_id ,

               prha .requisition_header_id

          FROM po_headers_all pha ,

               po_lines_all pla ,

               po_line_locations_all plla ,

               po_distributions_all pda ,

               po_req_distributions_all prda ,

               po_requisition_lines_all prla ,

               po_requisition_headers_all prha

        WHERE pha .po_header_id = pla .po_header_id (+)

          AND pla.po_line_id = plla.po_line_id(+)

          AND plla.line_location_id = pda .line_location_id (+)

          AND pda.req_distribution_id = prda .distribution_id (+)

          AND prda.requisition_line_id = prla .requisition_line_id (+)

          AND prla.requisition_header_id = prha .requisition_header_id (+)

          AND pha.segment1 = '6050'

 

Thanks and Regards