Line 1362: FROM GMD_QC_TESTS a, gem_lookups b , gmd_test_methods c
1358: c.test_qty,
1359: c.test_qty_uom, --rconv
1360: 'N',
1361: 'Y' 1362: FROM GMD_QC_TESTS a, gem_lookups b , gmd_test_methods c 1363: where a.test_class = p_test_class
1364: AND b.lookup_type = 'GMD_QC_TEST_TYPE'
1365: AND a.test_type = b.lookup_code
1366: AND a.test_method_id = c.test_method_id