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

Source

View Text - Preformatted


select FA_DEPRN_SUMMARY_ROWID FA_DEPRN_SUMMARY_ROWID, BOOK_TYPE_CODE BOOK_TYPE_CODE, ASSET_ID ASSET_ID, CURRENT_MHC_PERIOD_COUNTER CURRENT_MHC_PERIOD_COUNTER, PERIOD_COUNTER PERIOD_COUNTER, MHC_YTD_DEPRN MHC_YTD_DEPRN, MHC_DEPRN_RESERVE MHC_DEPRN_RESERVE, MHC_COST MHC_COST, MHC_SALVAGE_VALUE MHC_SALVAGE_VALUE, MHC_REVAL_RESERVE MHC_REVAL_RESERVE, MHC_NET_BOOK_VALUE MHC_NET_BOOK_VALUE, MHC_DEPRN_EXPENSE MHC_DEPRN_EXPENSE, CURRENT_MHC_PRD_BACKLOG_DEPRN CURRENT_MHC_PRD_BACKLOG_DEPRN, ACCUMULATED_BACKLOG_DEPRN ACCUMULATED_BACKLOG_DEPRN, MHC_CURR_YR_OP_EXPENSE MHC_CURR_YR_OP_EXPENSE, MHC_CURR_YR_PPS_DEPRN MHC_CURR_YR_PPS_DEPRN, MHC_CURR_YR_PPS_DEPRN_REVAL MHC_CURR_YR_PPS_DEPRN_REVAL, MHC_PRIOR_YR_OP_EXPENSE MHC_PRIOR_YR_OP_EXPENSE, MHC_GENERAL_FUND MHC_GENERAL_FUND, ACCUMULATED_GENERAL_FUND ACCUMULATED_GENERAL_FUND, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_LOGIN LAST_UPDATED_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY from "IGI"."IGI_MHC_DEPRN_SUMMARY"

View Text - HTML Formatted

SELECT FA_DEPRN_SUMMARY_ROWID FA_DEPRN_SUMMARY_ROWID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, ASSET_ID ASSET_ID
, CURRENT_MHC_PERIOD_COUNTER CURRENT_MHC_PERIOD_COUNTER
, PERIOD_COUNTER PERIOD_COUNTER
, MHC_YTD_DEPRN MHC_YTD_DEPRN
, MHC_DEPRN_RESERVE MHC_DEPRN_RESERVE
, MHC_COST MHC_COST
, MHC_SALVAGE_VALUE MHC_SALVAGE_VALUE
, MHC_REVAL_RESERVE MHC_REVAL_RESERVE
, MHC_NET_BOOK_VALUE MHC_NET_BOOK_VALUE
, MHC_DEPRN_EXPENSE MHC_DEPRN_EXPENSE
, CURRENT_MHC_PRD_BACKLOG_DEPRN CURRENT_MHC_PRD_BACKLOG_DEPRN
, ACCUMULATED_BACKLOG_DEPRN ACCUMULATED_BACKLOG_DEPRN
, MHC_CURR_YR_OP_EXPENSE MHC_CURR_YR_OP_EXPENSE
, MHC_CURR_YR_PPS_DEPRN MHC_CURR_YR_PPS_DEPRN
, MHC_CURR_YR_PPS_DEPRN_REVAL MHC_CURR_YR_PPS_DEPRN_REVAL
, MHC_PRIOR_YR_OP_EXPENSE MHC_PRIOR_YR_OP_EXPENSE
, MHC_GENERAL_FUND MHC_GENERAL_FUND
, ACCUMULATED_GENERAL_FUND ACCUMULATED_GENERAL_FUND
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_LOGIN LAST_UPDATED_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
FROM "IGI"."IGI_MHC_DEPRN_SUMMARY"