VIEW: APPS.GMD_QC_E_SAMPLE_RESULTS_V

Source

View Text - Preformatted

SELECT smpls.sample_id sample_id, smpls.sample_no sample_no ,smpls.sample_desc sample_desc, rslt.update_instance_id, rslt.result_id ,rslt.test_id ,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 ,gqts.test_unit, rslt.result_date, fuser.user_name ,orgs.organization_code, rslt.test_replicate_cnt FROM gmd_results rslt ,gmd_samples smpls ,gmd_qc_tests_b gqts ,fnd_user fuser ,mtl_parameters orgs WHERE rslt.sample_id = smpls.sample_id AND rslt.test_id = gqts.test_id AND fuser.user_id(+) = rslt.tester_id AND orgs.organization_id = smpls.organization_id

View Text - HTML Formatted

SELECT SMPLS.SAMPLE_ID SAMPLE_ID
, SMPLS.SAMPLE_NO SAMPLE_NO
, SMPLS.SAMPLE_DESC SAMPLE_DESC
, RSLT.UPDATE_INSTANCE_ID
, RSLT.RESULT_ID
, RSLT.TEST_ID
, 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
, GQTS.TEST_UNIT
, RSLT.RESULT_DATE
, FUSER.USER_NAME
, ORGS.ORGANIZATION_CODE
, RSLT.TEST_REPLICATE_CNT
FROM GMD_RESULTS RSLT
, GMD_SAMPLES SMPLS
, GMD_QC_TESTS_B GQTS
, FND_USER FUSER
, MTL_PARAMETERS ORGS
WHERE RSLT.SAMPLE_ID = SMPLS.SAMPLE_ID
AND RSLT.TEST_ID = GQTS.TEST_ID
AND FUSER.USER_ID(+) = RSLT.TESTER_ID
AND ORGS.ORGANIZATION_ID = SMPLS.ORGANIZATION_ID