OPM Item Location Test Results – Oracle EBS SQL Report

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

Overview

Oracle Process Manufacturing (OPM) Quality item/location test results: the QC test results recorded against inventory item, lot and subinventory samples, with the result value, the applicable specification minimum/target/maximum limits, an in-specification indicator and the sample disposition. The governing specification is resolved from the inventory spec validity rule effective for each sample’s item, organization and lot. Answers what the lab results were for a given item or lot and whether they were in specification.

Report Parameters

Organization Code, Item, Lot Number like, Test, Sample Date From, Sample Date To

Oracle EBS Tables Used

gmd_results, gmd_samples, gmd_qc_tests_b, gmd_qc_tests_tl, mtl_system_items_vl, org_organization_definitions, gmd_inventory_spec_vrs, gmd_specifications_b, gmd_spec_tests_vl, org_access_view

Report Categories

Enginatics

OPM Specifications and Test Limits, 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 Item Location Test Results 05-Jun-2026 120008.xlsx
Blitz Report™ XML Import OPM_Item_Location_Test_Results.xml
Full SQL on Enginatics www.enginatics.com/reports/opm-item-location-test-results/

© 2026 Enginatics