Results for “cm_cmpt_dtl”

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

Overview

CM_CMPT_DTL is the Cost Component Details table owned by the GMF schema in Oracle Process Manufacturing Financials (OPM Financials). It stores the item-level cost component breakdown produced by the OPM costing engine, holding the calculated cost of each component class (material, resource, overhead, burden, and similar) for a given item, warehouse, cost method, and accounting period. Because costing in OPM is period-driven, this table acts as the detail ledger behind cost rollups, standard cost updates, and inventory valuation reporting.

Under a heuristic Data Vault classification mined from its foreign-key structure, the table is satellite-leaning: it carries a surrogate primary key plus descriptive measures and is keyed by a composite business key referencing several hub-like master entities (item, warehouse, calendar, cost component class, cost method). Its grain is effectively one row per item/warehouse/period/cost component combination.

Key Information Stored

The 67 documented columns capture identity, business context, and calculated measures. The most significant are:

• CMPNTCOST_ID — the surrogate primary key defined by CM_CMPT_DTL_PK and reused as the unique index CM_CMPT_DTL_U1. This is the column most users search for when tracing downstream ledgers.
• ITEM_ID and WHSE_CODE — the manufactured or costed item and the warehouse at which the cost applies.
• CALENDAR_CODE and PERIOD_CODE — the cost calendar and accounting period that anchor the cost record in time.
• COST_MTHD_CODE — the cost method (standard, actual, or similar) governing the calculation.
• COST_CMPNTCLS_ID — the cost component class, which drives how the cost is grouped and rolled up.
• COST_LEVEL and COST_ANALYSIS_CODE — the level within the cost rollup hierarchy and the analysis category used for margin and variance reporting.
• CMPNT_COST — the calculated cost amount for the component.
• BURDEN_IND and ROLLOVER_IND — flags indicating whether the component is a burden element and whether it participates in rollover processing.
• TOTAL_QTY, PERIOD_TRANS_QTY, and PERIOD_PERP_QTY — quantities used to derive unit costs and to reconcile period movements.
• ROLLUP_REF_NO and ACPROC_ID — references to the rollup control record and the actual cost process that generated the detail row.
• COST_TYPE_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID, and PERIOD_ID — the 12.2.2 multi-organization and cost-type dimensions that support integration with the Core Costing and SLA structures.
• FMEFF_ID and TEXT_CODE — the formula effectivity reference and the descriptive text header attached to the record.
• DELETE_MARK plus the standard Oracle audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) and the 30 ATTRIBUTE1..30 flex columns and ATTRIBUTE_CATEGORY.

Each foreign key above is a business-key candidate in the Data Vault sense; CMPNTCOST_ID is the purely technical surrogate.

Common Use Cases and Queries

The table is queried whenever an item's cost must be explained by component, verified for a period, or reconciled against a downstream ledger.

• Component cost breakdown for an item:

SELECT cmpntcost_id, item_id, whse_code, period_code,
       cost_cmpntcls_id, cost_level, cmpnt_cost, burden_ind
FROM   gmf.cm_cmpt_dtl
WHERE  item_id      = :item_id
AND    whse_code    = :whse_code
AND    period_code  = :period_code
AND    NVL(delete_mark,0) = 0;

• Rollup traceability: joining on ROLLUP_REF_NO to CM_RLUP_CTL reconstructs which rollup process produced each component row.
• Burden versus prime cost analysis: aggregating CMPNT_COST grouped by BURDEN_IND and COST_CMPNTCLS_ID supports cost absorption reporting.
• Quantity reconciliation: comparing TOTAL_QTY, PERIOD_TRANS_QTY, and PERIOD_PERP_QTY against inventory transaction volumes for the same period.
• Detailed ledger drill-down: joining children such as CM_ACST_LED, CM_SCST_LED, and CM_BRDN_DTL on CMPNTCOST_ID for actual, standard, and burden cost postings.

Related Objects

Relationships below are taken from the documented FK structure.

• CM_ACST_LED, CM_SCST_LED, CM_BRDN_DTL — actual, standard, and burden cost ledgers that reference CM_CMPT_DTL.CMPNTCOST_ID; the primary drill-down direction for cost inquiry and reporting.
• CM_CMPT_MST / CM_CMPT_MST_B — cost component class master, joined on COST_CMPNTCLS_ID.
• CM_MTHD_MST — cost method master, joined on COST_MTHD_CODE.
• CM_CLDR_DTL — cost calendar detail, joined on CALENDAR_CODE and PERIOD_CODE.
• CM_ALYS_MST — cost analysis master, joined on COST_ANALYSIS_CODE.
• CM_RLUP_CTL and CM_ACPR_CTL — rollup control and actual cost process control, joined on ROLLUP_REF_NO and ACPROC_ID.
• IC_ITEM_MST, IC_ITEM_MST_B, and IC_WHSE_MST — item and warehouse masters, joined on ITEM_ID and WHSE_CODE.
• CM_CMPT_DTL_EFC and FM_FORM_EFF — effectivity and formula effectivity references, joined on CMPNTCOST_ID and FMEFF_ID respectively.
• CST_COST_TYPES — cost type definition, joined on COST_TYPE_ID for multi-organization cost-type segregation.