View: OKL_CS_CONTRACT_VERSION_UV

Product:	OKL - Lease and Finance Management
Description:	Lists the contract versions
Implementation/DBA Data:	APPS.OKL_CS_CONTRACT_VERSION_UV

View Text

SELECT DISTINCT OKCH.ID
, OKLH.MAJOR_VERSION
, MAX(TRUNC(TRX.DATE_TRANSACTION_OCCURRED))
, FNDV.MEANING REEBOOK_REASON
, OKCH.CONTRACT_NUMBER
FROM FND_LOOKUPS FNDV
, OKC_K_HEADERS_BH OKCH
, OKL_K_HEADERS_H OKLH
, OKL_TRX_CONTRACTS_ALL TRX
, FND_LOOKUPS FND
WHERE OKCH.ID=OKLH.ID
AND OKLH.ID = TRX.KHR_ID
AND FND.LOOKUP_TYPE = 'OKL_TCN_TYPE'
AND FND.LOOKUP_CODE IN ('TRBK'
, 'SPLC'
, 'PGL'
, 'TMT'
, 'TAA'
, 'ACL'
, 'ALT'
, 'BKG'
, 'MAE'
, 'PSP')
AND FND.LOOKUP_CODE = TRX.TCN_TYPE(+)
AND FNDV.LOOKUP_TYPE(+) = TRX.RBR_CODE GROUP BY OKCH.CONTRACT_NUMBER
, OKLH.MAJOR_VERSION
, OKCH.ID
, FNDV.MEANING ORDER BY OKLH.MAJOR_VERSION DESC

Columns