View: OKL_LA_TRADEIN_UV

Product:	OKL - Lease and Finance Management
Description:	Trade-in Details View
Implementation/DBA Data:	APPS.OKL_LA_TRADEIN_UV

View Text

SELECT KLE.ID ID
, CLE.DNZ_CHR_ID DNZ_CHR_ID
, CLET.NAME ASSET_NUMBER
, TO_CHAR(KLE.TRADEIN_AMOUNT) TRADEIN_AMOUNT
, KLE.ID ASSET_ID
, CLET.ITEM_DESCRIPTION DESCRIPTION
, KLE.OEC ASSET_COST
, KLE.TRADEIN_AMOUNT AMOUNT
FROM OKC_STATUSES_B STS
, 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'
AND KLE.TRADEIN_AMOUNT IS NOT NULL
AND CLE.STS_CODE = STS.CODE
AND STS.STE_CODE NOT IN ('HOLD'
, 'EXPIRED'
, 'CANCELLED')

Columns