[Home] [Help]
View: GMD_QC_E_SAMPLE_RESULTS_V
View Text
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
Columns
Name |
SAMPLE_ID |
SAMPLE_NO |
SAMPLE_DESC |
UPDATE_INSTANCE_ID |
RESULT_ID |
TEST_ID |
TEST_RESULT |
TEST_UNIT |
RESULT_DATE |
USER_NAME |
ORGANIZATION_CODE |
TEST_REPLICATE_CNT |