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

Source

View Text - Preformatted


SELECT TRQ.REQUEST_NUMBER REQUEST_NUMBER ,TRQ.ID REQUEST_ID ,TRQ.DNZ_KHR_ID KHR_ID ,TRQ.REQUEST_STATUS_CODE REQUEST_STATUS_CODE ,STAT.MEANING REQUEST_STATUS ,TRQ.REQUEST_TYPE_CODE REQUEST_TYPE_CODE ,TYPE.MEANING REQUEST_TYPE ,TRQ.COMMENTS COMMENTS ,TRQ.CREATION_DATE REQUEST_DATE ,TRQ.PARENT_KHR_ID PARENT_KHR_ID FROM OKL_TRX_REQUESTS TRQ,FND_LOOKUPS STAT,FND_LOOKUPS TYPE WHERE TRQ.REQUEST_STATUS_CODE = STAT.LOOKUP_CODE AND STAT.LOOKUP_TYPE = 'OKL_REQUEST_STATUS' AND TRQ.REQUEST_TYPE_CODE = TYPE.LOOKUP_CODE AND TYPE.LOOKUP_TYPE = 'OKL_REQUEST_TYPE'

View Text - HTML Formatted

SELECT TRQ.REQUEST_NUMBER REQUEST_NUMBER
, TRQ.ID REQUEST_ID
, TRQ.DNZ_KHR_ID KHR_ID
, TRQ.REQUEST_STATUS_CODE REQUEST_STATUS_CODE
, STAT.MEANING REQUEST_STATUS
, TRQ.REQUEST_TYPE_CODE REQUEST_TYPE_CODE
, TYPE.MEANING REQUEST_TYPE
, TRQ.COMMENTS COMMENTS
, TRQ.CREATION_DATE REQUEST_DATE
, TRQ.PARENT_KHR_ID PARENT_KHR_ID
FROM OKL_TRX_REQUESTS TRQ
, FND_LOOKUPS STAT
, FND_LOOKUPS TYPE
WHERE TRQ.REQUEST_STATUS_CODE = STAT.LOOKUP_CODE
AND STAT.LOOKUP_TYPE = 'OKL_REQUEST_STATUS'
AND TRQ.REQUEST_TYPE_CODE = TYPE.LOOKUP_CODE
AND TYPE.LOOKUP_TYPE = 'OKL_REQUEST_TYPE'