Search Results cm_cmpt_mst_b




Overview
Explore in AI Chat

Overview

The CM_CMPT_MST_B table is the Cost Component Master within Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2. It is a core data object in the Process Manufacturing Financials (GMF) module, specifically designed for cost management in process manufacturing environments. This table serves as the master repository for defining and storing all cost components used in product costing. A cost component represents a distinct category of cost, such as material, labor, overhead, or burden, that accumulates to form the total cost of a manufactured item. The table's primary role is to provide a centralized, controlled list of these components, ensuring consistency across cost calculations, allocations, journal entries, and procurement costing, as evidenced by its extensive foreign key relationships with other GMF and GL tables.

Key Information Stored

While the provided metadata does not list specific columns beyond the primary key, the structure and relationships define its critical data elements. The central identifier is the COST_CMPNTCLS_ID, which is the primary key and uniquely identifies each cost component record. Other significant columns, inferred from foreign key relationships, include CMPNT_GROUP, which links a component to a classification group via the CM_CMPT_GRP table, and TEXT_CODE for descriptive text managed in CM_TEXT_HDR. The table stores the essential attributes for each component, such as its name, status, and control flags that dictate how the cost component is treated in various financial and manufacturing transactions.

Common Use Cases and Queries

This table is fundamental for cost setup, analysis, and reconciliation. A primary use case is the configuration of the cost model for items, where specific components are assigned to define cost buildup. It is also critical for running cost simulations, reviewing cost distributions, and troubleshooting cost variances. For reporting, analysts frequently join this master table to transactional detail tables to produce reports that break down costs by component. A common query pattern involves retrieving active cost components for a specific item or cost type. For example, to list all cost components associated with purchase order costs, one might join to the PO_COST_MST table referenced in the metadata:

  • SELECT cmp.cost_cmpntcls_id, cmp.component_name, po.po_header_id FROM gmf.cm_cmpt_mst_b cmp JOIN apps.po_cost_mst po ON po.cmpntcls_id = cmp.cost_cmpntcls_id WHERE po.creation_date > SYSDATE - 30;

Related Objects

The CM_CMPT_MST_B table has a central position in the GMF schema, with numerous foreign key dependencies as documented. Key related objects include: