Oracle Fusion/Procurement/Purchasing

PO_LINES_ALL

PO line — item, quantity, unit price.

Key Columns

PO_LINE_IDPO_HEADER_IDITEM_IDQUANTITYUNIT_PRICE

Parent Table

PO_HEADERS_ALL

Purchase order header — supplier, PO type, status.

Child Tables

PO_DISTRIBUTIONS_ALL

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

PO_LINE_LOCATIONS_ALL

PO schedules (shipments) — the delivery-level detail: ship-to, need-by date, quantity, price and match option.

Common Joins

PO_HEADERS_ALLvia PO_HEADER_ID

The PO header this line belongs to — supplier, PO type, status.

PO_DISTRIBUTIONS_ALLvia PO_LINE_ID

The charge account and accounting distribution for this line.

RCV_SHIPMENT_LINESvia PO_LINE_ID

What's been received against this line so far.

Used In

Purchasing

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.