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_SORP_UPG_IMPREVAL_HIST#

Source

View Text - Preformatted


select TRANSACTION_TYPE TRANSACTION_TYPE, ID ID, NAME NAME, DESCRIPTION DESCRIPTION, ASSET_CATEGORY_ID ASSET_CATEGORY_ID, CATEGORY_NAME CATEGORY_NAME, IMPAIRMENT_ID IMPAIRMENT_ID, IMPAIRMENT_NAME IMPAIRMENT_NAME, IMP_DESCRIPTION IMP_DESCRIPTION, IMP_CLASS_TYPE IMP_CLASS_TYPE, IMP_AMOUNT IMP_AMOUNT, MASS_REVAL_ID MASS_REVAL_ID, REVAL_PERCENT REVAL_PERCENT, REVAL_REASON REVAL_REASON, BOOK_TYPE_CODE BOOK_TYPE_CODE, REPORT_MODE REPORT_MODE, ID_TYPE ID_TYPE, REQUEST_ID REQUEST_ID from "FA"."FA_SORP_UPG_IMPREVAL_HIST"

View Text - HTML Formatted

SELECT TRANSACTION_TYPE TRANSACTION_TYPE
, ID ID
, NAME NAME
, DESCRIPTION DESCRIPTION
, ASSET_CATEGORY_ID ASSET_CATEGORY_ID
, CATEGORY_NAME CATEGORY_NAME
, IMPAIRMENT_ID IMPAIRMENT_ID
, IMPAIRMENT_NAME IMPAIRMENT_NAME
, IMP_DESCRIPTION IMP_DESCRIPTION
, IMP_CLASS_TYPE IMP_CLASS_TYPE
, IMP_AMOUNT IMP_AMOUNT
, MASS_REVAL_ID MASS_REVAL_ID
, REVAL_PERCENT REVAL_PERCENT
, REVAL_REASON REVAL_REASON
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, REPORT_MODE REPORT_MODE
, ID_TYPE ID_TYPE
, REQUEST_ID REQUEST_ID
FROM "FA"."FA_SORP_UPG_IMPREVAL_HIST"