OPM Specifications and Test Limits – Oracle EBS SQL Report

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

Overview

Oracle Process Manufacturing (OPM) Quality specifications and test limits: every GMD specification with its version and status, the item and grade it applies to, and each specification test’s minimum, target and maximum limits, UOM, certificate-of-analysis print flag and report precision. The master reference for an organization’s quality standards.

Report Parameters

Organization Code, Item, Spec, Spec Status, Grade, Test

Oracle EBS Tables Used

gmd_specifications_b, gmd_specifications_tl, gmd_spec_tests_vl, gmd_qc_tests_b, gmd_qc_tests_tl, mtl_system_items_vl, org_organization_definitions, gmd_status_vl, org_access_view

Report Categories

Enginatics

OPM Item Location Test Results, OPM Recipe Details, CAC OPM Costed Formula

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 Specifications and Test Limits 05-Jun-2026 120009.xlsx
Blitz Report™ XML Import OPM_Specifications_and_Test_Limits.xml
Full SQL on Enginatics www.enginatics.com/reports/opm-specifications-and-test-limits/

© 2026 Enginatics