Search Results mass_reval_id




Overview
Explore in AI Chat

Overview

APPS.IGI_MHC_REVAL_SUMMARY_PL_V is a reporting view in Oracle E-Business Suite that exposes revaluation summary records for mass revaluations processed in a specific run mode. The suffix "PL" in the object name denotes the "Post Later" run mode, which is confirmed by the view definition predicate RUN_MODE = 'L'. This view is primarily associated with the IGI (iProcurement-adjacent asset management) mass revaluation functionality that operates within the Oracle Assets revaluation framework.

The view presents a curated, de-duplicated snapshot of mass revaluation summary rows, filtering out inactive records and retaining only the most recent revaluation result for each asset, book, and mass revaluation period. It plays a reporting and integration role: downstream concurrent programs, Oracle Reports, and custom SQL queries can consume the view to obtain the latest valid "Post Later" revaluation outcome without re-implementing the complex MAX(ROWID) and MAX(MASS_REVAL_ID) de-duplication logic.

Underlying Base Objects

The view is defined over a single documented base object: IGI_MHC_REVALUATION_SUMMARY (referenced in the APPS schema as a synonym, aliased MRS in the view text). The view is not a simple projection; it embeds a correlated subquery that self-joins the base table twice (aliases IMRS2 and IMRS3) to isolate the latest active row.

The core filter conditions are:

  • RUN_MODE = 'L' — restricts to Post Later processing.
  • NVL(ACTIVE_FLAG,'Y') <> 'N' — excludes explicitly deactivated rows while treating NULL as active.
  • A composite key match on (MASS_REVAL_ID, ASSET_ID, CURRENT_MHC_PERIOD_COUNTER, ROWID) equal to the aggregation result, using MAX(IMRS2.ROWID).
  • An inner nesting that selects MAX(IMRS3.MASS_REVAL_ID) for the asset, book type, run mode, and current period counter combination.

Because the view relies on the ROWID pseudo-column and nested aggregations, it is read-oriented and should not be treated as an updateable view.

Key Columns

The user search focused on ASSET_ID, which is the primary asset identifier and a central column of the view. Other significant columns include:

Common Use Cases and Queries

Because the user searched for ASSET_ID, the most common query pattern retrieves revaluation results for a given asset:

SELECT asset_id, mass_reval_id, book_type_code,
       original_cost, new_asset_cost,
       old_accum_deprn, new_accum_deprn,
       new_reval_reserve, last_txn_event
  FROM apps.igi_mhc_reval_summary_pl_v
 WHERE asset_id = :p_asset_id;

Other practical scenarios include reconciling revaluation reserves by book (GROUP BY book_type_code), identifying assets whose revaluation posted later (RUN_MODE = 'L'), and validating life changes (PREVIOUS_LIFE <> CURRENT_LIFE). Reports frequently join this view back to FA_ADDITIONS on ASSET_ID to enrich output with asset descriptions.