Search Results test_group_order

Overview

GMD_QC_TESTS_VL is a read-only, language-enabled view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It is part of the GMD product family, Process Manufacturing Product Development, and exposes the definition of quality management tests maintained within Oracle Process Manufacturing (OPM) Quality Management. The "VL" suffix denotes a view that joins a base table to its translation table and filters on the session language, yielding a single row per test with the description already resolved into the user's current language.

The view's role is primarily reporting and integration. Rather than resolving the translation join manually, external reports, custom concurrent programs, Discoverer workbooks, and inbound/outbound interfaces can query GMD_QC_TESTS_VL to obtain test codes, descriptive text, specification limits, and action codes in one pass. Because it is a view rather than a table, it cannot be written to directly; maintenance of test definitions is performed through the underlying Quality Management forms and APIs against the base tables.

Underlying Base Objects

The view is defined over two documented base objects:

• GMD_QC_TESTS_B — the base table holding language-independent test attributes (test identity, method, type, numeric limits, action codes, DFF attributes, audit columns).
• GMD_QC_TESTS_TL — the translation table supplying the language-dependent TEST_DESC, joined on TEST_ID and filtered by T.LANGUAGE = USERENV('LANG').

The two are joined by TEST_ID, and the view selects B.ROWID as ROW_ID together with all columns from the base table plus the translated description. The view therefore inherits the row-level and column-level validation of its base tables, including DELETE_MARK, which must be filtered to exclude logically deleted tests.

Key Columns

• TEST_ID / TEST_CODE — unique identifier and the short user-facing code for the quality test.
• TEST_DESC — translated description sourced from the _TL table.
• MIN_VALUE_NUM / MAX_VALUE_NUM — lower and upper numeric specification limits.
• BELOW_SPEC_MIN, ABOVE_SPEC_MIN, BELOW_SPEC_MAX, ABOVE_SPEC_MAX — the four out-of-specification indicator flags that bracket the minimum and maximum limits.
• BELOW_MIN_ACTION_CODE, ABOVE_MIN_ACTION_CODE, BELOW_MAX_ACTION_CODE, ABOVE_MAX_ACTION_CODE — instructions dictating what action to take when a result breaches each corresponding specification boundary.
• EXP_ERROR_TYPE — expected error tolerance type applied to results.
• TEST_METHOD_ID / TEST_CLASS / TEST_TYPE / TEST_UNIT — characterization of the test procedure and the unit of measure.
• EXPRESSION — any expression associated with calculated test results.
• DISPLAY_PRECISION / REPORT_PRECISION — rounding rules for on-screen display versus printed reporting.
• PRIORITY / TEST_GROUP_ORDER / TEST_OPRN_ID / TEST_OPRN_LINE_ID — sequencing when tests are attached to operations.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–30 — the descriptive flexfield context and segments.
• DELETE_MARK — logical deletion flag; active records carry 0.

Common Use Cases and Queries

Typical usage includes generating specification reports, feeding results into Statistical Process Control, or validating that a received lot falls within tolerances. A representative query listing active tests with their limits and the "below spec max" flag follows:

• Specification lookup:

SELECT TEST_CODE, TEST_DESC, MIN_VALUE_NUM, MAX_VALUE_NUM,
BELOW_SPEC_MAX, ABOVE_SPEC_MAX
FROM APPS.GMD_QC_TESTS_VL
WHERE DELETE_MARK = 0
ORDER BY TEST_CODE;

• Tests with a "below spec max" tolerance defined:

SELECT TEST_CODE, TEST_DESC, MAX_VALUE_NUM, BELOW_SPEC_MAX
FROM APPS.GMD_QC_TESTS_VL
WHERE BELOW_SPEC_MAX IS NOT NULL
AND DELETE_MARK = 0;

• Out-of-specification action lookup:

SELECT TEST_CODE, BELOW_MIN_ACTION_CODE, ABOVE_MAX_ACTION_CODE
FROM APPS.GMD_QC_TESTS_VL
WHERE TEST_ID = :p_test_id;

Because the view already applies the USERENV('LANG') predicate, callers should not add a LANGUAGE filter. All queries must be issued with APPS-scoped synonyms or fully qualified as APPS.GMD_QC_TESTS_VL, and consumers should apply DELETE_MARK = 0 to avoid reporting obsolete test definitions.