View: GMD_QC_E_TEST_INSTANCE_V

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

View Text

SELECT DISTINCT RSLT.TEST_ID
, UPDATE_INSTANCE_ID
, TEST_CODE
, TEST_DESC
, TEST_CLASS
, TEST_TYPES.MEANING TEST_TYPE
, EXPRESSION
, TESTMETHODS.TEST_METHOD_CODE
FROM GMD_RESULTS RSLT
, GMD_QC_TESTS TEST
, FND_LOOKUP_VALUES_VL TEST_TYPES
, GMD_TEST_METHODS_B TESTMETHODS
WHERE RSLT.TEST_ID = TEST.TEST_ID
AND TEST_TYPES.LOOKUP_TYPE = 'GMD_QC_TEST_TYPE'
AND TEST.TEST_TYPE = TEST_TYPES.LOOKUP_CODE
AND RSLT.TEST_METHOD_ID = TESTMETHODS. TEST_METHOD_ID ORDER BY RSLT.TEST_ID

Columns