View: POR_VIEW_HEADER_ALL_V

Product:	ICX - Oracle iProcurement
Description:	View Requsition Header view
Implementation/DBA Data:	APPS.POR_VIEW_HEADER_ALL_V

View Text

SELECT PRH.REQUISITION_HEADER_ID
, PRH.SEGMENT1
, PRH.PREPARER_ID
, HRE.FULL_NAME
, PRH.DESCRIPTION
, PRH.NOTE_TO_AUTHORIZER
, PRH.AUTHORIZATION_STATUS
, PLC_AUTH.DISPLAYED_FIELD
, POR_VIEW_REQS_PKG.GET_URGENT_FLAG(PRH.REQUISITION_HEADER_ID)
, PRH.PCARD_ID
, APC.CARD_NUMBER
, APC.DESCRIPTION
, POR_VIEW_REQS_PKG.GET_NOTE_TO_AGENT(PRH.REQUISITION_HEADER_ID)
, TO_CHAR(PRH.CREATION_DATE
, FND_PROFILE.VALUE_WNPS('ICX_DATE_FORMAT_MASK'))
, TO_CHAR(POR_VIEW_REQS_PKG.GET_REQ_TOTAL(PRH.REQUISITION_HEADER_ID)
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(SOB.CURRENCY_CODE
, 30))
, POR_VIEW_REQS_PKG.GET_REQUESTER(PRH.REQUISITION_HEADER_ID)
, POR_VIEW_REQS_PKG.GET_REQUESTER(PRH.REQUISITION_HEADER_ID) || '
' || POR_VIEW_REQS_PKG.GET_DELIVER_TO(PRH.REQUISITION_HEADER_ID)
, PRH.EMERGENCY_PO_NUM
, 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
FROM PO_LOOKUP_CODES PLC_AUTH
, PER_ALL_PEOPLE_F HRE
, PO_REQUISITION_HEADERS_ALL PRH
, AP_CARDS_ALL APC
, GL_SETS_OF_BOOKS SOB
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
WHERE SYSDATE BETWEEN HRE.EFFECTIVE_START_DATE
AND HRE.EFFECTIVE_END_DATE
AND PRH.PREPARER_ID = HRE.PERSON_ID
AND APC.CARD_ID (+) = PRH.PCARD_ID
AND PLC_AUTH.LOOKUP_CODE = NVL(PRH.AUTHORIZATION_STATUS
, 'INCOMPLETE')
AND PLC_AUTH.LOOKUP_TYPE = 'AUTHORIZATION STATUS'
AND SOB.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID
AND NVL(FSP.ORG_ID
, -1) = NVL(PRH.ORG_ID
, -1)

Columns