Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
---|---|
Description: | This View Provides QC Test deifnitions |
Implementation/DBA Data: | APPS.PMITS_QC_TESTS_V |
SELECT QC_TESTS.TEST_ID
, QC_TESTS.TEST_CODE
, QC_TESTS.TEST_DESC
, QC_TESTS.TEST_METHOD_ID
, QC_TESTS.TEST_OPRN_LINE_ID
, QC_TESTS.TEST_PROVIDER_CODE
, QC_TESTS.TEST_CLASS
, TEST_CLS.TEST_CLASS_DESC
, QC_TESTS.TEST_TYPE
, QC_TESTS.TEST_UNIT
, QC_TESTS.MIN_VALUE_NUM
, QC_TESTS.MAX_VALUE_NUM
, QC_TESTS.EXP_ERROR_TYPE
, QC_TESTS.BELOW_SPEC_MIN
, QC_TESTS.ABOVE_SPEC_MIN
, QC_TESTS.BELOW_SPEC_MAX
, QC_TESTS.ABOVE_SPEC_MAX
, QC_TESTS.BELOW_MIN_ACTION_CODE
, QC_TESTS.ABOVE_MIN_ACTION_CODE
, QC_TESTS.BELOW_MAX_ACTION_CODE
, QC_TESTS.ABOVE_MAX_ACTION_CODE
, QC_TESTS.EXPRESSION
, QC_TESTS.DISPLAY_PRECISION
, QC_TESTS.REPORT_PRECISION
, QC_TESTS.PRIORITY
, QC_TESTS.TEST_OPRN_ID
, TEST_VALS.MIN_NUM
, TEST_VALS.MAX_NUM
, TEST_VALS.DISPLAY_LABEL_NUMERIC_RANGE
, TEST_VALS.TEST_VALUE_DESC
, TEST_VALS.VALUE_CHAR
, TEST_VALS.TEXT_RANGE_SEQ
, TEST_VALS.EXPRESSION_REF_TEST_ID FROM GMD_QC_TESTS_VL QC_TESTS
, GMD_QC_TEST_VALUES_VL TEST_VALS
, GMD_TEST_CLASSES_VL TEST_CLS
WHERE QC_TESTS.TEST_ID = TEST_VALS.TEST_ID(+)
AND QC_TESTS.TEST_CLASS = TEST_CLS.TEST_CLASS(+)