Search Results tot_overhead_value




Overview
Explore in AI Chat

Overview

The Oracle E-Business Suite view ICX_COST_GRP_INV_VALUE_V is an APPS-owned database object residing in the ICX (Oracle iProcurement) product schema. Per Oracle's electronic technical reference manual (ETRM) metadata, its documented status is Obsolete. This classification indicates that the view is a legacy object retained for backward compatibility only and is not intended for new development, customization, or extension. It exists in both EBS 12.1.1 and 12.2.2, where it remains flagged as VALID despite its obsolete designation.

The view's stated purpose is to aggregate inventory valuation data by cost group, project, task, organization, inventory item, and lot. It exposes summarized monetary figures across multiple cost element categories — material, material overhead, resource, outside processing, and overhead — derived from costing quantity layers. In this sense, it functions as a reporting-oriented construct that joins cost group definitions to on-hand quantities and their associated cost layer detail. Given its obsolete status, Oracle does not document it for functional use, and any reliance upon it should be treated as unsupported.

Underlying Base Objects

According to the documented ETRM metadata for release 12.2.2, the view is defined over the following base objects:

  • CST_COST_GROUPS (referenced via SYNONYM) — provides the cost group identifier and cost group name.
  • CST_QUANTITY_LAYERS (SYNONYM) — the primary costing source, supplying item cost and the per-element cost components summed by the view.
  • MRP_PROJECT_PARAMETERS (SYNONYM) — links project and organization to the applicable costing group.
  • MTL_ITEM_LOCATIONS (SYNONYM) — provides the inventory location and its associated project and task.
  • MTL_ONHAND_QUANTITIES (VIEW) — supplies on-hand transaction quantities, organization, item, and lot information.

The view joins these objects on cost group, project, organization, and inventory item keys, then groups results to produce the aggregated valuation columns. A notable structural detail is the outer join on QTY.LOCATOR_ID = LOC.INVENTORY_LOCATION_ID(+), which preserves quantity layer rows that lack a matching item location.

Key Columns

The view projects the following columns as documented in the ETRM metadata:

Common Use Cases and Queries

Because the view is documented as obsolete, it should not be selected against in new development. Historically, such constructs supported cost group valuation reporting within the iProcurement and costing domains. A representative query pattern — offered for reference only — would aggregate valuation by cost group:

  • SELECT cost_group, organization_id, SUM(tot_inventory_value) FROM icx_cost_grp_inv_value_v GROUP BY cost_group, organization_id;
  • SELECT cost_group, project_id, task_id, tot_material_value, tot_overhead_value FROM icx_cost_grp_inv_value_v WHERE lot IS NOT NULL;

Practitioners requiring current cost group valuation should use supported costing subject areas, such as the Oracle Cost Management views or equivalent supported reporting objects, rather than this legacy view.