Base tables for Purchase Requisition | Oracle Apps Technical
The base tables for reference while creating a purchase requisition in Oracle Apps is as follows:
The base tables for reference while creating a purchase requisition in Oracle Apps is as follows:
1. PO_REQUISITION_HEADERS_ALL (SEGMENT1 column in this table represents the requisition number)
This table stores Header information of a Purchase Requisition.
Important columns of this table:
REQUISITION_HEADER_ID: It is a unique system generated Requisition identifier
PREPARER_ID: It is a unique identifier of the employee who prepared the requisition
SEGMENT1: It is the Requisition number
AUTHORIZATION_STATUS: Authorization status type
TYPE_LOOKUP_CODE: Requisition type
ORG_ID: Unique Operating unit unique identifier
You can get REQUISITION_HEADER_ID by executing the following command:
Select REQUISITION_HEADER_ID FROM PO_REQUISITION_HEADERS_ALL WHERE SEGMENT1= 14303; –14303 is our Requisition Number
Result: REQUISITION_HEADER_ID = 181232
REQUISITION_HEADER_ID is the link betweenPO_REQUISITION_HEADERS_ALL and PO_REQUISITION_LINES_ALL
2. PO_REQUISITION_LINES_ALL
This table stores information about Requisition lines in a Purchase Requisition. This table stores information related to the line number, item number, item category, item description, item quantities, units, prices, need-by date, deliver-to location, requestor, notes, and suggested supplier information for the requisition line.
Important columns of this table:
REQUISITION_HEADER_ID: It is a unique system generated Requisition identifier
REQUISITION_LINE_ID: Link between PO_REQUISITION_LINES_ALL And PO_REQ_DISTRIBUTIONS_ALL
LINE_NUM: Indicates the Line number
LINE_TYPE_ID: Indicates the Line type
CATEGORY_ID: Unique Item category identifier
ITEM_DESCRIPTION: Description of the Item
QUANTITY NUMBER: Quantity ordered
QUANTITY NUMBER: Quantity ordered
SELECT REQUISITION_LINE_ID FROM PO_REQUISITION_LINES_ALL WHERE REQUISITION_HEADER_ID=181232;
Result: REQUISITION_LINE_ID = 208442
3. PO_REQ_DISTRIBUTIONS_ALL
This table stores information about the accounting distributions of a requisition line. Each requisition line must have at least one accounting distribution. Each row includes the Accounting Flexfield ID and Requisition line quantity.
Important columns of this table:
DISTRIBUTION_ID: Unique Requisition distribution identifier
REQUISITION_LINE_ID: Unique Requisition line identifier
CODE_COMBINATION_ID: Unique General Ledger charge account identifier
DISTRIBUTION_NUM: Distribution number
REQUISITION_LINE_ID: Unique Requisition line identifier
CODE_COMBINATION_ID: Unique General Ledger charge account identifier
DISTRIBUTION_NUM: Distribution number
SELECT DISTRIBUTION_ID FROM PO_REQ_DISTRIBUTIONS_ALL WHERE REQUISITION_LINE_ID= 208442;
Result: DISTRIBUTION_ID= 206959
You can view results by executing the following SQL commands:
SELECT CREATION_DATE, AUTHORIZATION_STATUS, SEGMENT1, TYPE_LOOKUP_CODE from PO_REQUISITION_HEADERS_ALL where SEGMENT1= ’14303′;
Viewing results by executing SQL command
SELECT CREATION_DATE, CREATED_BY, ORG_ID, REQ_LINE_QUANTITY FROM PO_REQ_DISTRIBUTIONS_ALL WHERE REQUISITION_LINE_ID=208442;
viewing results by executing SQL command
0 comments