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_QC_TEST_VALUES

Line 1177: FROM gmd_qc_test_values_b

1173:
1174: -- When test type is T, get the NUM seq if only Char value is passed
1175: CURSOR c_text_to_num(p_test_id NUMBER, p_value_char VARCHAR2) IS
1176: SELECT text_range_seq
1177: FROM gmd_qc_test_values_b
1178: WHERE test_id = p_test_id
1179: AND value_char = p_value_char
1180: ;
1181:

Line 1185: FROM gmd_qc_test_values_b

1181:
1182: -- When test type is L, check that there exits a subranges that covers the result num
1183: CURSOR c_subranges(p_test_id NUMBER, p_num NUMBER) IS
1184: SELECT 1
1185: FROM gmd_qc_test_values_b
1186: WHERE test_id = p_test_id
1187: AND nvl(min_num, p_num) <= p_num
1188: AND nvl(max_num, p_num) >= p_num
1189: ;

Line 1932: FROM gmd_qc_test_values_b tv

1928:
1929: -- Cursors
1930: CURSOR c_ref_tests(p_sample_id NUMBER, p_test_id NUMBER) IS
1931: SELECT 1
1932: FROM gmd_qc_test_values_b tv
1933: WHERE tv.test_id = p_test_id
1934: AND tv.expression_ref_test_id NOT IN
1935: (SELECT test_id
1936: FROM gmd_results

Line 2187: FROM gmd_qc_test_values v

2183: LocalTypeRec c_get_type%ROWTYPE;
2184:
2185: CURSOR c_get_display IS
2186: SELECT v.display_label_numeric_range
2187: FROM gmd_qc_test_values v
2188: WHERE v.test_id = l_test_id;
2189:
2190: LocalDisRec c_get_display%ROWTYPE;
2191:

Line 3010: FROM gmd_qc_test_values v

3006: LocalTypeRec c_get_type%ROWTYPE;
3007:
3008: CURSOR c_get_display IS
3009: SELECT v.display_label_numeric_range
3010: FROM gmd_qc_test_values v
3011: WHERE v.test_id = l_test_id;
3012: LocalDisRec c_get_display%ROWTYPE;
3013:
3014: --BEGIN BUG#2871126 Rameshwar

Line 4472: FROM gmd_qc_test_values_b

4468: ;
4469:
4470: CURSOR c_num_to_text (p_test_id NUMBER, p_num NUMBER) IS
4471: SELECT value_char
4472: FROM gmd_qc_test_values_b
4473: WHERE test_id = p_test_id
4474: AND text_range_seq = p_num
4475: ;
4476:

Line 4624: FROM gmd_qc_test_values_b

4620: ;
4621:
4622: CURSOR c_num_to_text (p_test_id NUMBER, p_num NUMBER) IS
4623: SELECT value_char
4624: FROM gmd_qc_test_values_b
4625: WHERE test_id = p_test_id
4626: AND text_range_seq = p_num
4627: ;
4628:

Line 4783: FROM gmd_qc_test_values_b

4779: IF (l_test_type = 'T' AND x_high_num IS NOT NULL) THEN
4780: -- Convert Seq for text range back to Character
4781: SELECT value_char
4782: INTO x_high_char
4783: FROM gmd_qc_test_values_b
4784: WHERE test_id = p_test_id
4785: AND text_range_seq = x_high_num
4786: ;
4787: END IF;

Line 4878: FROM gmd_qc_test_values_b

4874: IF (l_test_type = 'T' AND x_low_num IS NOT NULL) THEN
4875: -- Convert Seq for text range back to Character
4876: SELECT value_char
4877: INTO x_low_char
4878: FROM gmd_qc_test_values_b
4879: WHERE test_id = p_test_id
4880: AND text_range_seq = x_low_num
4881: ;
4882: END IF;

Line 5695: p_result_rec.display_label := GMD_QC_TEST_VALUES_GRP.get_test_value_desc

5691: gmd_debug.put_line('Result is within test range. Rounded value = ' || L_num_result);
5692: END IF;
5693:
5694: IF p_result_rec.test_type = 'L' THEN
5695: p_result_rec.display_label := GMD_QC_TEST_VALUES_GRP.get_test_value_desc
5696: (p_test_id => p_result_rec.test_id,
5697: p_test_value_num => L_num_result
5698: );
5699: END IF; -- end if test is num range w/ display, get label

Line 5979: FROM gmd_qc_test_values_b

5975: l_test_results TEST_RESULTS;
5976: --QZENG Bug 6774613 End
5977: CURSOR get_referenced_tests (p_exp_test_id NUMBER) IS
5978: SELECT expression_ref_test_id
5979: FROM gmd_qc_test_values_b
5980: where test_id = p_exp_test_id;
5981:
5982: -- Modified the following cursor to fetch all the test replicates
5983: -- whichever is not calculated the Result yet.

Line 6045: gmd_qc_test_values_b tv

6041: t.test_code
6042: FROM gmd_result_data_points_gt gtmp,
6043: gmd_results r,
6044: gmd_qc_tests_b t,
6045: gmd_qc_test_values_b tv
6046: WHERE gtmp.result_id = r.result_id
6047: AND r.test_id = t.test_id
6048: AND t.test_id = tv.expression_ref_test_id
6049: AND tv.test_id = p_exp_test_id

Line 6151: select count(*) INTO l_ref_count from gmd_qc_test_values_b where test_id=l_exp_test.test_id; --Bug#5097709

6147: IF l_return_status <> 'S' THEN
6148: -- Error message must be already logged
6149: RAISE FND_API.G_EXC_ERROR;
6150: END IF;
6151: select count(*) INTO l_ref_count from gmd_qc_test_values_b where test_id=l_exp_test.test_id; --Bug#5097709
6152: -- Now we have all the ref. tests for the current expression in l_exptab so
6153: -- fill-in result_values in l_exptab from _GT table
6154: FOR l_all_ref_test IN c_all_ref_test(l_exp_test.test_id)
6155: LOOP

Line 7601: FROM gmd_qc_test_values_b val

7597: l_start_date DATE := GMA_CORE_PKG.get_date_constant_d('SY$MIN_DATE');
7598:
7599: CURSOR get_exp_tests (l_exp_ref_test_id gmd_qc_tests_b.test_id%TYPE) IS
7600: SELECT DISTINCT test_id
7601: FROM gmd_qc_test_values_b val
7602: WHERE expression_ref_test_id = l_exp_ref_test_id ;
7603:
7604: CURSOR exp_tests_need_calc ( l_sample_id gmd_samples.sample_id%TYPE,
7605: l_test_id gmd_qc_tests_b.test_id%TYPE,