oracle EBS Purchase Order PO Tables

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

PO_LINES_ALL
LINE_TYPE_ID, ITEM_ID AND LINE_NUMBER
JOIN USING PO_HEADER_ID AND ORG_ID

PO_LINE_LOCATIONS_ALL LINE_LOCATION_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

Supplier information
VENDORS_ALL

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.

Shadab

Hi, I am passionate about technology be it hardware or software. I like to write blogs and help people.

Leave a Reply