Search Results mrp_project_parameters




Overview
Explore in AI Chat

Overview

APPS.ICX_COST_GRP_INV_VALUE_V is an Oracle E-Business Suite database view owned by the APPS schema. It presents an aggregated, cost-group-oriented valuation of on-hand inventory, resolving inventory quantities and cost layer amounts by project, task, organization, item, and lot. The view is part of the Oracle iProcurement / Internet Computing Architecture (ICX) family of reporting objects, which are used to surface supply-chain and cost information through self-service and HTML-based inquiry pages. In effect, the view answers the question: "what is the current inventory value of a given cost group, broken down by project and task?" It does so by joining quantity layers to on-hand quantities, then associating them to a project through the MRP_PROJECT_PARAMETERS table.

The view's significance is that it bridges generic costing data (cost groups and quantity layers) to project manufacturing and project costing constructs. It is typically consumed in reporting and integration contexts where a project-aware inventory valuation is required, rather than as an operational transactional interface.

Underlying Base Objects

Per ETRM 12.2.2 metadata, the view is defined over five referenced base objects:

  • CST_COST_GROUPS (synonym) — supplies the cost group identifier and its descriptive name (COST_GROUP).
  • CST_QUANTITY_LAYERS (synonym) — the costing engine's quantity layer records; provides ITEM_COST and the elemental cost columns (material, material overhead, resource, outside processing, overhead) in both periodic (PL_) and transaction-level (TL_) forms.
  • MRP_PROJECT_PARAMETERS (synonym) — the project manufacturing parameters table; this is the object the user searched for, and it is the pivotal join that carries PROJECT_ID, ORGANIZATION_ID, and COSTING_GROUP_ID into the query, linking a project to its costing group per organization.
  • MTL_ITEM_LOCATIONS (synonym) — provides the inventory location and, through LOC.PROJECT_ID and LOC.TASK_ID, the project/task context of the on-hand material.
  • MTL_ONHAND_QUANTITIES (view) — the on-hand quantity source, supplying TRANSACTION_QUANTITY, LOT_NUMBER, and the locator, organization, and item keys.

The joins enforce that the MRP_PROJECT_PARAMETERS row for a given project and organization uses the same costing group as both the quantity layer and the cost group master record.

Key Columns

Common Use Cases and Queries

The view supports cost-group inventory valuation reports, project-level material valuation reconciliation, and integration extracts into external reporting or data-warehouse layers. A representative query retrieving value by project and cost group is:

  • SELECT PROJECT_ID, TASK_ID, ORGANIZATION_ID, COST_GROUP, INVENTORY_ITEM_ID, LOT_NUMBER, TOT_INVENTORY_VALUE, TOT_MATERIAL_VALUE, TOT_OVERHEAD_VALUE FROM APPS.ICX_COST_GRP_INV_VALUE_V WHERE PROJECT_ID = :p_project_id ORDER BY ORGANIZATION_ID, COST_GROUP;

Because MRP_PROJECT_PARAMETERS is an inner-joined driver table, only inventory tied to a project cost group is returned; non-project inventory is excluded. Analysts should therefore use this view specifically for project manufacturing valuation, not for general on-hand reporting.