View: OKL_ASSETS_LOV_UV

Product:	OKL - Lease and Finance Management
Description:	User Interface view for Asset List of values
Implementation/DBA Data:	APPS.OKL_ASSETS_LOV_UV

View Text

SELECT CLE.ID CLE_ID
, CLE.DNZ_CHR_ID CHR_ID
, TL.NAME ASSET_NUMBER
, TL.ITEM_DESCRIPTION DESCRIPTION
FROM OKC_K_HEADERS_B CHR
, OKC_LINE_STYLES_B LSE
, OKC_K_LINES_B CLE
, OKC_STATUSES_B STS
, OKC_K_LINES_TL TL
WHERE CHR.ID = CLE.DNZ_CHR_ID
AND CHR.SCS_CODE IN ( 'LEASE'
, 'QUOTE')
AND CLE.ID = TL.ID
AND STS.CODE = CLE.STS_CODE
AND STS.STE_CODE NOT IN ('HOLD'
, 'EXPIRED'
, 'TERMINATED'
, 'CANCELLED')
AND TL.LANGUAGE=USERENV('LANG')
AND LSE.ID = CLE.LSE_ID
AND LSE.LTY_CODE = 'FREE_FORM1'

Columns