OracleOps AI
← All tables
Oracle Fusion/Procurement/Requisitions

PO_REQUISITION_LINES_ALL

Requisition line — item, quantity, need-by date, destination.

Key Columns

REQUISITION_LINE_IDREQUISITION_HEADER_IDITEM_IDQUANTITY

Parent Table

PO_REQUISITION_HEADERS_ALL

Requisition header — preparer, requisitioning BU, status.

Common Joins

PO_REQUISITION_HEADERS_ALLvia REQUISITION_HEADER_ID

The requisition header this line belongs to.

PO_DISTRIBUTIONS_ALLvia REQ_LINE_ID

The PO distribution created once this requisition line is converted into a purchase order.

Used In

Requisitions

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.

Ask Oracle AI about PO_REQUISITION_LINES_ALL