Search Results run_mode




Overview
Explore in AI Chat

Overview

The view APPS.IGI_MHC_REVAL_SUMMARY_LL_V is a reporting and integration object in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, owned by the APPS schema. It exposes a filtered subset of records from the IGI mass revaluation summary infrastructure, specifically the rows associated with the "LL" (life-based / life-length) run mode. The suffix _LL_V and the embedded predicate RUN_MODE = 'L' indicate that this view is purpose-built to present the most recent active life revaluation results for each asset and book combination.

The view identifies, for every asset and depreciation book, the single latest mass revaluation summary row that satisfies the life run mode, the highest MHC period counter, the highest mass revaluation identifier, and an active status. Because the underlying summary table accumulates multiple runs across periods, the view collapses this history down to one authoritative current record per asset/book, making it suitable for downstream inquiry screens, concurrent reporting, and integration interfaces.

Underlying Base Objects

The view is defined exclusively over the synonym IGI_MHC_REVALUATION_SUMMARY, which resolves to the base table storing mass revaluation summary results. No additional tables, views, or PL/SQL functions are referenced in the documented view text; the filtering and de-duplication are achieved entirely through correlated subqueries against the same underlying object. Two self-referencing subqueries are used: the first selects the maximum CURRENT_MHC_PERIOD_COUNTER for the asset and book, and the nested second selects the maximum MASS_REVAL_ID within that period. Inactive records (ACTIVE_FLAG = 'N') are excluded at both levels via NVL(...,'Y') <> 'N', ensuring that only active results are surfaced.

Key Columns

Common Use Cases and Queries

Because the view returns exactly one current life revaluation summary per asset and book, it supports reduced-integration reporting, reconciliation of revaluation runs, and inquiry on the net financial effect of the latest life revaluation. A representative query retrieving current life revaluation results for a specific book is:

  • SELECT asset_id, book_type_code, original_cost, new_asset_cost, current_life, new_accum_deprn FROM apps.igi_mhc_reval_summary_ll_v WHERE book_type_code = :p_book ORDER BY asset_id;
  • SELECT asset_id, mass_reval_id, reval_mode, new_reval_reserve FROM apps.igi_mhc_reval_summary_ll_v WHERE asset_id = :p_asset_id;

These queries are typically used in mass revaluation validation reports, post-run variance analysis comparing original versus new cost and reserve values, and extract programs feeding external fixed asset ledgers.