Wednesday, November 23, 2011

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.


No comments:

Post a Comment

Best Blogger TipsGet Flower Effect