[Home] [Help]
View: OKL_CS_EQUIP_EXCHANGES_UV
View Text
SELECT OTA.TRANS_NUMBER REQUEST_NUMBER
, OTA.ID TAS_ID
, OTL.DNZ_KHR_ID KHR_ID
, OTA.TAS_TYPE REQUEST_TYPE_CODE
, TYPE.MEANING REQUEST_TYPE
, OTA.TSU_CODE REQUEST_STATUS_CODE
, STAT.MEANING REQUEST_STATUS
, OTA.COMMENTS COMMENTS
, OTA.CREATION_DATE CREATION_DATE
, OTL.ASSET_NUMBER ASSET_NUMBER
, USR.USER_NAME REQUESTED_BY
FROM FND_USER USR
, OKL_TRX_ASSETS OTA
, OKL_TXL_ASSETS_B OTL
, FND_LOOKUPS TYPE
, FND_LOOKUPS STAT
WHERE OTA.TAS_TYPE IN ('LLT'
, 'LLP'
, 'NLP')
AND OTA.ID = OTL.TAS_ID
AND OTL.TAL_TYPE = 'OAS'
AND OTA.TAS_TYPE = TYPE.LOOKUP_CODE(+)
AND TYPE.LOOKUP_TYPE(+) = 'OKL_TRANS_HEADER_TYPE'
AND OTA.TSU_CODE = STAT.LOOKUP_CODE(+)
AND STAT.LOOKUP_TYPE(+) = 'OKL_TRANSACTION_STATUS'
AND OTA.CREATED_BY = USR.USER_ID
Columns
Name |
REQUEST_NUMBER |
TAS_ID |
KHR_ID |
REQUEST_TYPE_CODE |
REQUEST_TYPE |
REQUEST_STATUS_CODE |
REQUEST_STATUS |
COMMENTS |
CREATION_DATE |
ASSET_NUMBER |
REQUESTED_BY |