VIEW: APPS.OKL_CS_CONTRACT_VERSION_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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