VIEW: APPS.IGI_MHC_REVAL_DETAILS_LL_V

Source

View Text - Preformatted

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_LL_V ) AND NVL(ACTIVE_FLAG,'Y') <> 'N'

View Text - HTML Formatted

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_LL_V )
AND NVL(ACTIVE_FLAG
, 'Y') <> 'N'