View: GMD_QC_E_SAMPLES_USED_V

Product:	GMD - Process Manufacturing Product Development
Description:
Implementation/DBA Data:	APPS.GMD_QC_E_SAMPLES_USED_V

View Text

SELECT GCRA.COMPOSITE_RESULT_ID
, RSLT.RESULT_ID
, SMPLS.SAMPLE_NO SAMPLE_NO
, SMPLS.SAMPLE_ID SAMPLE_ID
, SMPLS.SAMPLE_DESC SAMPLE_DESC
, DECODE (GQTS.TEST_TYPE
, 'T'
, RSLT.RESULT_VALUE_CHAR
, 'E'
, RSLT.RESULT_VALUE_NUM
, 'N'
, RSLT.RESULT_VALUE_NUM
, 'L'
, RSLT.RESULT_VALUE_NUM
, RSLT.RESULT_VALUE_CHAR ) TEST_RESULT
, DECODE (EXCLUDE_IND
, 'Y'
, FLY.MEANING
, FLN.MEANING) EXCLUDE_IND
, GQTS.TEST_UNIT
FROM GMD_COMPOSITE_RESULT_ASSOC GCRA
, GMD_RESULTS RSLT
, GMD_SAMPLES SMPLS
, GMD_QC_TESTS GQTS
, FND_LOOKUP_VALUES_VL FLY
, FND_LOOKUP_VALUES_VL FLN
WHERE GCRA.RESULT_ID = RSLT.RESULT_ID
AND RSLT.SAMPLE_ID = SMPLS.SAMPLE_ID
AND RSLT.TEST_ID = GQTS.TEST_ID
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'

Columns