View: OKL_AM_ASSET_DETAILS_UV

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

View Text

SELECT CLEV.ID ID
, CLEV.NAME NAME
, CLEV.ITEM_DESCRIPTION ITEM_DESCRIPTION
, CLEV.CHR_ID CHR_ID
, OKHV.CONTRACT_NUMBER CONTRACT_NUMBER
, OKHV.STS_CODE CONTRACT_STATUS
, CLEV.START_DATE START_DATE
, CLEV.END_DATE END_DATE
, CLEV.STS_CODE LINE_STATUS
, OALV.COST ORIGINAL_COST
, OALV.SERIAL_NUMBER SERIAL_NUMBER
, OALV.IN_SERVICE_DATE IN_SERVICE_DATE
, OALV.MANUFACTURER_NAME MANUFACTURER_NAME
, OALV.MODEL_NUMBER MODEL_NUMBER
, OALV.ASSET_TYPE ASSET_TYPE
, OALV.LIFE_IN_MONTHS LIFE_IN_MONTHS
, OALV.NEW_USED NEW_USED
, OALV.SALVAGE_VALUE SALVAGE_VALUE
, OALV.DEPRECIATION_CATEGORY DEPRECIATION_CATEGORY
, OALV.DEPRN_START_DATE DEPRN_START_DATE
, FAC.DESCRIPTION DEPRN_CATEGORY_DESC
FROM OKL_K_LINES_FULL_V CLEV
, OKX_ASSET_LINES_V OALV
, OKC_K_HEADERS_B OKHV
, OKC_LINE_STYLES_V LSEV
, FA_CATEGORIES_VL FAC
WHERE CLEV.ID = OALV.PARENT_LINE_ID(+)
AND CLEV.CHR_ID = OKHV.ID
AND CLEV.LSE_ID = LSEV.ID
AND LSEV.LTY_CODE = 'FREE_FORM1'
AND FAC.CATEGORY_ID (+) = OALV.DEPRECIATION_CATEGORY

Columns