VIEW: APPS.OKL_CS_EQUIP_EXCHANGES_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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