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

PO_LINE_LOCATIONS_ALL

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

Key Columns

LINE_LOCATION_IDPO_HEADER_IDPO_LINE_IDSHIPMENT_NUMQUANTITYQUANTITY_RECEIVEDQUANTITY_BILLEDNEED_BY_DATESHIP_TO_LOCATION_ID

Parent Table

PO_LINES_ALL

PO line — item, quantity, unit price.

Common Joins

PO_DISTRIBUTIONS_ALLvia LINE_LOCATION_ID

The accounting distributions charged from this schedule.

RCV_TRANSACTIONSvia PO_LINE_LOCATION_ID = LINE_LOCATION_ID

Receipts against this schedule.

Used In

PurchasingReceivingAP

Related

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_LINE_LOCATIONS_ALL