Results for “mtl_cmpntcls_id”

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

Overview

GMF.CM_CMPT_MTL is a key configuration and reference table within Oracle Process Manufacturing Financials (GMF). It stores the item-specific or item cost class-specific material cost component and material analysis code assignments that drive the Actual Cost Process. In Oracle EBS 12.1.1 and 12.2.2, this table bridges the cost component master definitions and the manufacturing item master, allowing cost rollups to resolve which material cost component (and associated analysis code) applies to a given item within a given organization and effective date range.

From a data-modeling perspective, the heuristic classification for this object is a link. CM_CMPT_MTL is not a standalone hub; rather, it resolves many-to-many relationships between items (IC_ITEM_MST), cost component classes (CM_CMPT_MST), analysis codes (CM_ALYS_MST), legal entities, and organizations. Its rows exist to bind those independent entities together with effective-dating and analysis context, which is the classic role of a link table in a Data Vault model.

Key Information Stored

Each row represents a single material cost component assignment for one item (or item cost class), within an organization, effective over a date range. The most significant columns are:

• CMPTMTL_ID — surrogate primary key, enforced by unique index CM_CMPT_MTL_PK. This is the single authoritative unique identifier.
• CO_CODE — company/organization code; foreign key to SY_ORGN_MST and SY_ORGN_MST_B. Together with item and cost class it forms part of the business-key candidate.
• ITEM_ID — the manufactured item; foreign key to IC_ITEM_MST and its _B base variant.
• ITEMCOST_CLASS — the item cost class; foreign key to IC_COST_CLS. Used when assignment is by cost class rather than individual item.
• EFF_START_DATE / EFF_END_DATE — effective dating controlling which assignment is active during costing.
• MTL_CMPNTCLS_ID — identifies the material cost component class; foreign key to CM_CMPT_MST and CM_CMPT_MST_B.
• MTL_ANALYSIS_CODE — the material analysis code; foreign key to CM_ALYS_MST. Classifies the nature of the material cost.
• USE_IND — flag governing whether the assignment is active.
• TEXT_CODE — free-text/notes reference; foreign key to CM_TEXT_HDR.
• COST_CATEGORY_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID, MASTER_ORGANIZATION_ID, LEGAL_ENTITY_ID — costing and organization context, linking to legal entities via FV_LEGAL_ENTITIES.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, DELETE_MARK — standard audit columns.
• TRANS_CNT — transaction counter used by GMF concurrency control.

The CM_CMPT_MTLI0 unique index on (CO_CODE, ITEM_ID, ITEMCOST_CLASS, EFF_START_DATE) represents the business-key candidate, while CMPTMTL_ID remains the true surrogate primary key.

Common Use Cases and Queries

Typical usage centers on resolving which material cost component and analysis code applies during the Actual Cost Process, and on auditing cost component setup per item or cost class.

• Active assignment lookup — retrieve the effective component for an item and organization at a costing date:

  SELECT cmptmtl_id, mtl_cmpntcls_id, mtl_analysis_code
  FROM   gmF.cm_cmpt_mtl
  WHERE  co_code = :co_code
  AND    item_id = :item_id
  AND    eff_start_date <= :cost_date
  AND    NVL(eff_end_date, :cost_date) >= :cost_date
  AND    use_ind = 'Y';

• Cost class coverage report — join to IC_COST_CLS to report which cost classes have material components defined.
• Analysis code distribution — group by MTL_ANALYSIS_CODE joined to CM_ALYS_MST to analyze material cost composition.
• Effective dating audits — detect overlapping or expired assignments per business key.
• Organization rollups — join CO_CODE to SY_ORGN_MST for multi-organization costing summaries.

Related Objects

The following are the most significant referencing and referenced objects, based on documented foreign keys:

• CM_CMPT_MST / CM_CMPT_MST_B — cost component class master; joined via MTL_CMPNTCLS_ID.
• CM_ALYS_MST — material analysis code master; joined via MTL_ANALYSIS_CODE.
• IC_ITEM_MST / IC_ITEM_MST_B — item master; joined via ITEM_ID.
• IC_COST_CLS — item cost class definitions; joined via ITEMCOST_CLASS.
• SY_ORGN_MST / SY_ORGN_MST_B — organization master; joined via CO_CODE.
• CM_TEXT_HDR — text/notes header; joined via TEXT_CODE.
• FV_LEGAL_ENTITIES — legal entity reference; joined via LEGAL_ENTITY_ID.

These relationships make CM_CMPT_MTL a central junction for cost component configuration in process manufacturing costing.