View: PO_REQUISITION_HEADERS_INQ_V

Product:	PO - Purchasing
Description:	10SC ONLY - Retrofitted
Implementation/DBA Data:	APPS.PO_REQUISITION_HEADERS_INQ_V

View Text

SELECT PRH.ROWID
, PRH.AGENT_RETURN_NOTE
, PRH.AUTHORIZATION_STATUS
, PRH.DESCRIPTION
, PRH.END_DATE_ACTIVE
, PRH.GOVERNMENT_CONTEXT
, PRH.NOTE_TO_AUTHORIZER
, PRH.PREPARER_FINISHED_DATE
, PRH.START_DATE_ACTIVE
, PRH.INTERFACE_SOURCE_LINE_ID
, PRH.PREPARER_ID
, PRH.REQUISITION_HEADER_ID
, NVL(PRH.CLOSED_CODE
, 'OPEN')
, PRH.INTERFACE_SOURCE_CODE
, PRH.TYPE_LOOKUP_CODE
, PRH.USSGL_TRANSACTION_CODE
, PRH.AGENT_RETURN_FLAG
, DECODE(PRH.AUTHORIZATION_STATUS
, 'CANCELLED'
, 'Y'
, NULL)
, PRH.ENABLED_FLAG
, PRH.ON_LINE_FLAG
, PRH.PRELIMINARY_RESEARCH_FLAG
, PRH.PREPARER_FINISHED_FLAG
, PRH.RESEARCH_COMPLETE_FLAG
, PRH.SUMMARY_FLAG
, PRH.TRANSFERRED_TO_OE_FLAG
, PRH.CREATED_BY
, PRH.CREATION_DATE
, PRH.LAST_UPDATED_BY
, PRH.LAST_UPDATE_DATE
, PRH.LAST_UPDATE_LOGIN
, PRH.PROGRAM_APPLICATION_ID
, PRH.PROGRAM_ID
, PRH.PROGRAM_UPDATE_DATE
, PRH.REQUEST_ID
, PRH.SEGMENT1
, PRH.SEGMENT2
, PRH.SEGMENT3
, PRH.SEGMENT4
, PRH.SEGMENT5
, PRH.ATTRIBUTE1
, PRH.ATTRIBUTE2
, PRH.ATTRIBUTE3
, PRH.ATTRIBUTE4
, PRH.ATTRIBUTE5
, PRH.ATTRIBUTE6
, PRH.ATTRIBUTE7
, PRH.ATTRIBUTE8
, PRH.ATTRIBUTE9
, PRH.ATTRIBUTE10
, PRH.ATTRIBUTE11
, PRH.ATTRIBUTE12
, PRH.ATTRIBUTE13
, PRH.ATTRIBUTE14
, PRH.ATTRIBUTE15
, PRH.ATTRIBUTE_CATEGORY
, PLC_STA.DISPLAYED_FIELD
, PODT.TYPE_NAME
, PRH.CONTRACTOR_REQUISITION_FLAG
, PRH.ORG_ID
, PODB.SECURITY_LEVEL_CODE
FROM PO_LOOKUP_CODES PLC_STA
, PO_DOCUMENT_TYPES_ALL_TL PODT
, PO_DOCUMENT_TYPES_ALL_B PODB
, PO_REQUISITION_HEADERS PRH
WHERE PLC_STA.LOOKUP_CODE = NVL(PRH.AUTHORIZATION_STATUS
, 'INCOMPLETE')
AND PLC_STA.LOOKUP_TYPE = 'AUTHORIZATION STATUS'
AND PODB.DOCUMENT_TYPE_CODE = 'REQUISITION'
AND PODB.DOCUMENT_SUBTYPE = PRH.TYPE_LOOKUP_CODE
AND PODT.ORG_ID = PRH.ORG_ID
AND PODB.DOCUMENT_TYPE_CODE = PODT.DOCUMENT_TYPE_CODE
AND PODB.DOCUMENT_SUBTYPE = PODT.DOCUMENT_SUBTYPE
AND PODT.LANGUAGE = USERENV('LANG')
AND PODT.ORG_ID = PODB.ORG_ID

Columns