View: OKL_AM_ASSET_LOV_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_AM_ASSET_LOV_UV

View Text

SELECT OALV.ID KLE_ID
, OALV.NAME ASSET_NUMBER
, OALV.ITEM_DESCRIPTION ASSET_DESCRIPTION
, OALV.CHR_ID CHR_ID
, OKHV.CONTRACT_NUMBER CONTRACT_NUMBER
, OKHV.START_DATE START_DATE
, OKHV.END_DATE EXPIRATION_DATE
, STS.CODE LINE_STS_CODE
, STS.MEANING LINE_STATUS
FROM OKC_K_LINES_V OALV
, OKC_K_HEADERS_B OKHV
, OKC_LINE_STYLES_B LSE
, OKC_STATUSES_V STS
WHERE LSE.LTY_CODE = 'FREE_FORM1'
AND OALV.LSE_ID = LSE.ID
AND OALV.CHR_ID = OKHV.ID
AND NOT EXISTS (SELECT KLE_ID
FROM OKL_ASSET_RETURNS_V OARV
WHERE OARV.KLE_ID = OALV.ID
AND OARV.ARS_CODE <> 'CANCELLED')
AND OALV.STS_CODE = STS.CODE
AND STS.STE_CODE NOT IN ('ENTERED'
, 'SIGNED'
, 'CANCELLED')

Columns