Skip to main content
OracleOps AI
← All tables
Oracle Fusion/Procurement/Purchasing

PO_DISTRIBUTIONS_ALL

PO distribution — charge account and quantity ordered per accounting distribution.

Key Columns

PO_DISTRIBUTION_IDPO_LINE_IDREQ_LINE_IDCODE_COMBINATION_ID

Parent Table

PO_LINES_ALL

PO line — item, quantity, unit price.

Common Joins

PO_LINES_ALLvia PO_LINE_ID

The PO line this distribution charges.

PO_REQUISITION_LINES_ALLvia REQ_LINE_ID

The requisition line that originated this distribution, if the PO was created from a requisition.

GL_CODE_COMBINATIONSvia CODE_COMBINATION_ID

The GL account this distribution charges.

Used In

PurchasingGeneral Ledger

Related

Requisition-to-PO-to-receipt data model

PO_REQUISITION_HEADERS_ALL/LINES_ALL capture the requisition; PO_HEADERS_ALL/LINES_ALL the resulting purchase order; RCV_SHIPMENT_HEADERS/LINES the receipt against it. PO_DISTRIBUTIONS_ALL links a PO line to its requisition line and GL charge account.

PO line → schedule → distribution → receipt

A PO line (PO_LINES_ALL) has one or more schedules (PO_LINE_LOCATIONS_ALL) that carry the ship-to and need-by date; each schedule has accounting distributions (PO_DISTRIBUTIONS_ALL). Receipts (RCV_TRANSACTIONS) and AP invoice matching both reference the schedule's LINE_LOCATION_ID for three-way match.

Ask Oracle AI about PO_DISTRIBUTIONS_ALL