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.

VIEW: APPS.POR_VIEW_HEADER_ALL_V

Source

View Text - Preformatted


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)

View Text - HTML Formatted

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)