View: OKL_LA_ASST_TAX_DEPRN_UV

Product:	OKL - Leasing and Finance Management
Description:	User interface view for tax book depreciation page
Implementation/DBA Data:	APPS.OKL_LA_ASST_TAX_DEPRN_UV

View Text

SELECT ASDB.ID ID
, ASDB.TAL_ID TAL_ID
, ASDB.ASSET_NUMBER ASSET_NUMBER
, ASDTL.DESCRIPTION DESCRIPTION
, ASDB.QUANTITY QUANTITY
, TO_CHAR(ASDB.COST) COST
, ASDB.TAX_BOOK TAX_BOOK
, NVL(TO_CHAR(ASDB.LIFE_IN_MONTHS_TAX)
, '') LIFE_IN_MONTHS_TAX
, ASDB.DEPRN_METHOD_TAX DEPRN_METHOD_TAX
, NVL(TO_CHAR(ASDB.DEPRN_RATE_TAX*100)
, '') DEPRN_RATE_TAX
FROM OKL_TXD_ASSETS_B ASDB
, OKL_TXD_ASSETS_TL ASDTL
WHERE ASDB.ID = ASDTL.ID
AND ASDTL.LANGUAGE = USERENV('LANG')

Columns