Search Results in_spec_ind_disp




Overview
Explore in AI Chat

Overview

GMD_QC_E_COMPOSITE_RESULTS_V is an APPS-owned database view within the Process Manufacturing Product Development (GMD) module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It exposes consolidated quality control composite results that have been evaluated against composite specifications, joining event-level disposition data to composite specification dispositions, test definitions, and computed statistical results.

The view is commonly surfaced when users search for gmd_spec_tests, because GMD_SPEC_TESTS is one of the underlying spec-test definition objects referenced in its definition. The view presents a denormalized, reporting-friendly image of each composite test result: the characteristic being measured, its statistical summary, its specification limits, and the disposition outcome. Because it flattens the relationships among event specifications, composite specifications, and composite results, it serves as a convenient source for quality results reporting, OPM quality workbench extensions, and integration extracts.

Underlying Base Objects

The documented base objects referenced by the view are:

Key Columns

  • EVENT_SPEC_DISP_ID / COMPOSITE_SPEC_DISP_ID — disposition identifiers linking the result to event and composite specification dispositions.
  • TEST_ID, TEST_CODE, TEST_DESC, TEST_UNIT, TEST_CLASS — identity and classification of the quality test.
  • MEAN, RANGE, STANDARD_DEVIATION, SAMPLE_TOTAL, SAMPLE_CNT_USED — statistical summary of the composite sample set.
  • MODE_VALUE, LOW_VALUE, HIGH_VALUE, MEDIAN_VALUE — DECODE-derived columns that resolve to character or numeric variants based on GQTS.TEST_TYPE ('T' for text; 'E', 'N', 'L' for numeric).
  • SPEC_MIN_VALUE, SPEC_TARGET_VALUE, SPEC_MAX_VALUE — specification limits, similarly DECODE-selected by test type.
  • SPEC_MIN_MEANING, SPEC_TARGET_MEANING — descriptive meanings returned by GMD_QC_TEST_VALUES_GRP.GET_TEST_VALUE_DESC.
  • IN_SPEC_IND_DISP — display form of the in-specification indicator ('Y' resolves to the yes meaning, otherwise the no meaning).
  • TEST_TYPE_DESC, TEST_PRIORITY_DESC, TEST_METHOD_CODE, TEST_METHOD_DESC — descriptive attributes joined from lookups and method master.

Common Use Cases and Queries

Typical usage includes composite quality reporting, specification conformance analysis, and integration extracts for LIMS or quality dashboards.

List latest composite results with their specification limits:

  • SELECT COMPOSITE_RESULT_ID, TEST_CODE, MEAN, SPEC_MIN_VALUE, SPEC_TARGET_VALUE, SPEC_MAX_VALUE, IN_SPEC_IND_DISP FROM GMD_QC_E_COMPOSITE_RESULTS_V WHERE LATEST_IND = 'Y';

Filter for out-of-specification results:

  • SELECT EVENT_SPEC_DISP_ID, TEST_DESC, MEAN, SPEC_MIN_VALUE, SPEC_MAX_VALUE FROM GMD_QC_E_COMPOSITE_RESULTS_V WHERE IN_SPEC_IND_DISP = 'No';

Report by test class:

  • SELECT TEST_CLASS, COUNT(*), AVG(MEAN) FROM GMD_QC_E_COMPOSITE_RESULTS_V GROUP BY TEST_CLASS;