OracleOps AI
← All tables
Oracle Fusion/Procurement/Requisitions

PO_REQUISITION_HEADERS_ALL

Requisition header — preparer, requisitioning BU, status.

Key Columns

REQUISITION_HEADER_IDSEGMENT1PREPARER_IDAUTHORIZATION_STATUS

Child Tables

PO_REQUISITION_LINES_ALL

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

Common Joins

PO_REQUISITION_LINES_ALLvia REQUISITION_HEADER_ID

The individual item/quantity lines requested on this requisition.

Used In

RequisitionsSelf Service ProcurementProcure-to-Pay

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_HEADERS_ALL