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_RESULTS_GRP dependencies on GMD_TEST_METHODS_B

Line 152: FROM gmd_spec_tests_b st, gmd_test_methods_b tm

148: , tm.resources, st.viability_duration
149: , st.test_qty
150: , st.test_qty_uom
151: , tm.test_method_id
152: FROM gmd_spec_tests_b st, gmd_test_methods_b tm
153: WHERE st.spec_id = p_spec_id
154: AND st.exclude_ind IS NULL
155: AND ((p_lot_retest_ind IS NULL) OR
156: (st.retest_lot_expiry_ind = p_lot_retest_ind)

Line 1338: FROM gmd_qc_tests_b t, gmd_test_methods_b tm

1334: tm.test_replicate,
1335: tm.test_method_id, -- 5353794
1336: tm.test_qty,
1337: tm.test_qty_uom
1338: FROM gmd_qc_tests_b t, gmd_test_methods_b tm
1339: WHERE t.test_id = p_test_id
1340: AND t.test_method_id = tm.test_method_id
1341: ;
1342:

Line 1369: l_resources GMD_TEST_METHODS_B.RESOURCES%TYPE;

1365: dummy PLS_INTEGER;
1366: out_var_idx PLS_INTEGER := 0;
1367: l_meaning VARCHAR2(80);
1368: l_viability_duration NUMBER;
1369: l_resources GMD_TEST_METHODS_B.RESOURCES%TYPE;
1370:
1371: l_sample GMD_SAMPLES%ROWTYPE;
1372: l_sampling_event GMD_SAMPLING_EVENTS%ROWTYPE;
1373: l_results GMD_RESULTS%ROWTYPE;

Line 1567: FROM gmd_spec_tests_b st, gmd_test_methods_b tm

1563: IF (l_additional_test_ind IS NULL) THEN
1564: -- Test is part of the Spec so get the replicate from spec.
1565: SELECT st.test_replicate, st.viability_duration, tm.resources
1566: INTO l_replicate,l_viability_duration, l_resources
1567: FROM gmd_spec_tests_b st, gmd_test_methods_b tm
1568: WHERE st.spec_id = l_event_spec_disp.spec_id
1569: AND st.exclude_ind IS NULL
1570: AND st.test_id = p_test_ids(i)
1571: AND st.test_method_id = tm.test_method_id

Line 2051: FROM gmd_spec_tests_b st, gmd_test_methods_b tm

2047: CURSOR c_spec_tests (p_spec_id NUMBER) IS
2048: SELECT st.test_id
2049: , st.test_replicate
2050: , tm.test_kit_inv_item_id
2051: FROM gmd_spec_tests_b st, gmd_test_methods_b tm
2052: WHERE st.spec_id = p_spec_id
2053: AND st.exclude_ind IS NULL
2054: AND st.test_method_id = tm.test_method_id
2055: ;

Line 2092: FROM gmd_qc_tests_b t , gmd_test_methods_b m

2088:
2089: CURSOR c_get_type IS
2090: SELECT t.test_type, t.test_code, t.test_method_id, t.expression, t.test_unit,
2091: m.test_method_code
2092: FROM gmd_qc_tests_b t , gmd_test_methods_b m
2093: WHERE t.test_id = l_test_id
2094: AND t.test_method_id = m.test_method_id;
2095:
2096: LocalTypeRec c_get_type%ROWTYPE;

Line 2835: FROM gmd_qc_tests_b t , gmd_test_methods_b m

2831:
2832: CURSOR c_get_type IS
2833: SELECT t.test_type, t.test_code, t.test_method_id, t.expression, t.test_unit,
2834: m.test_method_code
2835: FROM gmd_qc_tests_b t , gmd_test_methods_b m
2836: WHERE t.test_id = l_test_id
2837: AND t.test_method_id = m.test_method_id;
2838: LocalTypeRec c_get_type%ROWTYPE;
2839:

Line 4878: FROM gmd_qc_tests_b t , gmd_test_methods_b m

4874: LocalComResRec c_get_composite_results%ROWTYPE;
4875:
4876: CURSOR c_get_type IS
4877: SELECT t.test_type, t.test_code, t.test_method_id, m.test_method_code
4878: FROM gmd_qc_tests_b t , gmd_test_methods_b m
4879: WHERE t.test_id = l_test_id
4880: AND t.test_method_id = m.test_method_id;
4881: LocalTypeRec c_get_type%ROWTYPE;
4882: