View: OKL_CS_TRANSFER_ASSUMPTION_UV

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

View Text

SELECT TRX.ID ID
, TRX.TRX_NUMBER REQUEST_NUMBER
, TRX.TSU_CODE STATUS_CODE
, STS.MEANING STATUS
, TRX.DATE_TRANSACTION_OCCURRED EFFECTIVE_DATE
, TRX.TCN_TYPE REQUEST_TYPE
, TYP.MEANING
, COMPLETE_TRANSFER_YN COMPLETE_TRANSFER
, TRX.KHR_ID
, TRX.KHR_ID_OLD OLD_CONTRACT
, TRX.KHR_ID_NEW NEW_CONTRACT
, TRX.PARTY_REL_ID2_NEW NEW_PARTY_ID
, HZP.PARTY_NAME NEW_LESSEE
, TRX.DESCRIPTION COMMENTS
FROM HZ_PARTIES HZP
, OKL_TRX_CONTRACTS TRX
, FND_LOOKUPS TYP
, FND_LOOKUPS STS
WHERE TRX.TCN_TYPE = 'TAA'
AND TRX.TCN_TYPE = TYP.LOOKUP_CODE
AND TYP.LOOKUP_TYPE = 'OKL_TCN_TYPE'
AND TRX.TSU_CODE = STS.LOOKUP_CODE
AND STS.LOOKUP_TYPE = 'OKL_TRANSACTION_STATUS'
AND TRX.PARTY_REL_ID2_NEW = HZP.PARTY_ID(+)

Columns