[Home] [Help]
View: 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
Name |
ID |
REQUEST_NUMBER |
STATUS_CODE |
STATUS |
EFFECTIVE_DATE |
REQUEST_TYPE |
MEANING |
COMPLETE_TRANSFER |
KHR_ID |
OLD_CONTRACT |
NEW_CONTRACT |
NEW_PARTY_ID |
NEW_LESSEE |
COMMENTS |