VIEW: APPS.OKL_CS_HEADER_VERSION_UV

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'