View: OKL_LA_ASSET_DTLS_UV

Product:	OKL - Lease and Finance Management
Description:	User Interface view for asset details page
Implementation/DBA Data:	APPS.OKL_LA_ASSET_DTLS_UV

View Text

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

Columns