[Home] [Help]
View: OKL_LA_ASST_TAX_DEPRN_UV
Product: | OKL - Lease 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
Name |
ID |
TAL_ID |
ASSET_NUMBER |
DESCRIPTION |
QUANTITY |
COST |
TAX_BOOK |
LIFE_IN_MONTHS_TAX |
DEPRN_METHOD_TAX |
DEPRN_RATE_TAX |