eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_QC_TESTS_GRP dependencies on GMD_SPEC_TESTS

Line 81: SELECT 'Y' FROM GMD_SPEC_TESTS_B gst ,GMD_SPECIFICATIONS_B gs

77: p_init_msg_list IN VARCHAR2 ,
78: p_test_id IN NUMBER) RETURN BOOLEAN IS
79:
80: CURSOR cr_test_exist IS
81: SELECT 'Y' FROM GMD_SPEC_TESTS_B gst ,GMD_SPECIFICATIONS_B gs
82: WHERE gst.test_id = p_test_id
83: AND gst.spec_id = gs.spec_id
84: AND gs.delete_mark = 0 ;
85:

Line 1373: FROM gmd_spec_tests

1369: IF (p_spec_id IS NOT NULL) THEN
1370: UPDATE gmd_test_group_gt
1371: SET used_in_spec = 'Y', include = 'N'
1372: WHERE test_id IN (SELECT test_id
1373: FROM gmd_spec_tests
1374: WHERE spec_id = p_spec_id);
1375: ELSIF (p_sample_id IS NOT NULL) THEN
1376: OPEN c_get_spec_id(p_sample_id);
1377: FETCH c_get_spec_id INTO l_spec_id;

Line 1385: FROM gmd_spec_tests a,

1381: BEGIN
1382: SELECT nvl(a.test_qty_uom, c.test_qty_uom) test_qty_uom,
1383: nvl(a.test_qty, c.test_qty) test_qty
1384: INTO l_test_qty_uom, l_test_qty
1385: FROM gmd_spec_tests a,
1386: gmd_qc_tests b,
1387: gmd_test_methods_b c
1388: WHERE a.spec_id = l_spec_id
1389: AND a.test_id = b.test_id