Results for “cm_cmpt_mst_b”

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

Overview

CM_CMPT_MST_B is the Cost Component Master table in the Oracle E-Business Suite Process Manufacturing Financials (GMF) module. It resides in the GMF schema and serves as the central definition repository for cost components used throughout process manufacturing costing and financial reporting. Cost components represent the elemental building blocks of product cost — such as material, labor, overhead, and resource charges — which are aggregated by the costing engine to produce item-level and process-level cost rollups.

The table acts as a reference master against which cost adjustments, burden associations, cost ledgers, allocation bases, and resource definitions are configured. Because it is the definitive source for cost component identity, description, and grouping, most downstream costing transactions resolve their component attributes through foreign key references to this table.

From a Data Vault modeling perspective, the FK structure suggests this object is hub-leaning: it holds the durable business key (COST_CMPNTCLS_ID) around which many dependent links and satellites are organized. This classification is heuristic and intended as a modeling suggestion only.

Key Information Stored

The table contains 49 documented columns. The most functionally significant are:

• COST_CMPNTCLS_ID — The primary key (CM_CMPT_MST_B_PK) and the surrogate identifier for each cost component class; this is the column referenced by nearly every foreign key in the ETRM relationship map.
• COST_CMPNTCLS_CODE#1 — The business key code that uniquely identifies the cost component class in user-facing screens and reports.
• COST_CMPNTCLS_DESC#1 — The descriptive name of the cost component class.
• CMPNT_GROUP#1 — Foreign key to CM_CMPT_GRP, indicating the grouping to which the component belongs for rollup and reporting.
• PRIMARY_CMPNTCLS_ID — Identifies the primary component relationship, useful for hierarchy and alternate component mapping.
• USAGE_IND — Flags whether the component is actively used in costing.
• PRODUCT_COST_IND and UPDATE_COST_IND — Indicators controlling whether the component participates in product costing and cost update processes.
• PPV_IND — Indicator governing purchase price variance treatment for the component.
• SORT_SEQUENCE — Governs display and processing order in cost component listings.
• TEXT_CODE — Foreign key to CM_TEXT_HDR, linking the component to external descriptive text.
• TRANS_CNT and DELETE_MARK — Standard process manufacturing audit and logical-deletion controls.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard who-columns maintained by the EBS audit framework.
• ATTRIBUTE1 through ATTRIBUTE30 and ATTRIBUTE_CATEGORY — The DFF (descriptive flexfield) block used for customer-specific extensions.

Common Use Cases and Queries

Because the table is a master reference, the most common query pattern resolves component identity and description for a costing record:

• Selecting active components for costing: SELECT COST_CMPNTCLS_CODE#1, COST_CMPNTCLS_DESC#1 FROM GMF.CM_CMPT_MST_B WHERE USAGE_IND = 'Y' AND NVL(DELETE_MARK,0) = 0 ORDER BY SORT_SEQUENCE;
• Joining components to their group: SELECT m.COST_CMPNTCLS_CODE#1, g.CMPNT_GROUP FROM GMF.CM_CMPT_MST_B m, GMF.CM_CMPT_GRP g WHERE m.CMPNT_GROUP#1 = g.CMPNT_GROUP;
• Resolving component detail for a cost adjustment in CM_ADJS_DTL: join on CM_ADJS_DTL.COST_CMPNTCLS_ID = CM_CMPT_MST_B.COST_CMPNTCLS_ID.
• Reporting burden associations by source or target component via GMF_BURDEN_ASSOCIATION.

Typical reporting uses include cost component master listings, burden configuration audits, and reconciliation of cost policy mappings to allocation bases.

Related Objects

• CM_CMPT_GRP — Referenced via CM_CMPT_MST_B.CMPNT_GROUP#1; defines component grouping.
• CM_TEXT_HDR — Referenced via CM_CMPT_MST_B.TEXT_CODE; supplies descriptive text.
• CM_CMPT_DTL — References CM_CMPT_MST_B.COST_CMPNTCLS_ID; holds component detail lines.
• CM_ACST_LED and GL_ITEM_DTL — Reference COST_CMPNTCLS_ID; drive actual cost ledger and item cost detail.
• CM_ADJS_DTL and CM_BRDN_DTL — Reference COST_CMPNTCLS_ID; hold adjustments and burden detail.
• CR_RSRC_MST_B — References COST_CMPNTCLS_ID; links resource masters to components.
• GMF_BURDEN_ASSOCIATION — References both SOURCE_CMPNTCLS_ID and TARGET_CMPNTCLS_ID; defines burden flow between components.
• GL_PLCY_MST, GL_ALOC_BAS, GL_ACCT_MAP, and PO_COST_MST — Reference the component class for policy, allocation, accounting, and purchase cost mapping.