Search Results get_inv_spec_test_value

Overview

GMD_QUALITY_GRP is a public PL/SQL package in the Oracle E-Business Suite APPS schema that supports the Process Manufacturing quality management module (GMD), commonly associated with Oracle Quality and specification-driven inventory operations. Its primary business function is to resolve and return quality specification and test values that govern inventory lots, samples, and test results. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the definer, and it exposes a set of strongly typed PL/SQL record and table structures used to pass quality data between the caller and the database.

The most important of these structures is the input record for inventory test resolution. It carries organization_id, inventory_item_id, grade_code, parent_lot_number, lot_number, subinventory, locator_id, test_id, and plant_id, giving the package the context needed to locate the correct specification for a given item and lot. Corresponding output record structures return specification identifiers, target, minimum, and maximum values, display precision, hierarchy level, and a composite indicator, while additional structures describe sampling events.

Key Procedures and Functions

The ETRM documentation lists five callable program units:

• GET_INV_SPEC_TEST_VALUE — the specific routine the user searched for. It returns the specification test value applicable to an inventory item, resolving the value against the specification associated with the supplied organization, item, lot, and test context.
• GET_INV_TEST_VALUE — resolves the effective test value for an inventory context, providing the general entry point for retrieving a test value against quality specification data.
• GET_INV_RESULT_TEST_VALUE — retrieves the recorded result value together with its acceptable minimum and maximum range, returning data through the result output record structure.
• GET_APPR_SAMPLING_EVENTS — returns approved sampling events and their associated sample, specification, and organization information using the sampling events structures.
• GET_LEVEL — determines the hierarchy level of a specification test within a composite specification, supporting the composite indicator and level fields returned by the other routines.

Parameter lists are not documented in the available metadata and should be confirmed from the package header in the database.

Tables Accessed

The package operates across the GMD quality schema. Specification definitions are read from GMD_SPEC_TESTS_B and GMD_QC_TESTS_B, with item-level values held in GMD_INVENTORY_SPEC_VRS and GMD_SPEC_RESULTS. Composite specifications are resolved through GMD_COMPOSITE_SPEC_DISP and GMD_COMPOSITE_RESULTS. Actual analysis outcomes come from GMD_RESULTS. Sampling data is drawn from GMD_SAMPLES, GMD_SAMPLING_EVENTS, GMD_SAMPLE_SPEC_DISP, and GMD_EVENT_SPEC_DISP. PLITBLM is the standard EBS temporary PL/SQL table used for intermediate processing.

Usage Notes

GMD_QUALITY_GRP is typically invoked from Oracle Quality and Process Manufacturing forms, from concurrent programs that evaluate specifications against results, and from custom PL/SQL that needs the same specification-resolution behaviour as the standard quality application. Because callers depend on the package's published record types, custom code should declare variables using those types rather than redefining their own. Two other packages in the environment already reference this group package, so its interfaces should be treated as stable and backward compatible. All lookups are context-sensitive, so callers must populate organization, item, lot, and test identifiers completely; missing values will produce incorrect or empty results.