PO Archives - Orapoint

Purchase order PO table details in Oracle Apps R12, PO_HEADERS_ALL table plays an important role in PO Purchasing module, all PO module tables are linked with PO header table which stores PO header related information. List of Important Purchase Order (PO) Module tables in Oracle Apps R12 PO_HEADERS_ALL PO_LINES_ALL PO_LINE_LOCATIONS_ALL PO_DISTRIBUTIONS_ALL PO_VENDORS_ALL PO_VENDOR_SITES_ALL PO_RELEASES_ALL PO_VENDOR_CONTACTS

This query is used to get open purchase order PO in Oracle Apps R12, it will display complete information of open purchase order which are linked with Requisitions, open purchase order means invoicing or billing is not yet done against purchase order. SELECT ph.segment1 po_num, ph.creation_date, hou.NAME “Operating Unit”, ppx.full_name “Buyer Name”, ph.type_lookup_code “PO Type”,