Results for “cost_cmpntcls_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
CM_CMPT_MST_TL is the translation (TL) table for the Cost Component Master entity within the GMF – Process Manufacturing Financials product family. In Oracle E-Business Suite, cost components represent the building blocks used to assemble cost build-ups, rollups, and cost breakdowns for process-manufactured items. Because Oracle EBS supports multi-language deployments, every translatable descriptive attribute is stored in a companion TL table keyed by language, while language-independent attributes remain in the base table (CM_CMPT_MST_B). This table holds the translated descriptions of cost component classes.
The object resides in the GMF schema and is documented as VALID in ETRM 12.2.2. Its heuristic Data Vault classification, mined from the foreign-key structure, is standalone, meaning it does not participate in a parent-child FK chain within the mined model. From a modeling perspective, this classifies the table as a satellite-like construct: its primary key combines the parent entity identifier with a language discriminator, and it carries descriptive, versioned-by-language text rather than transactional measures. In Data Vault terms, COST_CMPNTCLS_ID functions as the hub reference and LANGUAGE as the satellite driving key.
Key Information Stored
The table contains nine documented columns. The primary key, CM_CMPT_MST_TL_PK, is a composite surrogate key over (COST_CMPNTCLS_ID, LANGUAGE). The same column pair also constitutes the sole documented unique index, making it the business-key candidate that enforces one translated row per cost component class per installed language.
- COST_CMPNTCLS_ID – Surrogate identifier of the cost component class; the join back to the base table and the hub reference in the composite key.
- LANGUAGE – Installed language code; the second component of the primary key and the discriminator that isolates each translation row.
- SOURCE_LANG – The language from which the translated description was derived, used by the translation framework to detect stale or missing translations.
- COST_CMPNTCLS_DESC#1 – The translated description of the cost component class; the primary user-facing attribute exposed by this table.
- CREATION_DATE, CREATED_BY – Standard WHO audit columns capturing row creation metadata.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN – Standard WHO audit columns capturing the most recent modification and the login context of the updater.
The WHO columns follow the standard EBS audit convention and are maintained automatically by the application's audit-attribute infrastructure; they should not be populated by custom code.
Common Use Cases and Queries
The most frequent requirement is reporting cost component class descriptions in the user's session language while retaining the base table's language-independent attributes. A typical query joins the TL table to the base entity on COST_CMPNTCLS_ID and filters by LANGUAGE:
- Language-specific lookup:
SELECT b.cost_cmpntcls_id, t.cost_cmpntcls_desc#1 FROM cm_cmpt_mst_b b, cm_cmpt_mst_tl t WHERE b.cost_cmpntcls_id = t.cost_cmpntcls_id AND t.language = USERENV('LANG') - Multi-language comparison: Group by COST_CMPNTCLS_ID and pivot on LANGUAGE to identify components whose translations diverge or are missing in a given language.
- Translation completeness audit: Compare row counts in the TL table per LANGUAGE against the base table to detect untranslated cost component classes, and inspect SOURCE_LANG to flag rows where the source and installed languages differ.
- Change tracking: Filter on LAST_UPDATE_DATE to extract recently re-translated descriptions for downstream data warehouse or master data governance feeds.
Because the table is keyed by language, reports that omit the LANGUAGE predicate will return one row per installed language and produce duplicated cost component descriptions.
Related Objects
The metadata documents no explicit foreign keys, consistent with its standalone Data Vault classification, but the following objects are the most significant participants in the surrounding model:
- CM_CMPT_MST_B – The base (non-translated) Cost Component Master table; joins on COST_CMPNTCLS_ID and supplies language-independent attributes.
- CM_CMPT_MST_TL_PK – The composite unique index over (COST_CMPNTCLS_ID, LANGUAGE) that enforces one translation row per class per language.
- FND_LANGUAGES – Reference table validating the LANGUAGE and SOURCE_LANG values against installed languages.
- FND_APPLICATION / FND_PRODUCT_INSTALLATIONS – Metadata objects that govern GMF schema ownership and translation framework registration.
- CM_CMPT_MST_VL – Where present, the translated view that unions base and TL columns to present a single logical row per cost component class.
Cost component classes defined here are consumed by the process manufacturing costing programs that build item cost rollups, so downstream costing and valuation reports depend indirectly on the accuracy of the descriptions held in this table.
-
Table to store translated columns for Cost Component Master Table
-
Shadow table of GL_ITEM_DTL for EFC migration. Stores the original values of columns of GL_ITEM_DTL that are to be converted to the Euro currency as a part of EFC migration. The table consists of the primary key columns of GL_ITEM_DTL and
-
Shadow table of GL_ITEM_DTL for EFC migration. Stores the original values of columns of GL_ITEM_DTL that are to be converted to the Euro currency as a part of EFC migration. The table consists of the primary key columns of GL_ITEM_DTL and
-
Table: CM_ADJS_DTL_EFC 12.1.1
Shadow table of CM_ACST_LED for EFC migration. Stores the original values of columns of CM_ACST_LED that are to be converted tothe Euro currency as a part of EFC migration. The table consists of the primary key columns of CM_ACST_LED and
-
Layer Cost Details
-
Cost component detail information for the item. Component details for the Accounting cost available in GL_ITEM_CST table.
-
Table to store translated columns for Cost Component Master Table
-
Resource master
-
OPM Lot Cost Adjustments details table
-
OPM Lot Cost Adjustments details table
-
View: CM_CMPT_DTL_VW1 12.1.1
View on cm_cmpt_dtl
APPS.CM_CMPT_DTL_VW1·↳ CM_CMPT_DTL·↳ CM_CMPT_MST·↳ CM_MTHD_MST·Explore GMF module →
-
This table stores the cost adjustment details as part of OPM Costing
-
This table stores the cost adjustment details as part of OPM Costing
-
Table: CM_ADJS_DTL_EFC 12.2.2
Shadow table of CM_ACST_LED for EFC migration. Stores the original values of columns of CM_ACST_LED that are to be converted tothe Euro currency as a part of EFC migration. The table consists of the primary key columns of CM_ACST_LED and
-
Cost component detail information for the item. Component details for the Accounting cost available in GL_ITEM_CST table.
-
View: PMIBV_BURDEN_V 12.1.1
Costing information for Burden (overhead) details
-
GMD Operation Resources View
APPS.PMITS_OPERATION_RESOURCES_V·↳ DUAL·Explore PMI module →
-
GMD Operation Resources View
APPS.PMITS_OPERATION_RESOURCES_V·↳ DUAL·Explore PMI module →
-
View: GMD_MBR_RECIPE_RSRC_V1 12.1.1
This view is used to retrieve Resource Requirements Information for Master Batch Record XML generation.
APPS.GMD_MBR_RECIPE_RSRC_V1·↳ CR_RSRC_MST_B·↳ FM_ROUT_DTL·↳ GMD_OPERATIONS_B·Explore GMD module →
-
View for the value set , GMF_COST_CMPNT_CLASS_SLA
APPS.GMF_COST_CMPNT_CLASS_SLA_V·↳ CM_CMPT_MST·↳ DUAL·Explore GMF module →
-
Obsolete
-
Stores extract lines temporarily in a Session to create events in SLA. Once events get created, rows from this table are inserted into GMF_XLA_EXTRACT_LINES table.
-
Stores extract lines temporarily in a Session to create events in SLA. Once events get created, rows from this table are inserted into GMF_XLA_EXTRACT_LINES table.
-
Cost Burden Details - contains the Burden (Overhead) costs applied to an item
-
View: PMIBV_BURDEN_V 12.2.2
Costing information for Burden (overhead) details
-
This table is the SLA Extract Lines table. The transactions for process inventory organizations are processed and all the necessary data for accounting are stored in this table. When the SLA accounting program is run data from this table
-
Resource master
-
View: PMIBV_ITEM_COST_V 12.1.1
Costing info for an item. Costing info is retrieved from CM tables, OPM equivalent of the item_cost_from_GL view which retrieves data from the GL tables.
APPS.PMIBV_ITEM_COST_V·↳ CM_CMPT_DTL·↳ CM_CMPT_MST·Explore PMI module →
-
View: CM_CMPT_DTL_VW 12.1.1
View of TOTAL_COST
-
View: GMD_MBR_RECIPE_RSRC_V1 12.2.2
This view is used to retrieve Resource Requirements Information for Master Batch Record XML generation.
APPS.GMD_MBR_RECIPE_RSRC_V1·↳ CR_RSRC_MST_B·↳ FM_ROUT_DTL·↳ GMD_OPERATIONS_B·Explore GMD module →
-
Obsolete
-
Cost Burden Details - contains the Burden (Overhead) costs applied to an item
-
View: PMIFV_ITEM_COST_V 12.1.1
Costing information for an item retrieved from costing tables. This is the OPM costing tables equivalent of the item_cost_from_GL view which retrieves data from the GL tables.
APPS.PMIFV_ITEM_COST_V·↳ CM_CLDR_DTL·↳ CM_CLDR_HDR·↳ CM_CMPT_DTL·Explore PMI module →
-
Costing information for an item retrieved from Oracle Financial GL tables. This is the GL equivalent of the item_cost view which retrieves data from the OPM costing tables.
APPS.PMIFV_ITEM_COST_FROM_GL_V·↳ CM_CLDR_DTL·↳ CM_CLDR_HDR·↳ CM_CMPT_MST·Explore PMI module →
-
View: CM_CMPT_DTL_VW1 12.2.2
View on cm_cmpt_dtl
APPS.CM_CMPT_DTL_VW1·↳ CM_CMPT_DTL·↳ CM_CMPT_MST·↳ CM_MTHD_MST·Explore GMF module →
-
Cost Component Master
-
Supplementary table to store invoice variance amounts for Actual Costing
-
Batch operation details.
-
Batch operation details.
-
Costing info for an item. Costing info is retrieved from the GL equivalent of the item_cost view which retrieves data from OPM tables.
APPS.PMIBV_ITEM_COST_FROM_GL_V·↳ CM_CMPT_MST·↳ GL_ITEM_CST·↳ GL_ITEM_DTL·Explore PMI module →
-
View: PMIBV_ITEM_COST_V 12.2.2
Costing info for an item. Costing info is retrieved from CM tables, OPM equivalent of the item_cost_from_GL view which retrieves data from the GL tables.
APPS.PMIBV_ITEM_COST_V·↳ CM_CMPT_DTL·↳ CM_CMPT_MST·Explore PMI module →
-
View: CR_RSRC_MST_VL 12.2.2
Resource Master view
APPS.CR_RSRC_MST_VL·↳ CR_RSRC_MST_B·↳ CR_RSRC_MST_TL·Explore GMP module →
-
View: CR_RSRC_MST_VL 12.1.1
Resource Master view
APPS.CR_RSRC_MST_VL·↳ CR_RSRC_MST_B·↳ CR_RSRC_MST_TL·Explore GMP module →
-
The Actual Cost Adjustments Details table - contains the adjustments details required and entered for cost adjustments.
-
View: GMF_LC_ADJ_HEADERS_V 12.2.2
View used to store LC adjustments will be populated by LCM tables
APPS.GMF_LC_ADJ_HEADERS_V·↳ INL_DET_LANDED_COSTS_V·↳ INL_SHIP_HEADERS_ALL·↳ MTL_UNITS_OF_MEASURE·Explore GMF module →
-
View: PMIFV_BURDEN_V 12.1.1
Costing information for Burden (Overhead) details
APPS.PMIFV_BURDEN_V·↳ CM_BRDN_DTL·↳ CM_CLDR_DTL·↳ CM_CLDR_HDR·Explore PMI module →
-
View: PMIFV_BURDEN_V 12.2.2
Costing information for Burden (Overhead) details
APPS.PMIFV_BURDEN_V·↳ CM_BRDN_DTL·↳ CM_CLDR_DTL·↳ CM_CLDR_HDR·Explore PMI module →
-
Costing information for an item retrieved from Oracle Financial GL tables. This is the GL equivalent of the item_cost view which retrieves data from the OPM costing tables.
APPS.PMIFV_ITEM_COST_FROM_GL_V·↳ CM_CLDR_DTL·↳ CM_CLDR_HDR·↳ CM_CMPT_MST·Explore PMI module →
-
View: CM_CMPT_MST_VL 12.2.2
Language resolved view of Cost Component Class Master and Translated description table
APPS.CM_CMPT_MST_VL·↳ CM_CMPT_MST_B·↳ CM_CMPT_MST_TL·Explore GMF module →
-
View: FM_OPRN_DTL_VW1 12.1.1
Operation detail view
APPS.FM_OPRN_DTL_VW1·↳ GMD_OPERATION_ACTIVITIES·↳ GMD_OPERATION_RESOURCES·Explore GMD module →