PO_REQUISITION_HEADERS_ALL

Purchasing

Table Or View: Table

Important columns: 

REQUISITION_HEADER_ID : Requisition header unique identifier
PREPARER_ID : Unique identifier of the employee who prepared the requisition
SEGMENT1 : Requisition number
AUTHORIZATION_STATUS :  Authorization status type
NOTE_TO_AUTHORIZER :  Note to approver (Unused since release 8.0)
TYPE_LOOKUP_CODE : Requisition type
TRANSFERRED_TO_OE_FLAG : Indicates whether an internal requisition has been transferred to Order Management.
INTERFACE_SOURCE_CODE : Source of requisition from Requisition Import
CLOSED_CODE : Close status
ORG_ID : Operating unit unique identifier

Description: 

PO_REQUISITION_HEADERS_ALL stores information about requisition headers. You need one row for each requisition header you create. Each row contains the requisition number, preparer, status, and description.

REQUISITION_HEADER_ID is the unique system-generated requisition number. 

REQUISITION_HEADER_ID is invisible to the user. SEGMENT1 is the number you use to identify the requisition in forms and reports. Oracle Purchasing generates SEGMENT1 using the PO_UNIQUE_IDENTIFIER_CONTROL table if you choose to let Oracle Purchasing generate requisition numbers for you.

 

PO_REQUISITION_HEADERS_ALL is one of three tables storing requisition information.  

O_REQUISITION_HEADERS_ALL corresponds to the Header region of the Requisitions window.  SEGMENT1 provides unique values for each row in the table in addition to REQUISITION_HEADER_ID.