CAC OPM Item Cost Detail – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Oracle Process Manufacturing (OPM) item cost detail: the costed value of each item broken out by cost component class (material, labor, burden, overhead) and cost analysis code, per cost calendar, period and method. Answers what makes up an item’s OPM cost.

Report Parameters

Organization Code, Item, Cost Calendar, Cost Method, Cost Component Class

Oracle EBS Tables Used

cm_cmpt_dtl, mtl_system_items_vl, cm_cmpt_mst_vl, cm_mthd_mst, gmf_period_statuses, org_organization_definitions, org_access_view

Report Categories

Enginatics

CAC OPM Costed Formula, CAC Inventory Lot and Locator OPM Value (Period-End), CAC OPM Batch Material Summary, CAC Inventory and Intransit Value (Period-End) - Discrete/OPM

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output CAC OPM Item Cost Detail 05-Jun-2026 120011.xlsx
Blitz Report™ XML Import CAC_OPM_Item_Cost_Detail.xml
Full SQL on Enginatics www.enginatics.com/reports/cac-opm-item-cost-detail/

© 2026 Enginatics