eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_CS_TRANSFER_ASSUMPTION_UV

Source

View Text - Preformatted


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(+)

View Text - HTML Formatted

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(+)