eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PO.PO_REQUISITION_HEADERS_ALL

Object Details

Object Name:	PO_REQUISITION_HEADERS_ALL
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.PO_REQUISITION_HEADERS_ALL
Subobject Name:
Status:	VALID

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. PO_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.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_REQUISITION_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REQUISITION_HEADER_ID
PO_REQUISITION_HEADERS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SEGMENT1 ORG_ID REVISION_NUM
PO_REQUISITION_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PREPARER_ID CREATION_DATE
PO_REQUISITION_HEADERS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UDA_TEMPLATE_ID
PO_REQUISITION_HEADERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATION_DATE
PO_REQUISITION_HEADERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AUTHORIZATION_STATUS
PO_REQUISITION_HEADERS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSFERRED_TO_OE_FLAG
PO_REQUISITION_HEADERS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WF_ITEM_TYPE WF_ITEM_KEY
PO_REQUISITION_HEADERS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATE_DATE
PO_REQUISITION_HEADERS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTIVE_SHOPPING_CART_FLAG LAST_UPDATED_BY
PO_REQUISITION_HEADERS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EMERGENCY_PO_NUM
PO_REQUISITION_HEADERS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONFORMED_HEADER_ID REVISION_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
REQUISITION_HEADER_ID	NUMBER		Yes	Requisition header unique identifier
PREPARER_ID	NUMBER	(9)	Yes	Unique identifier of the employee who prepared the requisition
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
SEGMENT1	VARCHAR2	(20)	Yes	Key flexfield segment
SUMMARY_FLAG	VARCHAR2	(1)	Yes	Key flexfield summary flag
ENABLED_FLAG	VARCHAR2	(1)	Yes	Key flexfield enabled flag
SEGMENT2	VARCHAR2	(20)		Key flexfield segment
SEGMENT3	VARCHAR2	(20)		Key flexfield segment
SEGMENT4	VARCHAR2	(20)		Key flexfield segment
SEGMENT5	VARCHAR2	(20)		Key flexfield segment
START_DATE_ACTIVE	DATE			Key flexfield start date
END_DATE_ACTIVE	DATE			Key flexfield end date
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER			Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
DESCRIPTION	VARCHAR2	(240)		Description for requisition
AUTHORIZATION_STATUS	VARCHAR2	(25)		Authorization status type
NOTE_TO_AUTHORIZER	VARCHAR2	(4000)		Note to approver (Unused since release 8.0)
TYPE_LOOKUP_CODE	VARCHAR2	(25)		Requisition type
TRANSFERRED_TO_OE_FLAG	VARCHAR2	(1)		Indicates whether an internal requisition has been transferred to Order Management
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ON_LINE_FLAG	VARCHAR2	(1)		Unused since release 7.0
PRELIMINARY_RESEARCH_FLAG	VARCHAR2	(1)		Unused since release 7.0
RESEARCH_COMPLETE_FLAG	VARCHAR2	(1)		Unused since release 7.0
PREPARER_FINISHED_FLAG	VARCHAR2	(1)		Unused since release 7.0
PREPARER_FINISHED_DATE	DATE			Unused since release 7.0
AGENT_RETURN_FLAG	VARCHAR2	(1)		Unused since release 7.0
AGENT_RETURN_NOTE	VARCHAR2	(240)		Unused since release 7.0
CANCEL_FLAG	VARCHAR2	(1)		Unused since release 7.0
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		United States standard general ledger transaction code
GOVERNMENT_CONTEXT	VARCHAR2	(30)		USSGL descriptive flexfield context column
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER			Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
INTERFACE_SOURCE_CODE	VARCHAR2	(25)		Source of requisition from Requisition Import
INTERFACE_SOURCE_LINE_ID	NUMBER			Source requisition line identifier from Requisition Import
CLOSED_CODE	VARCHAR2	(25)		Close status
ORG_ID	NUMBER			Organization identifier
WF_ITEM_TYPE	VARCHAR2	(8)		Approval workflow item type
WF_ITEM_KEY	VARCHAR2	(240)		Approval workflow item key
EMERGENCY_PO_NUM	VARCHAR2	(20)		Purchase order number reserved in advance for an emergency requisition
PCARD_ID	NUMBER	(15)		Unique dentifer for procurement card used for the order
APPS_SOURCE_CODE	VARCHAR2	(25)		Application source code, indicating the creation method for the requisition
CBC_ACCOUNTING_DATE	DATE			Column used to store the accounting action date for dual budgetary controls
CHANGE_PENDING_FLAG	VARCHAR2	(1)		Indicates whether requisition is in Change Order process or not
ACTIVE_SHOPPING_CART_FLAG	VARCHAR2	(1)		Set to 'Y' to indicate that this requisition should be shown to the user when he/she logs into iProcurement.
CONTRACTOR_STATUS	VARCHAR2	(25)		The status of the resource finalization process for temp labor reqs
CONTRACTOR_REQUISITION_FLAG	VARCHAR2	(1)		Flag to indicate whether the requisition is a regular req or a temp labor req
SUPPLIER_NOTIFIED_FLAG	VARCHAR2	(1)		Indicates if a notification is sent to the supplier
EMERGENCY_PO_ORG_ID	NUMBER			The org_id of the operating unit from which the emergency_po_num is derived. This field completely qualifies the emergency_po_num field. (Starting FPJ, it is possible to create an emergency PO in another operating unit.)
APPROVED_DATE	DATE			Date when Requisition is submitted for approval
TAX_ATTRIBUTE_UPDATE_CODE	VARCHAR2	(15)		Keeps track of create/update actions on this entity
FIRST_APPROVER_ID	NUMBER			Unique identifier of the first approver in the approval hierarchy.
FIRST_POSITION_ID	NUMBER			Unique identifier of the first position in the position hierarchy.
FEDERAL_FLAG	VARCHAR2	(1)		States whether this is a federal requisition.
CONFORMED_HEADER_ID	NUMBER			Populated only for Amendment records and stores the requisition_header_id of the parent requisition header
REVISION_NUM	NUMBER			Stores the revision number for amendments. Value of null means original requisition
AMENDMENT_TYPE	VARCHAR2	(30)		Used for PR Amendment and shows the type of change. Possible values are ADDED, CHANGED, CANCELLED
AMENDMENT_STATUS	VARCHAR2	(3)		Used for PR Amendment and stores the amendment status. Possible values are N - New, A - Accepted, R - Rejected, P - Pending
AMENDMENT_REASON	VARCHAR2	(4000)		Stores the amendment reason for amendment record
UDA_TEMPLATE_ID	NUMBER			Uda Template Id
UDA_TEMPLATE_DATE	DATE			Uda template date
CLM_ISSUING_OFFICE	VARCHAR2	(1000)		CLM Issuing Office.
CLM_COTR_OFFICE	VARCHAR2	(1000)		CLM COTR Office.
CLM_COTR_CONTACT	VARCHAR2	(400)		Contact of COTR.
CLM_PRIORITY_CODE	VARCHAR2	(400)		Maintains the CLM priority code.
SUGGESTED_AWARD_NO	VARCHAR2	(240)		Suggested Award Number.
CLM_ASSIST_OFFICE	NUMBER
CLM_MIPR_PREPARED_DATE	DATE
CLM_MIPR_REF_NUM	VARCHAR2	(30)
CLM_MIPR_TYPE	VARCHAR2	(30)
CLM_REQ_OFFICE	NUMBER
PAR_DRAFT_ID	NUMBER
PAR_FLAG	VARCHAR2	(1)
CLM_MIPR_ACKNOWLEDGED_FLAG	VARCHAR2	(1)
CLM_ASSIST_CONTACT	VARCHAR2	(240)		Contact Of Assisting Office
CLM_REQ_CONTACT	VARCHAR2	(240)		Contact of Requesting Office

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REQUISITION_HEADER_ID
,      PREPARER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      SEGMENT1
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      DESCRIPTION
,      AUTHORIZATION_STATUS
,      NOTE_TO_AUTHORIZER
,      TYPE_LOOKUP_CODE
,      TRANSFERRED_TO_OE_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ON_LINE_FLAG
,      PRELIMINARY_RESEARCH_FLAG
,      RESEARCH_COMPLETE_FLAG
,      PREPARER_FINISHED_FLAG
,      PREPARER_FINISHED_DATE
,      AGENT_RETURN_FLAG
,      AGENT_RETURN_NOTE
,      CANCEL_FLAG
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      INTERFACE_SOURCE_CODE
,      INTERFACE_SOURCE_LINE_ID
,      CLOSED_CODE
,      ORG_ID
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      EMERGENCY_PO_NUM
,      PCARD_ID
,      APPS_SOURCE_CODE
,      CBC_ACCOUNTING_DATE
,      CHANGE_PENDING_FLAG
,      ACTIVE_SHOPPING_CART_FLAG
,      CONTRACTOR_STATUS
,      CONTRACTOR_REQUISITION_FLAG
,      SUPPLIER_NOTIFIED_FLAG
,      EMERGENCY_PO_ORG_ID
,      APPROVED_DATE
,      TAX_ATTRIBUTE_UPDATE_CODE
,      FIRST_APPROVER_ID
,      FIRST_POSITION_ID
,      FEDERAL_FLAG
,      CONFORMED_HEADER_ID
,      REVISION_NUM
,      AMENDMENT_TYPE
,      AMENDMENT_STATUS
,      AMENDMENT_REASON
,      UDA_TEMPLATE_ID
,      UDA_TEMPLATE_DATE
,      CLM_ISSUING_OFFICE
,      CLM_COTR_OFFICE
,      CLM_COTR_CONTACT
,      CLM_PRIORITY_CODE
,      SUGGESTED_AWARD_NO
,      CLM_ASSIST_OFFICE
,      CLM_MIPR_PREPARED_DATE
,      CLM_MIPR_REF_NUM
,      CLM_MIPR_TYPE
,      CLM_REQ_OFFICE
,      PAR_DRAFT_ID
,      PAR_FLAG
,      CLM_MIPR_ACKNOWLEDGED_FLAG
,      CLM_ASSIST_CONTACT
,      CLM_REQ_CONTACT
FROM PO.PO_REQUISITION_HEADERS_ALL;

Dependencies

[top of page]

PO.PO_REQUISITION_HEADERS_ALL does not reference any database object

PO.PO_REQUISITION_HEADERS_ALL is referenced by following:

PO: PO_REQUISITION_HEADERS_ALL#