View: OKL_ASSET_ADJUST_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view used for Asset Adjustment screen
Implementation/DBA Data:	APPS.OKL_ASSET_ADJUST_UV

View Text

SELECT KLE.ID ID
, CLE.STS_CODE STS_CODE
, CLE.DNZ_CHR_ID DNZ_CHR_ID
, CLE.CLE_ID CLE_ID
, CLE.LSE_ID LSE_ID
, KLE.STY_ID STY_ID
, CLET.NAME ASSET_NUMBER
, CLET.ITEM_DESCRIPTION DESCRIPTION
, TO_CHAR(KLE.CAPITAL_REDUCTION) CAPITAL_REDUCTION
, TO_CHAR(KLE.TRADEIN_AMOUNT) TRADEIN_AMOUNT
, TO_CHAR(KLE.CAPITAL_REDUCTION_PERCENT) CAPITAL_REDUCTION_PERCENT
, TO_CHAR(KLE.CAPITAL_AMOUNT) CAPITAL_AMOUNT
, TO_CHAR(KLE.OEC) OEC
, KLE.CAPITALIZE_DOWN_PAYMENT_YN CAPITALIZE_DOWN_PAYMENT_YN
, KLE.DOWN_PAYMENT_RECEIVER_CODE DOWN_PAYMENT_RECEIVER_CODE
FROM OKC_LINE_STYLES_B LSE
, OKC_K_LINES_B CLE
, OKL_K_LINES KLE
, OKC_K_LINES_TL CLET
WHERE KLE.ID = CLE.ID
AND KLE.ID = CLET.ID
AND CLET.LANGUAGE = USERENV('LANG')
AND CLE.LSE_ID = LSE.ID
AND LSE.LTY_CODE = 'FREE_FORM1'

Columns