Product: | IGI - Public Sector Financials International |
---|---|
Description: | IGI_MHC_REVAL_SUMMARY_PL_V holds data for each distribution of an asset for all the Live runs of Revaluation done for the Previous periods |
Implementation/DBA Data: | APPS.IGI_MHC_REVAL_DETAILS_PL_V |
SELECT MRD.ROWID "ROW_ID"
, MRD.DETAIL_SEQ_ID
, MRD.MASS_REVAL_ID
, MRD.ASSET_ID
, MRD.CATEGORY_ID
, MRD.BOOK_TYPE_CODE
, MRD.DISTRIBUTION_ID
, MRD.CURRENT_MHC_PERIOD_COUNTER
, MRD.PERIOD_COUNTER
, MRD.REVAL_MODE
, MRD.NUMBER_OF_UNITS_ASSIGNED
, MRD.NUMBER_OF_UNITS_RETIRED
, MRD.LIFE_CHANGE_COUNT
, MRD.RUN_MODE
, MRD.ACTIVE_FLAG
, MRD.ASSET_COST
, MRD.SALVAGE_VALUE
, MRD.ACCUMULATED_DEPRECIATION
, MRD.PRIOR_YRS_ACCUM_DEPRECIATION
, MRD.YTD_DEPRECIATION_RESERVE
, MRD.CURR_MHC_PRD_BACKLOG_DEPRN
, MRD.ACCUMULATED_BACKLOG_DEPRN
, MRD.NET_BOOK_VALUE
, MRD.REVALUATION_RESERVE
, MRD.DEPRECIATION_EXPENSE
, MRD.CURR_YEAR_OPERATING_EXPENSE
, MRD.CURR_YR_PRIOR_PRDS_DEPRN
, MRD.CURR_YR_PRIOR_PRDS_DEPRN_REVAL
, MRD.PRIOR_YEAR_OPERATING_EXPENSE
, MRD.GENERAL_FUND
, MRD.ACCUMULATED_GENERAL_FUND
, MRD.PRORATE_PERCENT
, MRD.CREATION_DATE
, MRD.CREATED_BY
, MRD.LAST_UPDATE_DATE
, MRD.LAST_UPDATE_BY
, MRD.LAST_UPDATE_LOGIN
, MRD.PROCESS_STATUS_CODE
, MRD.DEPRN_PROCESSED_FLAG
FROM IGI_MHC_REVALUATION_DETAIL MRD
WHERE ( MASS_REVAL_ID
, ASSET_ID
, CURRENT_MHC_PERIOD_COUNTER
, RUN_MODE) IN ( SELECT MASS_REVAL_ID
, ASSET_ID
, CURRENT_MHC_PERIOD_COUNTER
, RUN_MODE
FROM IGI_MHC_REVAL_SUMMARY_PL_V )
AND NVL(ACTIVE_FLAG
, 'Y') <> 'N'