VIEW: APPS.OKL_TRX_CONTRACTS_LOV_UV

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')