VIEW: APPS.GMD_QC_E_TEST_INSTANCE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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