View: OKL_AM_ASSETS_UV

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

View Text

SELECT OALV.ID ASSET_ID
, OALV.STS_CODE STATUS
, OALV.END_DATE END_DATE_ACTIVE
, OALV.START_DATE START_DATE_ACTIVE
, OALV.DATE_TERMINATED
, OALV.ID ID
, '#' ID2
, OALV.NAME
, OALV.ITEM_DESCRIPTION
, OALV.ITEM_DESCRIPTION DESCRIPTION
, OALV.CHR_ID
, OKHFV.ID DNZ_CHR_ID
, OALV.LINE_NUMBER
, OALV.NAME ASSET_NUMBER
, KLE.OEC COST
, OKHFV.CONTRACT_NUMBER
, OKHFV.START_DATE
, OKHFV.END_DATE
, OKHFV.ID CONTRACT_ID
, OKL_AM_UTIL_PVT.GET_ASSET_QUANTITY (OALV.ID) QUANTITY
, OKHFV.STS_CODE CONTRACT_STATUS
, SYSDATE EFFECTIVE_FROM
, NULL SPLIT_KLE_NAME
FROM OKC_K_LINES_V OALV
, OKL_K_LINES KLE
, OKC_K_HEADERS_B OKHFV
, OKC_LINE_STYLES_B LSE
WHERE OALV.ID = KLE.ID
AND LSE.LTY_CODE = 'FREE_FORM1'
AND OALV.LSE_ID = LSE.ID
AND OKHFV.ID = OALV.DNZ_CHR_ID
AND OALV.STS_CODE = OKHFV.STS_CODE
AND OALV.STS_CODE <> 'ABANDONED'

Columns