[Home] [Help]
View: 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
Name |
REQUEST_NUMBER |
REQUEST_ID |
KHR_ID |
REQUEST_STATUS_CODE |
REQUEST_STATUS |
REQUEST_TYPE_CODE |
REQUEST_TYPE |
COMMENTS |
REQUEST_DATE |
PARENT_KHR_ID |