This post contains affiliate links. Read the full disclosure here.
PO_HEADERS_ALL: Segment1- purchase order number
JOIN USING PO_HEADER_ID, ORG_ID , TYPE_LOOKUP_CODE
LINE_TYPE_ID, ITEM_ID AND LINE_NUMBER
JOIN USING PO_HEADER_ID AND ORG_ID
for delivery schedule information, shipment schedules and price breaks information
shipment schedules will be used in RFQs, Quotations, Standard purchase orders, Planned purchase orders, Planned purchase order releases, Blanket purchase orders, Blanket purchase order releases JOIN USING PO_HEADER_ID , PO_LINE_ID AND ORG_ID
PO_DISTRIBUTIONS_ALL for information of accounting distribution of purchase order shipment lines.
PO_DISTRIBUTION_ID: Distribution identifier.
LINE_LOCATION_ID: Shipment Schedule reference to PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID
CODE_COMBINATION_ID: General Ledger Charge Account reference to GL_CODE_COMBINATIONS.CODE_COMBINATION_ID
REQ_DISTRIBUTION_ID: Requisition distribution reference to PO_REQ_DISTRIBUTIONS_ALL.DISTRIBUTION_ID JOIN USING PO_HEADER_ID , PO_LINE_ID AND ORG_ID
PO_VENDOR_SITES_ALL: Information about supplier sites. site address, supplier reference, purchasing, payment, bank, and general information.
PO_RELEASES_ALL: Information related to planned and blanket Purchase Order releases. buyer, date, release status, and release number.
Each release must have at least one purchase order shipment.
PO_VENDOR_CONTACTS: for contacts related to Supplier site. Each row includes contact name and site.
PO_ACTION_HISTORY: Information about the approval and control history of a Purchasing Document.
Record for each approval or control action an employee takes on a purchase order, purchase agreement, release or requisition.