Results for “ytd_production”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FA_GROUP_DEPRN_SUMMARY_MRC_V is a multi-reporting-currency (MRC) view owned by the APPS schema in Oracle E-Business Suite, belonging to the Oracle Assets (OFA) product family. It exposes depreciation summary information for group assets and is one of a family of MRC views that provide reporting-currency-aware access to base transaction data. In an MRC-enabled environment, each set of books retains its own ledger currency, and reporting is frequently performed in a currency other than the primary ledger currency. This view is defined so that only the rows matching the set of books identified by the current session are returned, allowing callers and reports to select depreciation data for the "current" set of books without supplying an explicit SET_OF_BOOKS_ID predicate.

The view is documented as VALID in ETRM 12.1.1 and 12.2.2 and contains no description beyond its definition and column list. It is a thin projection: no aggregations, joins, or derived business logic are applied beyond the session-based filter, so its behavior and columns correspond one-for-one with the underlying table.

Underlying Base Objects

Per the documented view text, FA_GROUP_DEPRN_SUMMARY_MRC_V is defined exclusively over FA_MC_GROUP_DEPRN_SUMMARY, referenced through its synonym. The naming convention indicates the MRC ("_MC_") counterpart of the group depreciation summary table, which stores depreciation records per set of books, group asset, and period.

The view's filter is the characteristic MRC pattern. Only rows whose SET_OF_BOOKS_ID matches the value derived from the client information are returned:

SELECT IMGDS.*
FROM   FA_MC_GROUP_DEPRN_SUMMARY IMGDS
WHERE  IMGDS.SET_OF_BOOKS_ID =
       NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),45,10)), -1);

The SUBSTRB(...,45,10) fragment extracts the set of books identifier from the fixed-position CLIENT_INFO string maintained by the MRC/OLAP session initialization. The NVL(..., -1) guard ensures that an uninitialized session returns no rows rather than an error.

Key Columns

• SET_OF_BOOKS_ID — identifies the set of books for which depreciation was calculated; the view's filter column.
• BOOK_TYPE_CODE — the asset book (for example, a corporate or tax book) to which the record pertains.
• GROUP_ASSET_ID — identifies the group asset whose members are depreciated collectively.
• DEPRN_RUN_DATE / PERIOD_COUNTER — the depreciation run date and the accounting period counter, used to place the record within a fiscal period.
• DEPRN_AMOUNT / YTD_DEPRN / DEPRN_RESERVE — period depreciation expense, year-to-date depreciation, and accumulated depreciation reserve.
• ADJUSTED_COST / BONUS_RATE / DEPRN_RATE — the cost basis for depreciation, the bonus depreciation rate, and the applied depreciation rate.
• DEPRN_SOURCE_CODE / CONVERTED_FLAG — the origin of the depreciation (for example, a run or an adjustment) and whether the row has been converted through MRC.
• PRODUCTION / YTD_PRODUCTION / LTD_PRODUCTION — units-of-production measures: period production, fiscal-year-to-date production, and life-to-date production. LTD_PRODUCTION is the user's search term and appears directly in the view's SELECT list.
• REVAL_AMORTIZATION / REVAL_AMORTIZATION_BASIS / REVAL_DEPRN_EXPENSE / REVAL_RESERVE / YTD_REVAL_DEPRN_EXPENSE — revaluation-related amortization, reserve, and expense balances.
• PRIOR_FY_EXPENSE — depreciation expense carried forward from prior fiscal years.

Common Use Cases and Queries

This view is used primarily to report or reconcile group-asset depreciation in the reporting currency of the active MRC session. Typical scenarios include feeding MRC-aware depreciation reports, extracting life-to-date production for units-of-production books, and reconciling group asset reserves and revaluation balances.

-- Period depreciation by group asset for the current reporting set of books
SELECT g.BOOK_TYPE_CODE,
       g.GROUP_ASSET_ID,
       g.PERIOD_COUNTER,
       g.DEPRN_AMOUNT,
       g.YTD_DEPRN,
       g.DEPRN_RESERVE,
       g.LTD_PRODUCTION
FROM   FA_GROUP_DEPRN_SUMMARY_MRC_V g
WHERE  g.BOOK_TYPE_CODE = :book
ORDER  BY g.GROUP_ASSET_ID, g.PERIOD_COUNTER;

-- Life-to-date production for units-of-production group assets
SELECT GROUP_ASSET_ID, PRODUCTION, YTD_PRODUCTION, LTD_PRODUCTION
FROM   FA_GROUP_DEPRN_SUMMARY_MRC_V
WHERE  BOOK_TYPE_CODE = :book
AND    LTD_PRODUCTION IS NOT NULL;

Because the view restricts output to the current session's set of books, callers that must report across multiple reporting currencies should initialize CLIENT_INFO per set of books and query iteratively, rather than attempting a single cross-currency SELECT.