View: OKL_CS_REQUESTS_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_CS_REQUESTS_UV

View Text

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'

Columns