Search Results cm_cmpt_mst




Overview
Explore in AI Chat

Overview

The CM_CMPT_MST table is the Cost Component Master table within the Process Manufacturing Financials (GMF) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the central repository for defining and managing distinct cost components used in product costing. A cost component is a classification for a type of cost, such as material, labor, overhead, or a user-defined element, which allows for detailed cost accumulation, analysis, and reporting. This master data is foundational for the cost accounting and financial control of manufacturing processes, enabling the segregation of costs for accurate inventory valuation, variance analysis, and profitability reporting.

Key Information Stored

While the provided metadata does not list specific columns, the primary and foreign key relationships define its core structure. The table's primary key is COST_CMPNTCLS_ID, which uniquely identifies each cost component record. Key descriptive attributes, though not enumerated, typically include the component name, description, and status. The table maintains critical relationships through foreign keys: CMPNT_GROUP links to the CM_CMPT_GRP table for component grouping, and TEXT_CODE links to CM_TEXT_HDR for descriptive flexfield or textual descriptions. This structure ensures that each cost component is properly categorized and described within the system.

Common Use Cases and Queries

A primary use case is the setup and maintenance of the costing model. Analysts define cost components to mirror the organization's cost structure. Common reporting involves listing all active components or querying components associated with a specific group. For troubleshooting or data validation, identifying all cost transactions for a particular component is essential. Sample SQL patterns include fetching basic component details and joining with transaction tables to analyze cost postings.

  • SELECT cost_cmpntcls_id, name, description FROM cm_cmpt_mst WHERE enabled_flag = 'Y';
  • SELECT mst.cost_cmpntcls_id, mst.name, dtl.* FROM cm_cmpt_mst mst, cm_acst_led dtl WHERE mst.cost_cmpntcls_id = dtl.cost_cmpntcls_id;

Related Objects

As indicated by its extensive foreign key relationships, CM_CMPT_MST is a critical reference table for numerous transactional and setup tables across GMF and related modules. Key dependent objects include CM_ACST_LED (Actual Cost Ledger), CM_ADJS_DTL (Adjustment Details), and CM_BRDN_DTL (Burden Details), which store detailed cost transactions tagged with a component ID. Setup tables like GL_ACCT_MAP (Account Mapping) and GL_PLCY_MST (Policy Master) reference it to define accounting rules. It is also referenced in operational tables such as CR_RSRC_MST (Resources), FM_OPRN_DTL (Formulation Operations), and PO_COST_MST (Purchase Order Costing), linking cost components to production and procurement activities.