Search Results reval_amort_ccid




Overview
Explore in AI Chat

Overview

FA_DEPRN_DETAIL_H_MRC_V is a multi-reporting-currency (MRC) view owned by the APPS schema in Oracle E-Business Suite, belonging to the OFA - Assets (Fixed Assets) product. The view presents a reporting-currency–filtered projection of depreciation detail history, exposing the same set of columns as the underlying MRC base object while constraining rows to a single set of books. Its defining characteristic is the predicate applied to SET_OF_BOOKS_ID, which resolves at runtime from the session's client information rather than being supplied as a bind parameter:

This construct is standard for MRC-enabled views in EBS. The CLIENT_INFO value is populated when the application initializes the session for a given set of books; the view then transparently returns only rows belonging to that reporting book. When no valid value is present, the NVL substitution of -1 guarantees an empty result set rather than an unintended cross-book read. The view is therefore a reporting and integration surface rather than a storage object, and it plays no role in the depreciation calculation engine itself.

Underlying Base Objects

The view is defined exclusively over a single documented base object:

  • FA_MC_DEPRN_DETAIL_H (referenced through a SYNONYM) — the MRC depreciation detail history table that physically stores depreciation results per reporting set of books, keyed in part by SET_OF_BOOKS_ID.

The relationship is a straightforward one-to-one projection: every column in the view maps to a column of the same name in FA_MC_DEPRN_DETAIL_H. There is no join, aggregation, or derivation, and no other table, view, or function is referenced in the view text. The only transformation is the row-level filtering on SET_OF_BOOKS_ID driven by session context.

Key Columns

The column list is unchanged from the base table and covers the full depreciation detail picture, including the accounting flexfield references that users frequently search for by name.

DEPRN_RESERVE_CCID, the column named in the user's search, is the code combination identifier for the accumulated depreciation reserve account posted for the row. It is a numeric FK-style reference into GL_CODE_COMBINATIONS; resolving it to a readable account requires joining to that table on CODE_COMBINATION_ID. The companion BONUS_DEPRN_RESERVE_CCID serves the equivalent purpose for bonus reserve postings.

Common Use Cases and Queries

Typical uses include depreciation reconciliation, journal-line-to-subledger tie-outs, and reporting on reserve account assignments for a specific reporting book. Because the view self-filters on the session's set of books, queries run through a correctly initialized EBS session need no additional SET_OF_BOOKS_ID predicate, though adding one explicitly is advisable for ad hoc SQL run outside the application.

To identify reserve CCIDs used for a given asset:

  • SELECT asset_id, period_counter, deprn_reserve, deprn_reserve_ccid
  • FROM apps.fa_deprn_detail_h_mrc_v
  • WHERE asset_id = :p_asset_id AND book_type_code = :p_book;

To resolve the reserve account to a readable flexfield combination:

  • SELECT v.asset_id, v.period_counter, v.deprn_reserve, gcc.concatenated_segments
  • FROM apps.fa_deprn_detail_h_mrc_v v, apps.gl_code_combinations_kfv gcc
  • WHERE v.deprn_reserve_ccid = gcc.code_combination_id;

In integration scenarios the view is commonly read by custom concurrent programs and extracts that must respect multi-currency books. The session-level filtering means such programs must explicitly initialize CLIENT_INFO for the target reporting set of books before querying; otherwise the -1 default returns no rows.