Product: | GMD - Process Manufacturing Product Development |
---|---|
Description: | |
Implementation/DBA Data: | APPS.GMD_QC_E_SPEC_TESTS_V |
SELECT GSTS.SPEC_ID
, GSTS.TEST_ID
, GSTS.TEST_METHOD_ID
, GSTS.SEQ
, GTMS.TEST_METHOD_CODE
, GSTS.TEST_REPLICATE
, GSTS.TEST_QTY
, GSTS.TEST_QTY_UOM
, DECODE (GQTS.TEST_TYPE
, 'T'
, GSTS.MIN_VALUE_CHAR
, 'E'
, GSTS.MIN_VALUE_NUM
, 'N'
, GSTS.MIN_VALUE_NUM
, 'L'
, GSTS.MIN_VALUE_NUM
, NULL ) SPEC_MIN_VALUE
, DECODE (GQTS.TEST_TYPE
, 'T'
, GSTS.TARGET_VALUE_CHAR
, 'E'
, GSTS.TARGET_VALUE_NUM
, 'N'
, GSTS.TARGET_VALUE_NUM
, 'L'
, GSTS.TARGET_VALUE_NUM
, GSTS.TARGET_VALUE_CHAR ) SPEC_TARGET_VALUE
, DECODE (GQTS.TEST_TYPE
, 'T'
, GSTS.MAX_VALUE_CHAR
, 'E'
, GSTS.MAX_VALUE_NUM
, 'N'
, GSTS.MAX_VALUE_NUM
, 'L'
, GSTS.MAX_VALUE_NUM
, NULL ) SPEC_MAX_VALUE
, GSTS.MIN_VALUE_NUM
, GSTS.TARGET_VALUE_NUM
, GSTS.MAX_VALUE_NUM
, GSTS.MIN_VALUE_CHAR
, GSTS.TARGET_VALUE_CHAR
, GSTS.MAX_VALUE_CHAR
, GSTS.BELOW_SPEC_MIN
, GSTS.ABOVE_SPEC_MIN
, GSTS.BELOW_SPEC_MAX
, GSTS.ABOVE_SPEC_MAX
, GSTS.BELOW_MIN_ACTION_CODE
, GSTS.ABOVE_MIN_ACTION_CODE
, GSTS.BELOW_MAX_ACTION_CODE
, GSTS.ABOVE_MAX_ACTION_CODE
, DECODE (GSTS.OPTIONAL_IND
, 'Y'
, FLY.MEANING
, FLN.MEANING ) OPTIONAL_IND
, GSTS.DISPLAY_PRECISION
, GSTS.REPORT_PRECISION
, GSTS.OUT_OF_SPEC_ACTION
, TEST_PRIORITY.MEANING TEST_PRIORITY
, DECODE (GSTS.RETEST_LOT_EXPIRY_IND
, 'Y'
, FLY.MEANING
, FLN.MEANING ) RETEST_LOT_EXPIRY_IND
, EXP_ERROR_TYPE.MEANING EXP_ERROR_TYPE
, DECODE (GSTS.PRINT_SPEC_IND
, 'Y'
, FLY.MEANING
, FLN.MEANING ) PRINT_SPEC_IND
, DECODE (GSTS.PRINT_RESULT_IND
, 'Y'
, FLY.MEANING
, FLN.MEANING ) PRINT_RESULT_IND
, GSTS.TEST_DISPLAY
, GSTS.TEXT_CODE
, GAS.DESCRIPTION OUT_OF_SPEC_ACTION_DESC
, 0 OUT_OF_SPEC_ACTION_INTERVAL
, GQTS.EXPRESSION
, GQTS.TEST_CODE
, GQTS.TEST_DESC
, GQTS.TEST_UNIT
, GQTS.TEST_TYPE
, TEST_TYPES.MEANING TEST_TYPE_DESC
, GQTS.TEST_CLASS
, GQTS.MIN_VALUE_NUM TEST_MIN_VALUE
, GQTS.MAX_VALUE_NUM TEST_MAX_VALUE
, GMD_QC_TEST_VALUES_GRP.GET_TEST_VALUE_DESC (GSTS.TEST_ID
, GSTS.TARGET_VALUE_NUM
, GSTS.TARGET_VALUE_CHAR ) SPEC_TARGET_MEANING
, GMD_QC_TEST_VALUES_GRP.GET_TEST_VALUE_DESC (GSTS.TEST_ID
, GSTS.MIN_VALUE_NUM
, GSTS.MIN_VALUE_CHAR ) SPEC_MIN_MEANING
, GMD_QC_TEST_VALUES_GRP.GET_TEST_VALUE_DESC (GSTS.TEST_ID
, GSTS.MAX_VALUE_NUM
, GSTS.MAX_VALUE_CHAR ) SPEC_MAX_MEANING
, GMD_QC_TEST_VALUES_GRP.GET_TEST_VALUE_DESC (GSTS.TEST_ID
, GQTS.MIN_VALUE_NUM
, NULL ) TEST_MIN_MEANING
, GMD_QC_TEST_VALUES_GRP.GET_TEST_VALUE_DESC (GSTS.TEST_ID
, GQTS.MAX_VALUE_NUM
, NULL ) TEST_MAX_MEANING
, GSTS.FROM_BASE_IND
, GSTS.EXCLUDE_IND
, GSTS.MODIFIED_IND
, GSTS.CALC_UOM_CONV_IND
, GSTS.TO_QTY_UOM
FROM GMD_SPEC_TESTS GSTS
, GMD_QC_TESTS GQTS
, GMD_TEST_METHODS GTMS
, MTL_ACTIONS GAS
, FND_LOOKUP_VALUES_VL FLY
, FND_LOOKUP_VALUES_VL FLN
, FND_LOOKUP_VALUES_VL TEST_TYPES
, FND_LOOKUP_VALUES_VL EXP_ERROR_TYPE
, FND_LOOKUP_VALUES_VL TEST_PRIORITY
WHERE GSTS.TEST_ID = GQTS.TEST_ID
AND GSTS.TEST_METHOD_ID = GTMS.TEST_METHOD_ID
AND GSTS.OUT_OF_SPEC_ACTION = GAS.ACTION_CODE(+)
AND FLY.LOOKUP_TYPE = 'GMD_QC_YES_NO'
AND FLY.LOOKUP_CODE = 'Y'
AND FLN.LOOKUP_TYPE = 'GMD_QC_YES_NO'
AND FLN.LOOKUP_CODE = 'N'
AND TEST_TYPES.LOOKUP_TYPE = 'GMD_QC_TEST_TYPE'
AND GQTS.TEST_TYPE = TEST_TYPES.LOOKUP_CODE
AND TEST_PRIORITY.LOOKUP_TYPE = 'GMD_QC_TEST_PRIORITY'
AND GSTS.TEST_PRIORITY = TEST_PRIORITY.LOOKUP_CODE
AND EXP_ERROR_TYPE.LOOKUP_TYPE(+) = 'GMD_QC_EXP_ERROR_TYPE'
AND EXP_ERROR_TYPE.LOOKUP_CODE(+) = GSTS.EXP_ERROR_TYPE