View: OKL_TRX_CONTRACTS_LOV_UV

Product:	OKL - Lease and Finance Management
Description:	This view contains all the Lease Contracts and Investor Agreements. This is used in View Transactions Contracts LOV.
Implementation/DBA Data:	APPS.OKL_TRX_CONTRACTS_LOV_UV

View Text

SELECT CHRB.ID ID
, CHRB.STS_CODE STS_CODE
, CHRB.SCS_CODE SCS_CODE
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, CHRB.CURRENCY_CODE CURRENCY_CODE
, CHRT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, CHRT.DESCRIPTION DESCRIPTION
, KHR.KHR_ID KHR_ID
, KHR.PDT_ID PDT_ID
, OP.NAME PRODUCT_NAME
FROM OKC_K_HEADERS_B CHRB
, OKC_K_HEADERS_TL CHRT
, OKL_K_HEADERS KHR
, OKL_PRODUCTS OP
WHERE CHRB.ID = CHRT.ID
AND CHRT.LANGUAGE = USERENV('LANG')
AND KHR.ID = CHRB.ID
AND OP.ID = KHR.PDT_ID
AND CHRB.SCS_CODE IN ('LEASE'
, 'INVESTOR')

Columns