OPM Recipe Details – Oracle EBS SQL Report

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

Overview

OPM (Process Manufacturing) recipe details combining recipe status, validity rules, preferences, formula product quantity and routing step / resource quantities. Supports data cleaning before cost roll up. Optionally shows an item category code via the Category Set parameter.

Report Parameters

Organization Code, Recipe, Item, Recipe Status, Category Set

Oracle EBS Tables Used

gmd_recipes_vl, org_organization_definitions, gmd_recipe_validity_rules, mtl_system_items_vl, gmd_status_vl, fm_rout_hdr, mtl_item_categories, mtl_categories_b_kfv, mtl_category_sets_vl, fm_matl_dtl, gmd_operation_resources, gmd_operation_activities, gmd_operations_vl, fm_rout_dtl, org_access_view

Report Categories

Enginatics

OPM Recipe Upload, OPM Formula Where-Used

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 Recipe Details 05-Jun-2026 120000.xlsx
Blitz Report™ XML Import OPM_Recipe_Details.xml
Full SQL on Enginatics www.enginatics.com/reports/opm-recipe-details/

© 2026 Enginatics