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.

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.