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: JA.JA_AU_SRW_TAX_DEPRN_TMP#

Source

View Text - Preformatted


select ASSET_ID ASSET_ID, ASSET_NUMBER ASSET_NUMBER, ASSET_DESC ASSET_DESC, CATEGORY_ID CATEGORY_ID, CATEGORY_NUMBER CATEGORY_NUMBER, CATEGORY_DESC CATEGORY_DESC, ORIGINAL_COST_START ORIGINAL_COST_START, ORIGINAL_COST_END ORIGINAL_COST_END, COST_START COST_START, COST_END COST_END, DEPRN_RSRVE_START DEPRN_RSRVE_START, DEPRN_RSRVE_END DEPRN_RSRVE_END, DEPRN_AMOUNT DEPRN_AMOUNT, ADDITION_DATE ADDITION_DATE, IN_SERVICE IN_SERVICE, DEPRN_RATE DEPRN_RATE, DEPRN_BASIS_RULE DEPRN_BASIS_RULE, NET_BOOK_VALUE NET_BOOK_VALUE, DATE_RETIRED DATE_RETIRED, BAL_CHG_APPLIED BAL_CHG_APPLIED, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "JA"."JA_AU_SRW_TAX_DEPRN_TMP"

View Text - HTML Formatted

SELECT ASSET_ID ASSET_ID
, ASSET_NUMBER ASSET_NUMBER
, ASSET_DESC ASSET_DESC
, CATEGORY_ID CATEGORY_ID
, CATEGORY_NUMBER CATEGORY_NUMBER
, CATEGORY_DESC CATEGORY_DESC
, ORIGINAL_COST_START ORIGINAL_COST_START
, ORIGINAL_COST_END ORIGINAL_COST_END
, COST_START COST_START
, COST_END COST_END
, DEPRN_RSRVE_START DEPRN_RSRVE_START
, DEPRN_RSRVE_END DEPRN_RSRVE_END
, DEPRN_AMOUNT DEPRN_AMOUNT
, ADDITION_DATE ADDITION_DATE
, IN_SERVICE IN_SERVICE
, DEPRN_RATE DEPRN_RATE
, DEPRN_BASIS_RULE DEPRN_BASIS_RULE
, NET_BOOK_VALUE NET_BOOK_VALUE
, DATE_RETIRED DATE_RETIRED
, BAL_CHG_APPLIED BAL_CHG_APPLIED
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "JA"."JA_AU_SRW_TAX_DEPRN_TMP"