VIEW: APPS.PMITS_QC_TESTS_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)