Search Results salvage_value




Overview
Explore in AI Chat

Overview

IGI_MHC_CURR_REVAL_DTL_V is a reporting view owned by the APPS schema within the IGI – Public Sector Financials International product. It exposes the set of "current active" revaluation records produced by the Mass Revaluation process for capitalized assets. Because Mass Revaluation in Oracle EBS can be executed in either Live or Preview mode, the underlying base table retains data for every run. This view filters that history so that only the qualifying active rows are visible to downstream reporting, inquiry, and integration consumers.

In the context of Oracle EBS 12.1.1 and 12.2.2, the object is a read-only view (no DDL is generated beyond the view definition itself), so it carries no storage of its own and inherits its lifecycle entirely from the base table. It is particularly relevant to users and developers searching on the net_book_value attribute, since NET_BOOK_VALUE is one of the columns projected to the surface and is central to public-sector asset revaluation reporting.

Underlying Base Objects

According to the documented metadata, the view is defined over a single referenced base object: the synonym IGI_MHC_REVALUATION_DETAIL. The view text confirms this relationship directly, selecting a fixed list of columns from that table and applying the following predicate logic:

  • ACTIVE_FLAG = 'Y' — restricts output to active run records.
  • RUN_MODE = 'L' — restricts output to Live-mode runs, excluding Preview-mode data.
  • NVL(ACTIVE_FLAG, 'Y') <> 'N' — a defensive predicate ensuring no record explicitly flagged inactive is ever returned.

The effect is a filtered projection of the revaluation detail table: every column consumed downstream originates in IGI_MHC_REVALUATION_DETAIL, and the view adds no joins or derived expressions of its own. This makes the view a thin convenience layer rather than a transformation layer.

Key Columns

The view projects the full documented column list from the base table. The most significant for reporting include:

Common Use Cases and Queries

Typical uses include asset revaluation inquiry screens, concurrent reporting programs, and ad-hoc analysis of net book value movements produced by Live revaluation runs. A representative query retrieving net book value by asset follows:

  • SELECT asset_id, book_type_code, net_book_value, revaluation_reserve, process_status_code FROM apps.igi_mhc_curr_reval_dtl_v WHERE book_type_code = :book ORDER BY asset_id;
  • SELECT mass_reval_id, COUNT(*), SUM(net_book_value) FROM apps.igi_mhc_curr_reval_dtl_v GROUP BY mass_reval_id;
  • SELECT a.asset_id, a.net_book_value, a.accumulated_depreciation FROM apps.igi_mhc_curr_reval_dtl_v a WHERE a.deprn_processed_flag = 'Y';

Because the view excludes Preview-mode and inactive rows, queries against it always reflect the currently effective Live revaluation state, making it suitable for both operational reporting and downstream integration without additional filtering.