View: ICX_PO_REQ_HEADERS_V

Product:	ICX - Oracle iProcurement
Description:	Requistion Headers View
Implementation/DBA Data:	APPS.ICX_PO_REQ_HEADERS_V

View Text

SELECT PRH.ROWID ROW_ID
, PRH.AGENT_RETURN_NOTE AGENT_RETURN_NOTE
, PRH.AUTHORIZATION_STATUS AUTHORIZATION_STATUS
, PRH.DESCRIPTION DESCRIPTION
, PRH.END_DATE_ACTIVE END_DATE_ACTIVE
, PRH.GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT
, PRH.NOTE_TO_AUTHORIZER NOTE_TO_AUTHORIZER
, PRH.PREPARER_FINISHED_DATE PREPARER_FINISHED_DATE
, PRH.START_DATE_ACTIVE START_DATE_ACTIVE
, PRH.INTERFACE_SOURCE_LINE_ID INTERFACE_SOURCE_LINE_ID
, PRH.PREPARER_ID PREPARER_ID
, PRH.REQUISITION_HEADER_ID
, PRH.INTERFACE_SOURCE_CODE
, PRH.TYPE_LOOKUP_CODE
, PRH.USSGL_TRANSACTION_CODE
, PRH.AGENT_RETURN_FLAG
, DECODE(PRH.AUTHORIZATION_STATUS
, 'CANCELLED'
, 'Y'
, NULL) CANCEL_FLAG
, 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 REQUISITION_NUM
, 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
, HRV.FULL_NAME PREPARER_NAME
, PLC_STA.DISPLAYED_FIELD AUTHORIZATION_STATUS_DSP
, PO_REQS_INQ_SV.GET_RESERVED_FLAG (REQUISITION_HEADER_ID) RESERVED_FLAG
, PODT.TYPE_NAME DOCUMENT_TYPE_DSP
, TO_CHAR( PO_REQUISITION_HEADERS_PKG.GET_REQ_TOTAL(REQUISITION_HEADER_ID)
, FND_CURRENCY.GET_FORMAT_MASK( SOB.CURRENCY_CODE
, 30 )) REQ_HEADER_AMOUNT
, SOB.CURRENCY_CODE CURRENCY_CODE
, FLK2.MEANING CLOSED_CODE_DSP
, DECODE(PRH.CLOSED_CODE
, NULL
, 'NO'
, 'YES') CLOSED_CODE_DSP
, FLK.MEANING CANCEL_DSP
FROM GL_SETS_OF_BOOKS SOB
, FINANCIALS_SYSTEM_PARAMETERS FSP
, PO_LOOKUP_CODES PLC_STA
, FND_LOOKUPS FLK
, FND_LOOKUPS FLK2
, PO_DOCUMENT_TYPES PODT
, HR_EMPLOYEES HRV
, PO_REQUISITION_HEADERS PRH
WHERE PLC_STA.LOOKUP_CODE = NVL(PRH.AUTHORIZATION_STATUS
, 'INCOMPLETE')
AND PLC_STA.LOOKUP_TYPE = 'AUTHORIZATION STATUS'
AND PODT.DOCUMENT_TYPE_CODE = 'REQUISITION'
AND PODT.DOCUMENT_SUBTYPE = PRH.TYPE_LOOKUP_CODE
AND PRH.PREPARER_ID = HRV.EMPLOYEE_ID
AND SOB.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID
AND FLK.LOOKUP_TYPE = 'YES_NO'
AND FLK.LOOKUP_CODE = NVL(PRH.CANCEL_FLAG
, 'N')
AND FLK2.LOOKUP_TYPE = 'YES_NO'
AND FLK2.LOOKUP_CODE = NVL(PRH.CLOSED_CODE
, 'N')

Columns