View: IGI_MHC_CURR_REVAL_DTL_V

Product:	IGI - Public Sector Financials International
Description:	IGI_MHC_CURR_REVAL_DTL_V holds the current active records for each run of Revaluation. Since Revaluation can be run in Live and Preview modes, data for all the runs is stored in the IGI_MHC_REVALUATION_DETAIL. This view filters and holds
Implementation/DBA Data:	APPS.IGI_MHC_CURR_REVAL_DTL_V

View Text

SELECT DETAIL_SEQ_ID
, MASS_REVAL_ID
, ASSET_ID
, CATEGORY_ID
, BOOK_TYPE_CODE
, DISTRIBUTION_ID
, CURRENT_MHC_PERIOD_COUNTER
, PERIOD_COUNTER
, NUMBER_OF_UNITS_ASSIGNED
, NUMBER_OF_UNITS_RETIRED
, LIFE_CHANGE_COUNT
, RUN_MODE
, ACTIVE_FLAG
, ASSET_COST
, SALVAGE_VALUE
, ACCUMULATED_DEPRECIATION
, PRIOR_YRS_ACCUM_DEPRECIATION
, YTD_DEPRECIATION_RESERVE
, CURR_MHC_PRD_BACKLOG_DEPRN
, ACCUMULATED_BACKLOG_DEPRN
, NET_BOOK_VALUE
, REVALUATION_RESERVE
, DEPRECIATION_EXPENSE
, CURR_YEAR_OPERATING_EXPENSE
, CURR_YR_PRIOR_PRDS_DEPRN
, CURR_YR_PRIOR_PRDS_DEPRN_REVAL
, PRIOR_YEAR_OPERATING_EXPENSE
, GENERAL_FUND
, CREATION_DATE
, ACCUMULATED_GENERAL_FUND
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_BY
, LAST_UPDATE_LOGIN
, REVAL_MODE
, PROCESS_STATUS_CODE
, DEPRN_PROCESSED_FLAG
FROM IGI_MHC_REVALUATION_DETAIL
WHERE ACTIVE_FLAG = 'Y'
AND RUN_MODE = 'L'
AND NVL(ACTIVE_FLAG
, 'Y') <> 'N'

Columns