Search Results test_priority_desc

Overview

APPS.GMD_QC_E_COMPOSITE_RESULTS_V is a reporting view in the Oracle E-Business Suite Process Manufacturing (OPM) Quality module, owned by the APPS schema and registered under FND Design Data as GMD.GMD_QC_E_COMPOSITE_RESULTS_V. Its status is VALID and its view type is documented as Internal, carrying the standard Oracle notification that the object is intended for use by Oracle Applications programs rather than direct customer access.

The view consolidates composite quality test results — that is, results derived from aggregating multiple sample measurements for a specification test — together with the associated specification disposition, statistical summary values, and test definition attributes. Because quality results are stored across normalized tables (composite results, specification dispositions, event dispositions, test definitions, and lookup-driven displays), the view denormalizes these into a single flattened result set suitable for reporting, concurrent program output, and downstream integration. The presence of both an internal composite result identifier and human-readable descriptive columns (test code, test description, method description, priority and type descriptions) makes the view a convenient single source for quality result extraction without requiring joins across the underlying model.

Underlying Base Objects

The documented referenced base objects are: FND_LOOKUP_VALUES_VL (VIEW), GMD_COMPOSITE_RESULTS (SYNONYM), GMD_COMPOSITE_SPEC_DISP (SYNONYM), GMD_EVENT_SPEC_DISP (SYNONYM), GMD_QC_TESTS (SYNONYM), GMD_QC_TEST_VALUES_GRP (PACKAGE), GMD_SPEC_TESTS (SYNONYM), and GMD_TEST_METHODS (SYNONYM).

• GMD_COMPOSITE_RESULTS supplies the aggregate statistical values per composite result, including mean, mode, low/high values, range, standard deviation, and sample counts.
• GMD_COMPOSITE_SPEC_DISP and GMD_EVENT_SPEC_DISP drive the disposition and expression columns, including the composite specification disposition identifier and the event specification disposition identifier.
• GMD_SPEC_TESTS and GMD_QC_TESTS provide test definition data — test code, description, unit, class, priority, and specification limits (minimum, target, maximum) and their meanings.
• GMD_TEST_METHODS contributes method code and method description.
• FND_LOOKUP_VALUES_VL resolves looked-up display values used for disposition and indicator text.
• GMD_QC_TEST_VALUES_GRP is the PL/SQL package associated with the test value grouping logic that underpins composite aggregation.

Key Columns

The view exposes identifiers, statistical aggregates, and descriptive attributes. Notable columns include:

• COMPOSITE_RESULT_ID, TEST_ID, EVENT_SPEC_DISP_ID, COMPOSITE_SPEC_DISP_ID — primary join keys back to the underlying quality model.
• MODE_VALUE, MEDIAN_VALUE, MEAN, LOW_VALUE, HIGH_VALUE, RANGE, STANDARD_DEVIATION — statistical summary of the composite sample set. MODE_VALUE (VARCHAR2(80)) returns the most frequently occurring value as text, since quality results may be character-formatted.
• SAMPLE_TOTAL, SAMPLE_CNT_USED — total samples versus those actually included in the aggregate.
• DISPOSITION, EXPRESSION, LATEST_IND, IN_SPEC_IND_DISP, NON_VALIDATED_RESULT — dispositional and validity indicators, with LATEST_IND flagging the most recent version.
• TEST_CODE, TEST_DESC, TEST_UNIT, TEST_CLASS, TEST_TYPE_DESC, TEST_PRIORITY_DESC, TEST_METHOD_CODE, TEST_METHOD_DESC — descriptive test metadata.
• SPEC_MIN_VALUE, SPEC_TARGET_VALUE, SPEC_MAX_VALUE — specification limits, with the corresponding SPEC_*_MEANING columns for textual interpretation.
• VALUE_IN_REPORT_PRECISION — the reported value rounded to reporting precision.

Common Use Cases and Queries

Typical uses include quality result reporting, certificate-of-analysis generation, and integration extracts that must surface composite statistics alongside specification limits. A representative query filtering on a test code and restricting to the latest revision follows:

• SELECT composite_result_id, test_code, test_desc, mean, mode_value, median_value, standard_deviation, low_value, high_value, in_spec_ind_disp FROM apps.gmd_qc_e_composite_results_v WHERE test_code = :p_test_code AND latest_ind = 'Y';
• SELECT test_code, test_desc, spec_min_value, spec_target_value, spec_max_value, sample_total, sample_cnt_used FROM apps.gmd_qc_e_composite_results_v WHERE composite_result_id = :p_composite_result_id;
• SELECT disposition, expression, value_in_report_precision, in_spec_ind_disp FROM apps.gmd_qc_e_composite_results_v WHERE composite_spec_disp_id = :p_disp_id;

Given its Internal classification, access from custom code should be undertaken with the understanding that the view is not formally supported for external use and its definition may change between releases.