VIEW: APPS.GMD_QC_E_SAMPLES_USED_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'