eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_LA_ASST_TAX_DEPRN_UV

Source

View Text - Preformatted


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')

View Text - HTML Formatted

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')