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

Source

View Text - Preformatted


select DETAIL_SEQ_ID DETAIL_SEQ_ID, MASS_REVAL_ID MASS_REVAL_ID, ASSET_ID ASSET_ID, CATEGORY_ID CATEGORY_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, DISTRIBUTION_ID DISTRIBUTION_ID, CURRENT_MHC_PERIOD_COUNTER CURRENT_MHC_PERIOD_COUNTER, PERIOD_COUNTER PERIOD_COUNTER, REVAL_MODE REVAL_MODE, NUMBER_OF_UNITS_ASSIGNED NUMBER_OF_UNITS_ASSIGNED, NUMBER_OF_UNITS_RETIRED NUMBER_OF_UNITS_RETIRED, LIFE_CHANGE_COUNT LIFE_CHANGE_COUNT, RUN_MODE RUN_MODE, ACTIVE_FLAG ACTIVE_FLAG, ASSET_COST ASSET_COST, SALVAGE_VALUE SALVAGE_VALUE, ACCUMULATED_DEPRECIATION ACCUMULATED_DEPRECIATION, PRIOR_YRS_ACCUM_DEPRECIATION PRIOR_YRS_ACCUM_DEPRECIATION, YTD_DEPRECIATION_RESERVE YTD_DEPRECIATION_RESERVE, CURR_MHC_PRD_BACKLOG_DEPRN CURR_MHC_PRD_BACKLOG_DEPRN, ACCUMULATED_BACKLOG_DEPRN ACCUMULATED_BACKLOG_DEPRN, NET_BOOK_VALUE NET_BOOK_VALUE, REVALUATION_RESERVE REVALUATION_RESERVE, DEPRECIATION_EXPENSE DEPRECIATION_EXPENSE, CURR_YEAR_OPERATING_EXPENSE CURR_YEAR_OPERATING_EXPENSE, CURR_YR_PRIOR_PRDS_DEPRN CURR_YR_PRIOR_PRDS_DEPRN, CURR_YR_PRIOR_PRDS_DEPRN_REVAL CURR_YR_PRIOR_PRDS_DEPRN_REVAL, PRIOR_YEAR_OPERATING_EXPENSE PRIOR_YEAR_OPERATING_EXPENSE, GENERAL_FUND GENERAL_FUND, ACCUMULATED_GENERAL_FUND ACCUMULATED_GENERAL_FUND, PROCESS_STATUS_CODE PROCESS_STATUS_CODE, DEPRN_PROCESSED_FLAG DEPRN_PROCESSED_FLAG, PRORATE_PERCENT PRORATE_PERCENT, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_BY LAST_UPDATE_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "IGI"."IGI_MHC_REVALUATION_DETAIL"

View Text - HTML Formatted

SELECT DETAIL_SEQ_ID DETAIL_SEQ_ID
, MASS_REVAL_ID MASS_REVAL_ID
, ASSET_ID ASSET_ID
, CATEGORY_ID CATEGORY_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, DISTRIBUTION_ID DISTRIBUTION_ID
, CURRENT_MHC_PERIOD_COUNTER CURRENT_MHC_PERIOD_COUNTER
, PERIOD_COUNTER PERIOD_COUNTER
, REVAL_MODE REVAL_MODE
, NUMBER_OF_UNITS_ASSIGNED NUMBER_OF_UNITS_ASSIGNED
, NUMBER_OF_UNITS_RETIRED NUMBER_OF_UNITS_RETIRED
, LIFE_CHANGE_COUNT LIFE_CHANGE_COUNT
, RUN_MODE RUN_MODE
, ACTIVE_FLAG ACTIVE_FLAG
, ASSET_COST ASSET_COST
, SALVAGE_VALUE SALVAGE_VALUE
, ACCUMULATED_DEPRECIATION ACCUMULATED_DEPRECIATION
, PRIOR_YRS_ACCUM_DEPRECIATION PRIOR_YRS_ACCUM_DEPRECIATION
, YTD_DEPRECIATION_RESERVE YTD_DEPRECIATION_RESERVE
, CURR_MHC_PRD_BACKLOG_DEPRN CURR_MHC_PRD_BACKLOG_DEPRN
, ACCUMULATED_BACKLOG_DEPRN ACCUMULATED_BACKLOG_DEPRN
, NET_BOOK_VALUE NET_BOOK_VALUE
, REVALUATION_RESERVE REVALUATION_RESERVE
, DEPRECIATION_EXPENSE DEPRECIATION_EXPENSE
, CURR_YEAR_OPERATING_EXPENSE CURR_YEAR_OPERATING_EXPENSE
, CURR_YR_PRIOR_PRDS_DEPRN CURR_YR_PRIOR_PRDS_DEPRN
, CURR_YR_PRIOR_PRDS_DEPRN_REVAL CURR_YR_PRIOR_PRDS_DEPRN_REVAL
, PRIOR_YEAR_OPERATING_EXPENSE PRIOR_YEAR_OPERATING_EXPENSE
, GENERAL_FUND GENERAL_FUND
, ACCUMULATED_GENERAL_FUND ACCUMULATED_GENERAL_FUND
, PROCESS_STATUS_CODE PROCESS_STATUS_CODE
, DEPRN_PROCESSED_FLAG DEPRN_PROCESSED_FLAG
, PRORATE_PERCENT PRORATE_PERCENT
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_BY LAST_UPDATE_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "IGI"."IGI_MHC_REVALUATION_DETAIL"