View: OKL_LA_BOOK_DEPRN_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for asset book depreciation page
Implementation/DBA Data:	APPS.OKL_LA_BOOK_DEPRN_UV

View Text

SELECT TXL.ID
, TXL.KLE_ID
, TXL.DNZ_KHR_ID
, TXL.ASSET_NUMBER
, CLT.ITEM_DESCRIPTION DESCRIPTION
, TXL.CORPORATE_BOOK
, TXL.IN_SERVICE_DATE
, NVL(TO_CHAR(LIFE_IN_MONTHS)
, '') LIFE_IN_MONTHS
, TO_CHAR(TXL.DEPRECIATION_ID) CATEGORY_ID
, CAT.NAME CATEGORY_NAME
, TO_CHAR(TXL.DEPRECIATION_COST) DEPRECIATION_COST
, TXL.DEPRN_METHOD
, NVL(TO_CHAR(DEPRN_RATE*100)
, '') DEPRN_RATE
, TO_CHAR(TXL.SALVAGE_VALUE) SALVAGE_VALUE
, TO_CHAR(TXL.PERCENT_SALVAGE_VALUE) PERCENT_SALVAGE_VALUE
, TO_CHAR(TXL.FA_COST) FA_COST
, TO_CHAR(NVL(CLEB.ORIG_SYSTEM_ID1
, '-9999')) ORIG_SYSTEM_ID1
FROM OKL_TXL_ASSETS_B TXL
, OKX_ASST_CATGRS_V CAT
, OKC_K_LINES_TL CLT
, OKC_K_LINES_B CLEB
WHERE TXL.DEPRECIATION_ID = CAT.ID1(+)
AND CLT.ID = TXL.KLE_ID
AND CLT.LANGUAGE = USERENV('LANG')
AND CLEB.ID = CLT.ID

Columns