隨手筆記

select wie.wip_entity_name, 
       prh.segment1 PR_NO,
       ph.segment1  PH_NO
  from wip_entities wie, 
       po_requisition_headers_all prh, 
       po_requisition_lines_all prl,
       po_req_distributions_all prd,
       po_distributions_all     pda,
       po_headers_all           ph
 where prh.requisition_header_id = prl.requisition_header_id
   and prl.requisition_line_id = prd.requisition_line_id
   and prd.distribution_id = pda.req_distribution_id(+)
   and pda.po_header_id    = ph.po_header_id(+)
   and prl.wip_entity_id = wie.wip_entity_id
   and wie.wip_entity_name = 'XXXX'