Search Results cm_cmpt_grp




Overview
Explore in AI Chat

Overview

The CM_CMPT_GRP table is a core data object within the Process Manufacturing Financials (GMF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Its primary function is to define and store master records for cost component groups. In the context of Process Manufacturing, cost components represent the various elements that constitute the total cost of a manufactured item, such as material, labor, and overhead. This table allows for the logical grouping of these individual cost components, enabling structured cost analysis, reporting, and allocation. It serves as a foundational reference table, ensuring data integrity and consistency for downstream cost calculations and financial reporting within the manufacturing process.

Key Information Stored

While the provided metadata does not list specific columns, the structure and relationships indicate the critical data elements. The primary key column is CMPNT_GROUP, which uniquely identifies each cost component group. A foreign key relationship exists with the CM_TEXT_HDR table via a TEXT_CODE column, which is used to store descriptive, translatable text for the group name or description. This design allows for multilingual support. The table's existence is primarily to define the group identifier and its associated descriptive text, which is then referenced by detailed cost component master tables.

Common Use Cases and Queries

The primary use case is the setup and maintenance of the cost component grouping hierarchy during the implementation and configuration of GMF. Common operational queries involve listing all active groups for assignment to cost components or validating group definitions. A typical reporting query would join this table to the cost component master to analyze the cost structure by group.

  • Basic Group Listing: SELECT cmpnt_group, text_code FROM gmf.cm_cmpt_grp ORDER BY 1;
  • Joining to Descriptive Text: SELECT g.cmpnt_group, t.text FROM gmf.cm_cmpt_grp g, gmf.cm_text_hdr t WHERE g.text_code = t.text_code;
  • Finding Components in a Group: SELECT m.cost_cmpnt_id FROM gmf.cm_cmpt_mst_b m WHERE m.cmpnt_group = '&GROUP_CODE';

Related Objects

The CM_CMPT_GRP table is central to the cost component data model, with several key dependencies as outlined in the metadata.

  • CM_CMPT_MST_B and CM_CMPT_MST: These tables store the detailed cost component master records. They contain a CMPNT_GROUP column that is a foreign key to CM_CMPT_GRP, classifying each cost component into a defined group.
  • CM_TEXT_HDR: This table provides the translatable descriptive text (name/description) for the cost component group via the foreign key relationship on the TEXT_CODE column.
  • CM_CMPT_GRP_PK: The primary key constraint enforcing uniqueness on the CMPNT_GROUP column.