Purchase Order Query
About: below script to fetch Purchase Order details with some additional information related to PO based on mtl_parameters organization_id SELECT ph.segment1 AS po_number, ph.creation_date, ph.type_lookup_code, ph.freight_terms_lookup_code, ph.authorization_status, msib.segment1 AS item, msib.segment2, ph.closed_code, pll.need_by_date, pll.promised_date, mp.organization_code, ph.org_id, ph.currency_code, pol.unit_price, ...