Search Results rmcalc_type




Overview
Explore in AI Chat

Overview

APPS.CM_CMPT_DTL_VW is a reporting view in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 that consolidates cost component detail records used by the Cost Management (CM) and Enterprise Territory / Cost Rollup functionality. It sits within the Cost Management application schema and exposes aggregated cost component information derived from the underlying transaction detail table. The view is defined with a UNION ALL structure, combining a grouped aggregation branch with a second branch that returns raw component cost rows. This design allows downstream reports, concurrent programs, and integration interfaces to retrieve both summarized and detailed cost component data through a single object.

The user search term "costcalc_orig" is directly relevant: COSTCALC_ORIG is one of the columns exposed by this view (and carried into its grouping clause), indicating the origin of a cost calculation. This makes the view valuable for tracing where a given cost component was calculated.

Underlying Base Objects

According to the documented ETRM 12.2.2 metadata, the only referenced base object is CM_CMPT_DTL, accessed through a synonym owned by APPS. Both branches of the view's union read from CM_CMPT_DTL:

  • The first branch filters rows where NVL(rmcalc_type,0) > 0 and applies SUM(cmpnt_cost) with a GROUP BY across nearly all remaining columns.
  • The second branch returns individual component cost rows keyed by cmpntcost_id.

Because the view is defined over a single base table, it introduces no joins to external entities; its complexity lies entirely in the aggregation and union logic applied to CM_CMPT_DTL.

Key Columns

The view projects a broad column set. Notable columns include:

Common Use Cases and Queries

Typical uses include cost rollup reporting, cost component analysis by item and period, and reconciliation of calculated versus original cost origins.

Example query retrieving component costs filtered by calculation origin:

  • SELECT item_id, whse_code, period_code, cost_mthd_code, costcalc_orig, SUM(cmpnt_cost) total_cost
  • FROM apps.cm_cmpt_dtl_vw
  • WHERE rmcalc_type > 0
  • GROUP BY item_id, whse_code, period_code, cost_mthd_code, costcalc_orig;

A second common pattern filters on organization and period to support period-close cost reporting, while a third examines burden and rollover indicators (BURDEN_IND, ROLLOVER_IND) to isolate rolled-up versus base cost components. Because the view already performs aggregation in its first branch, consumers should apply additional summing cautiously to avoid double counting.