View: GMD_QC_E_SAMPLE_RESULTS_V

Product:	GMD - Process Manufacturing Product Development
Description:
Implementation/DBA Data:	APPS.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