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: IGI.IGI_MHC_REVALUATION_SUMMARY#

Source

View Text - Preformatted


select MASS_REVAL_ID MASS_REVAL_ID, ASSET_ID ASSET_ID, CATEGORY_ID CATEGORY_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, CURRENT_MHC_PERIOD_COUNTER CURRENT_MHC_PERIOD_COUNTER, PERIOD_COUNTER PERIOD_COUNTER, DPIS_MHC_PERIOD_COUNTER DPIS_MHC_PERIOD_COUNTER, LIFE_CHANGE_COUNT LIFE_CHANGE_COUNT, ACTIVE_FLAG ACTIVE_FLAG, RUN_MODE RUN_MODE, REVAL_MODE REVAL_MODE, ORIGINAL_COST ORIGINAL_COST, NEW_ASSET_COST NEW_ASSET_COST, NEW_SALVAGE_VALUE NEW_SALVAGE_VALUE, ORIGINAL_LIFE ORIGINAL_LIFE, PREVIOUS_LIFE PREVIOUS_LIFE, CURRENT_LIFE CURRENT_LIFE, OLD_ACCUM_DEPRN OLD_ACCUM_DEPRN, OLD_REVAL_RESERVE OLD_REVAL_RESERVE, NEW_ACCUM_DEPRN NEW_ACCUM_DEPRN, NEW_REVAL_RESERVE NEW_REVAL_RESERVE, NEW_CURR_YR_EXPENSE NEW_CURR_YR_EXPENSE, NEW_BACKLOG_DEPRN NEW_BACKLOG_DEPRN, NEW_CURR_YR_OP_EXPENSE NEW_CURR_YR_OP_EXPENSE, NEW_PRIOR_YR_OP_EXPENSE NEW_PRIOR_YR_OP_EXPENSE, NEW_GENERAL_FUND NEW_GENERAL_FUND, NEW_ACCUM_GENERAL_FUND NEW_ACCUM_GENERAL_FUND, REVAL_CALCULATION_CODE REVAL_CALCULATION_CODE, LAST_TXN_EVENT LAST_TXN_EVENT, 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 "IGI"."IGI_MHC_REVALUATION_SUMMARY"

View Text - HTML Formatted

SELECT MASS_REVAL_ID MASS_REVAL_ID
, ASSET_ID ASSET_ID
, CATEGORY_ID CATEGORY_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, CURRENT_MHC_PERIOD_COUNTER CURRENT_MHC_PERIOD_COUNTER
, PERIOD_COUNTER PERIOD_COUNTER
, DPIS_MHC_PERIOD_COUNTER DPIS_MHC_PERIOD_COUNTER
, LIFE_CHANGE_COUNT LIFE_CHANGE_COUNT
, ACTIVE_FLAG ACTIVE_FLAG
, RUN_MODE RUN_MODE
, REVAL_MODE REVAL_MODE
, ORIGINAL_COST ORIGINAL_COST
, NEW_ASSET_COST NEW_ASSET_COST
, NEW_SALVAGE_VALUE NEW_SALVAGE_VALUE
, ORIGINAL_LIFE ORIGINAL_LIFE
, PREVIOUS_LIFE PREVIOUS_LIFE
, CURRENT_LIFE CURRENT_LIFE
, OLD_ACCUM_DEPRN OLD_ACCUM_DEPRN
, OLD_REVAL_RESERVE OLD_REVAL_RESERVE
, NEW_ACCUM_DEPRN NEW_ACCUM_DEPRN
, NEW_REVAL_RESERVE NEW_REVAL_RESERVE
, NEW_CURR_YR_EXPENSE NEW_CURR_YR_EXPENSE
, NEW_BACKLOG_DEPRN NEW_BACKLOG_DEPRN
, NEW_CURR_YR_OP_EXPENSE NEW_CURR_YR_OP_EXPENSE
, NEW_PRIOR_YR_OP_EXPENSE NEW_PRIOR_YR_OP_EXPENSE
, NEW_GENERAL_FUND NEW_GENERAL_FUND
, NEW_ACCUM_GENERAL_FUND NEW_ACCUM_GENERAL_FUND
, REVAL_CALCULATION_CODE REVAL_CALCULATION_CODE
, LAST_TXN_EVENT LAST_TXN_EVENT
, 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 "IGI"."IGI_MHC_REVALUATION_SUMMARY"