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 1124: FROM gmd_qc_test_values_b

1120:
1121: -- When test type is T, get the NUM seq if only Char value is passed
1122: CURSOR c_text_to_num(p_test_id NUMBER, p_value_char VARCHAR2) IS
1123: SELECT text_range_seq
1124: FROM gmd_qc_test_values_b
1125: WHERE test_id = p_test_id
1126: AND value_char = p_value_char
1127: ;
1128:

Line 1132: FROM gmd_qc_test_values_b

1128:
1129: -- When test type is L, check that there exits a subranges that covers the result num
1130: CURSOR c_subranges(p_test_id NUMBER, p_num NUMBER) IS
1131: SELECT 1
1132: FROM gmd_qc_test_values_b
1133: WHERE test_id = p_test_id
1134: AND nvl(min_num, p_num) <= p_num
1135: AND nvl(max_num, p_num) >= p_num
1136: ;

Line 1850: FROM gmd_qc_test_values_b tv

1846:
1847: -- Cursors
1848: CURSOR c_ref_tests(p_sample_id NUMBER, p_test_id NUMBER) IS
1849: SELECT 1
1850: FROM gmd_qc_test_values_b tv
1851: WHERE tv.test_id = p_test_id
1852: AND tv.expression_ref_test_id NOT IN
1853: (SELECT test_id
1854: FROM gmd_results

Line 2100: FROM gmd_qc_test_values v

2096: LocalTypeRec c_get_type%ROWTYPE;
2097:
2098: CURSOR c_get_display IS
2099: SELECT v.display_label_numeric_range
2100: FROM gmd_qc_test_values v
2101: WHERE v.test_id = l_test_id;
2102:
2103: LocalDisRec c_get_display%ROWTYPE;
2104:

Line 2842: FROM gmd_qc_test_values v

2838: LocalTypeRec c_get_type%ROWTYPE;
2839:
2840: CURSOR c_get_display IS
2841: SELECT v.display_label_numeric_range
2842: FROM gmd_qc_test_values v
2843: WHERE v.test_id = l_test_id;
2844: LocalDisRec c_get_display%ROWTYPE;
2845:
2846: --BEGIN BUG#2871126 Rameshwar

Line 4303: FROM gmd_qc_test_values_b

4299: ;
4300:
4301: CURSOR c_num_to_text (p_test_id NUMBER, p_num NUMBER) IS
4302: SELECT value_char
4303: FROM gmd_qc_test_values_b
4304: WHERE test_id = p_test_id
4305: AND text_range_seq = p_num
4306: ;
4307:

Line 4455: FROM gmd_qc_test_values_b

4451: ;
4452:
4453: CURSOR c_num_to_text (p_test_id NUMBER, p_num NUMBER) IS
4454: SELECT value_char
4455: FROM gmd_qc_test_values_b
4456: WHERE test_id = p_test_id
4457: AND text_range_seq = p_num
4458: ;
4459:

Line 4614: FROM gmd_qc_test_values_b

4610: IF (l_test_type = 'T' AND x_high_num IS NOT NULL) THEN
4611: -- Convert Seq for text range back to Character
4612: SELECT value_char
4613: INTO x_high_char
4614: FROM gmd_qc_test_values_b
4615: WHERE test_id = p_test_id
4616: AND text_range_seq = x_high_num
4617: ;
4618: END IF;

Line 4709: FROM gmd_qc_test_values_b

4705: IF (l_test_type = 'T' AND x_low_num IS NOT NULL) THEN
4706: -- Convert Seq for text range back to Character
4707: SELECT value_char
4708: INTO x_low_char
4709: FROM gmd_qc_test_values_b
4710: WHERE test_id = p_test_id
4711: AND text_range_seq = x_low_num
4712: ;
4713: END IF;

Line 5524: p_result_rec.display_label := GMD_QC_TEST_VALUES_GRP.get_test_value_desc

5520: gmd_debug.put_line('Result is within test range. Rounded value = ' || L_num_result);
5521: END IF;
5522:
5523: IF p_result_rec.test_type = 'L' THEN
5524: p_result_rec.display_label := GMD_QC_TEST_VALUES_GRP.get_test_value_desc
5525: (p_test_id => p_result_rec.test_id,
5526: p_test_value_num => L_num_result
5527: );
5528: END IF; -- end if test is num range w/ display, get label

Line 5779: FROM gmd_qc_test_values_b

5775: ) IS
5776:
5777: CURSOR get_referenced_tests (p_exp_test_id NUMBER) IS
5778: SELECT expression_ref_test_id
5779: FROM gmd_qc_test_values_b
5780: where test_id = p_exp_test_id;
5781:
5782: -- Modified the following cursor to fetch all the test replicates
5783: -- whichever is not calculated the Result yet.

Line 5842: gmd_qc_test_values_b tv

5838: t.test_code
5839: FROM gmd_result_data_points_gt gtmp,
5840: gmd_results r,
5841: gmd_qc_tests_b t,
5842: gmd_qc_test_values_b tv
5843: WHERE gtmp.result_id = r.result_id
5844: AND r.test_id = t.test_id
5845: AND t.test_id = tv.expression_ref_test_id
5846: AND tv.test_id = p_exp_test_id

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

5916: IF l_return_status <> 'S' THEN
5917: -- Error message must be already logged
5918: RAISE FND_API.G_EXC_ERROR;
5919: END IF;
5920: select count(*) INTO l_ref_count from gmd_qc_test_values_b where test_id=l_exp_test.test_id; --Bug#5097709
5921: -- Now we have all the ref. tests for the current expression in l_exptab so
5922: -- fill-in result_values in l_exptab from _GT table
5923: FOR l_all_ref_test IN c_all_ref_test(l_exp_test.test_id)
5924: LOOP

Line 7224: FROM gmd_qc_test_values_b val

7220: l_start_date DATE := GMA_CORE_PKG.get_date_constant_d('SY$MIN_DATE');
7221:
7222: CURSOR get_exp_tests (l_exp_ref_test_id gmd_qc_tests_b.test_id%TYPE) IS
7223: SELECT DISTINCT test_id
7224: FROM gmd_qc_test_values_b val
7225: WHERE expression_ref_test_id = l_exp_ref_test_id ;
7226:
7227: CURSOR exp_tests_need_calc ( l_sample_id gmd_samples.sample_id%TYPE,
7228: l_test_id gmd_qc_tests_b.test_id%TYPE,