View: OKL_CS_HEADER_VERSION_UV

Product:	OKL - Lease and Finance Management
Description:	List of Header Versions
Implementation/DBA Data:	APPS.OKL_CS_HEADER_VERSION_UV

View Text

SELECT DISTINCT OKCH.ID
, OKCH.CONTRACT_NUMBER
, OKCH.MAJOR_VERSION
, TRUNC(TRX.DATE_TRANSACTION_OCCURRED) VERSION_DATE
, OKLH.TERM_DURATION
, OKCH.START_DATE
, OKCH.END_DATE
FROM OKL_K_HEADERS_H OKLH
, OKC_K_HEADERS_BH OKCH
, OKL_TRX_CONTRACTS_ALL TRX
WHERE OKLH.ID = OKCH.ID
AND OKLH.MAJOR_VERSION = OKCH.MAJOR_VERSION
AND OKCH.ID = TRX.KHR_ID
AND TSU_CODE ='PROCESSED'

Columns