隨手筆記

select mp.organization_code "ORG",
       pha.segment1 "PO NO",
       asp.vendor_name "Supply",
       assa.vendor_site_code "Site",
       pla.line_num "Line",
       msib.segment1 "Item",
       msib.description "Description",
       pla.unit_meas_lookup_code "UOM",
       pla.unit_price "Unit Price",
       pla.quantity "QTY",
       pla.quantity * pla.unit_price "Amount",
       pha.currency_code "Currency",
       PRF.FULL_NAME "Buyer",
       prha.segment1 "PR No"
  from po_headers_all pha,
       po_lines_all pla,
       po_line_locations_all plla,
       po_distributions_all pda,
       po_requisition_headers_all prha,
       po_requisition_lines_all prla,
       po_req_distributions_all prda,
       ap_suppliers asp,
       ap_supplier_sites_all assa,
       mtl_system_items_b msib,
       mtl_parameters mp,
       PER_PEOPLE_F PRF,
       PO_AGENTS POA
 where pha.po_header_id = pla.po_header_id
   and asp.vendor_id = assa.vendor_id
   and pha.vendor_id = asp.vendor_id
   and pha.vendor_site_id =  assa.vendor_site_id
   and pha.po_header_id = pda.po_header_id
   and pla.item_id = msib.inventory_item_id
   and plla.po_line_id = pla.po_line_id
   and plla.line_location_id = pda.line_location_id
   and plla.ship_to_organization_id = msib.organization_id
   and mp.organization_id = msib.organization_id
   and PRF.PERSON_ID = POA.AGENT_ID
   and pha.agent_id = POA.AGENT_ID
   and prha.requisition_header_id(+) = prla.requisition_header_id
   and prla.requisition_line_id(+) = prda.requisition_line_id
   and prda.distribution_id(+) = pda.req_distribution_id
   and pha.org_id = XXX
   and pha.segment1 = 'XXX'