Search Results period_perp_qty

Overview

CM_CMPT_DTL_VW is a reporting view owned by the APPS schema in Oracle E-Business Suite, registered as a VALID database object within the GMF – Process Manufacturing Financials product family. It is documented as a "View of TOTAL_COST," exposing the component cost detail records maintained by the Process Manufacturing costing engine. In releases 12.1.1 and 12.2.2, the view serves as a read-oriented presentation layer over the component cost detail table, allowing cost accountants, report developers, and integration points to retrieve granular cost buildup information without directly querying the underlying transactional table.

The view is particularly relevant to users searching on "cost_level," since COST_LEVEL is one of the columns projected by the view and is central to interpreting how a component cost was accumulated across the cost rollup hierarchy. Because the view preserves the full column list of its base object, it functions as a convenient, stable interface for both ad hoc reporting and programmatic extraction of cost component data.

Underlying Base Objects

The documented reference for CM_CMPT_DTL_VW is a single base object: CM_CMPT_DTL, accessed through a SYNONYM. The view definition is a straightforward projection:

• SELECT — All significant columns from CM_CMPT_DTL, including the full ATTRIBUTE1 through ATTRIBUTE30 descriptive flexfield segment set, WHO audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN), and the DFF context column ATTRIBUTE_CATEGORY.
• FROM — CM_CMPT_DTL.

No joins, filters, or aggregation are applied, so the view returns one row per component cost record in the base table. This distinguishes it from analytical or summarized views; it is essentially a pass-through view that presents the raw component cost detail with all descriptive and audit attributes intact.

Key Columns

The projected columns fall into several functional groups:

• Identity and context: CMPNTCOST_ID (primary key of the component cost record), ITEM_ID and INVENTORY_ITEM_ID, WHSE_CODE, ORGANIZATION_ID, CALENDAR_CODE, PERIOD_CODE, and PERIOD_ID define the item, warehouse, organization, and costing period context.
• Costing attributes: COST_MTHD_CODE, COST_CMPNTCLS_ID, COST_ANALYSIS_CODE, COST_TYPE_ID, and COST_LEVEL describe the method, component class, analysis grouping, cost type, and the level within the cost rollup at which the component cost was accumulated.
• Amounts and quantities: CMPNT_COST, TOTAL_QTY, PERIOD_TRANS_QTY, and PERIOD_PERP_QTY carry the cost value and associated quantities.
• Rollup and burden indicators: BURDEN_IND, ROLLOVER_IND, RMCALC_TYPE, ROLLUP_REF_NO, FMEFF_ID, and COSTCALC_ORIG indicate whether burden was applied, whether the record participates in rollover, the rollup reference, and the originating calculation.
• Process and audit fields: ACPROC_ID, TRANS_CNT, TEXT_CODE, DELETE_MARK, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, and the standard WHO columns support concurrency, traceability, and cleanup.
• Descriptive flexfield: ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE30 provide extensibility.

Common Use Cases and Queries

Typical uses include cost detail reporting, cost rollup analysis, period cost reconciliation, and data extraction for downstream costing or analytics. The following example retrieves component cost records for a given organization and period, ordered by cost level:

• SELECT item_id, organization_id, period_code, cost_level, cost_cmpntcls_id, cmpnt_cost, total_qty, burden_ind FROM apps.cm_cmpt_dtl_vw WHERE organization_id = :org_id AND period_code = :period AND delete_mark = 0 ORDER BY cost_level, cost_cmpntcls_id;
• Filtering by COST_LEVEL is common when isolating costs accumulated at a specific rollup level or comparing level-by-level buildup.
• Joining to inventory item and cost component class reference tables enriches output with item descriptions and class names.

Because the view is a direct projection, queries against it may be wrapped in additional predicates or combined with cost type and cost analysis dimensions to produce period-end cost reports and audit extracts.