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.

[Home] [Help]

VIEW: FA.FA_MASS_REVAL_REP_ITF#

Source

View Text - Preformatted


select REQUEST_ID REQUEST_ID, MASS_REVAL_ID MASS_REVAL_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, TRANSACTION_DATE_ENTERED TRANSACTION_DATE_ENTERED, ASSET_ID ASSET_ID, ASSET_NUMBER ASSET_NUMBER, DESCRIPTION DESCRIPTION, ASSET_TYPE ASSET_TYPE, ASSET_CATEGORY_ID ASSET_CATEGORY_ID, CATEGORY CATEGORY, OLD_LIFE OLD_LIFE, NEW_LIFE NEW_LIFE, OLD_COST OLD_COST, NEW_COST NEW_COST, OLD_DEPRN_RESERVE OLD_DEPRN_RESERVE, NEW_DEPRN_RESERVE NEW_DEPRN_RESERVE, OLD_REVAL_RESERVE OLD_REVAL_RESERVE, NEW_REVAL_RESERVE NEW_REVAL_RESERVE, REVAL_CEILING REVAL_CEILING, REVAL_PERCENT REVAL_PERCENT, OVERRIDE_DEFAULTS OVERRIDE_DEFAULTS, REVAL_FULLY_RSVD REVAL_FULLY_RSVD, LIFE_EXTENSION_FACTOR LIFE_EXTENSION_FACTOR, LIFE_EXTENSION_CEILING LIFE_EXTENSION_CEILING, MAX_FULLY_RSVD_REVALS MAX_FULLY_RSVD_REVALS, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OLD_NBV OLD_NBV, NEW_NBV NEW_NBV from "FA"."FA_MASS_REVAL_REP_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, MASS_REVAL_ID MASS_REVAL_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, TRANSACTION_DATE_ENTERED TRANSACTION_DATE_ENTERED
, ASSET_ID ASSET_ID
, ASSET_NUMBER ASSET_NUMBER
, DESCRIPTION DESCRIPTION
, ASSET_TYPE ASSET_TYPE
, ASSET_CATEGORY_ID ASSET_CATEGORY_ID
, CATEGORY CATEGORY
, OLD_LIFE OLD_LIFE
, NEW_LIFE NEW_LIFE
, OLD_COST OLD_COST
, NEW_COST NEW_COST
, OLD_DEPRN_RESERVE OLD_DEPRN_RESERVE
, NEW_DEPRN_RESERVE NEW_DEPRN_RESERVE
, OLD_REVAL_RESERVE OLD_REVAL_RESERVE
, NEW_REVAL_RESERVE NEW_REVAL_RESERVE
, REVAL_CEILING REVAL_CEILING
, REVAL_PERCENT REVAL_PERCENT
, OVERRIDE_DEFAULTS OVERRIDE_DEFAULTS
, REVAL_FULLY_RSVD REVAL_FULLY_RSVD
, LIFE_EXTENSION_FACTOR LIFE_EXTENSION_FACTOR
, LIFE_EXTENSION_CEILING LIFE_EXTENSION_CEILING
, MAX_FULLY_RSVD_REVALS MAX_FULLY_RSVD_REVALS
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OLD_NBV OLD_NBV
, NEW_NBV NEW_NBV
FROM "FA"."FA_MASS_REVAL_REP_ITF"