Results for “cm_cmpt_mtl_pk”

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

Overview

GMF.CM_CMPT_MTL is a manufacturing cost management table in the Oracle E-Business Suite Process Manufacturing (OPM / GMF) schema. It stores item-level and item cost class–level material cost component definitions together with their associated material analysis codes. In practical terms, the table defines which material component class and which material analysis code apply to a given item (or item cost class) for a given company and cost category, over a defined effective date range. It is a core configuration object for OPM Cost Management, feeding costing rollups and material variance analysis.

From a Data Vault modeling perspective, the metadata's relationship structure suggests this object behaves as a link, connecting multiple business hubs — item, cost class, component master, analysis master, company/organization, and legal entity — through foreign keys, while carrying descriptive and effectivity attributes that function as satellite data. The presence of CMPTMTL_ID (a surrogate) alongside natural composite keys supports this classification.

Key Information Stored

The table's columns fall into surrogate, business, effectivity, and audit groups. The most significant are:

• CMPTMTL_ID — Surrogate primary key; a system-generated number uniquely identifying each material component class/analysis code definition row. It is enforced by the unique index CM_CMPT_MTL_PK.
• CO_CODE — Company for which the material component and analysis code is defined.
• ITEM_ID and INVENTORY_ITEM_ID — The item for which the component and analysis code apply; both reference the item master.
• ITEMCOST_CLASS — The item cost class being defined, referencing IC_COST_CLS.
• MTL_CMPNTCLS_ID — Foreign key to the material component class master (CM_CMPT_MST / CM_CMPT_MST_B).
• MTL_ANALYSIS_CODE — The material analysis code assigned to the item or cost class, referencing CM_ALYS_MST.
• EFF_START_DATE and EFF_END_DATE — The effective date window governing when the definition is valid.
• COST_CATEGORY_ID — The cost category associated with the cost class.
• LEGAL_ENTITY_ID, ORGANIZATION_ID, and MASTER_ORGANIZATION_ID — Organizational and legal entity context for the definition.
• TEXT_CODE — Joins rows to the module's text table (CM_TEXT_HDR).
• DELETE_MARK — Standard logical deletion flag (0 = active, 1 = logically deleted).
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit (WHO) columns.

The documented business-key candidate is the composite CM_CMPT_MTLI0 index, typically spanning CO_CODE, ITEM_ID, ITEMCOST_CLASS, EFF_START_DATE, distinguishing the natural key from the surrogate CMPTMTL_ID.

Common Use Cases and Queries

Typical usage includes determining the material component class and analysis code applied to an item, validating effectivity windows, and driving cost rollup and variance reporting. A common pattern joins the table to the component and analysis masters and filters on the active flag and current date:

• Identify the active material component class for an item: select from CM_CMPT_MTL where INVENTORY_ITEM_ID = :item and DELETE_MARK = 0 and trunc(sysdate) between EFF_START_DATE and nvl(EFF_END_DATE, sysdate).
• Join to CM_CMPT_MST_B on MTL_CMPNTCLS_ID to resolve the component class description.
• Join to CM_ALYS_MST on MTL_ANALYSIS_CODE to resolve analysis code meaning.
• Report by legal entity or organization using LEGAL_ENTITY_ID / ORGANIZATION_ID against FV_LEGAL_ENTITIES.
• Extract effectivity ranges to detect overlapping or expired definitions.

Note that the user query "mt full form in gst" is unrelated to this object; in GST (India tax) terminology "MT" most commonly denotes "Maharashtra" state code or "Metric Ton," whereas within this EBS context MTL refers to the manufacturing (MTL) tables, not GST.

Related Objects

• CM_CMPT_MST_B / CM_CMPT_MST — joined via MTL_CMPNTCLS_ID; the material component class master.
• CM_ALYS_MST — joined via MTL_ANALYSIS_CODE; the material analysis code master.
• IC_ITEM_MST_B / IC_ITEM_MST — joined via ITEM_ID; the OPM item master.
• IC_COST_CLS — joined via ITEMCOST_CLASS; the item cost class definitions.
• SY_ORGN_MST_B / SY_ORGN_MST — joined via CO_CODE; company/organization master.
• FV_LEGAL_ENTITIES — joined via LEGAL_ENTITY_ID; legal entity definitions.
• CM_TEXT_HDR — joined via TEXT_CODE; stores descriptive text for the definition rows.

These relationships make CM_CMPT_MTL a central bridge between item costing, cost class configuration, and material analysis in OPM Cost Management.