VIEW: APPS.OKL_LA_ASSET_DTLS_UV

Source

View Text - Preformatted

SELECT CLEB.ID ID, CLEB.CLE_ID CLE_ID, CLEB.DNZ_CHR_ID DNZ_CHR_ID, CLEB.EXCEPTION_YN EXCEPTION_YN, to_char(KLE.RESIDUAL_PERCENTAGE) RESIDUAL_PERCENTAGE, KLE.PRESCRIBED_ASSET_YN PRESCRIBED_ASSET_YN, to_char(KLE.RESIDUAL_VALUE) RESIDUAL_VALUE, KLE.RE_LEASE_YN RE_LEASE_YN, KLE.PREVIOUS_CONTRACT PREVIOUS_CONTRACT, to_char(KLE.RESIDUAL_GRNTY_AMOUNT) RESIDUAL_GRNTY_AMOUNT, KLE.RESIDUAL_CODE RESIDUAL_CODE, to_char(KLE.RVI_PREMIUM) RVI_PREMIUM, to_char(KLE.DATE_DELIVERY_EXPECTED) DATE_DELIVERY_EXPECTED, to_char(KLE.DATE_FUNDING_EXPECTED) DATE_FUNDING_EXPECTED , to_char(KLE.EXPECTED_ASSET_COST) EXPECTED_ASSET_COST FROM OKC_K_LINES_B CLEB,OKC_K_LINES_TL CLET,OKL_K_LINES KLE WHERE CLEB.ID = CLET.ID and CLET.LANGUAGE = USERENV('LANG') AND KLE.ID = CLEB.ID

View Text - HTML Formatted

SELECT CLEB.ID ID
, CLEB.CLE_ID CLE_ID
, CLEB.DNZ_CHR_ID DNZ_CHR_ID
, CLEB.EXCEPTION_YN EXCEPTION_YN
, TO_CHAR(KLE.RESIDUAL_PERCENTAGE) RESIDUAL_PERCENTAGE
, KLE.PRESCRIBED_ASSET_YN PRESCRIBED_ASSET_YN
, TO_CHAR(KLE.RESIDUAL_VALUE) RESIDUAL_VALUE
, KLE.RE_LEASE_YN RE_LEASE_YN
, KLE.PREVIOUS_CONTRACT PREVIOUS_CONTRACT
, TO_CHAR(KLE.RESIDUAL_GRNTY_AMOUNT) RESIDUAL_GRNTY_AMOUNT
, KLE.RESIDUAL_CODE RESIDUAL_CODE
, TO_CHAR(KLE.RVI_PREMIUM) RVI_PREMIUM
, TO_CHAR(KLE.DATE_DELIVERY_EXPECTED) DATE_DELIVERY_EXPECTED
, TO_CHAR(KLE.DATE_FUNDING_EXPECTED) DATE_FUNDING_EXPECTED
, TO_CHAR(KLE.EXPECTED_ASSET_COST) EXPECTED_ASSET_COST
FROM OKC_K_LINES_B CLEB
, OKC_K_LINES_TL CLET
, OKL_K_LINES KLE
WHERE CLEB.ID = CLET.ID
AND CLET.LANGUAGE = USERENV('LANG')
AND KLE.ID = CLEB.ID