OPM Item Process and Recipe Attributes – Oracle EBS SQL Report

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

Overview

Oracle Process Manufacturing (OPM) item attributes: for every process-manufacturing-enabled item, its recipe, process-execution, quality and costing enabled flags, grade control and default grade, lot / child-lot control, lot divisibility, and shelf-life control and days. Lets formulation and QA teams see which items are recipe and process enabled.

Report Parameters

Organization Code, Item, Item Status

Oracle EBS Tables Used

mtl_system_items_vl, org_organization_definitions, org_access_view

Report Categories

Enginatics

INV Cycle count hit/miss analysis, INV Cycle count entries and adjustments, INV Cycle counts pending approval, INV Cycle count listing, CAC Item Cost Summary, INV Cycle count unscheduled items, INV Cycle count schedule requests, CAC Last Standard Item Cost, OPM Batch Lot Genealogy

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 OPM Item Process and Recipe Attributes 05-Jun-2026 120010.xlsx
Blitz Report™ XML Import OPM_Item_Process_and_Recipe_Attributes.xml
Full SQL on Enginatics www.enginatics.com/reports/opm-item-process-and-recipe-attributes/

© 2026 Enginatics