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_TESTS

Line 1114: FROM gmd_qc_tests_b t, gmd_spec_tests_b st

1110:
1111: -- Cursors
1112: CURSOR c_spec_test_val (p_spec_id NUMBER, p_test_id NUMBER) IS
1113: SELECT t.test_type, st.min_value_num, st.max_value_num, st.target_value_char
1114: FROM gmd_qc_tests_b t, gmd_spec_tests_b st
1115: WHERE t.test_id= st.test_id
1116: AND st.exclude_ind IS NULL
1117: AND st.spec_id = p_spec_id
1118: AND st.test_id = p_test_id

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 1479: FROM gmd_qc_tests_b

1475: l_resources := NULL;
1476:
1477: SELECT test_type
1478: INTO l_test_type
1479: FROM gmd_qc_tests_b
1480: WHERE test_id = p_test_ids(i)
1481: ;
1482:
1483: IF (l_debug = 'Y') THEN

Line 2073: l_test_id GMD_QC_TESTS.test_id%TYPE;

2069: AND spec_used_for_lot_attrib_ind = 'Y'
2070: ;
2071:
2072: --Begin Bug#5220513
2073: l_test_id GMD_QC_TESTS.test_id%TYPE;
2074: l_spec_id gmd_spec_tests_b.spec_id%TYPE;
2075:
2076: CURSOR c_evaluation_ind (p_result_id NUMBER, p_event_spec_disp_id NUMBER) IS
2077: SELECT evaluation_ind from gmd_spec_results gsr, gmd_event_spec_disp esd --, gmd_sample_spec_disp ssd

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 2856: X_display_precision gmd_qc_tests_b.display_precision%TYPE;

2852: AND s.test_id = l_test_id
2853: AND s.exclude_ind IS NULL;
2854:
2855: X_additional_test gmd_spec_results.additional_test_ind%TYPE;
2856: X_display_precision gmd_qc_tests_b.display_precision%TYPE;
2857: --END BUG#2871126.
2858:
2859: LocalNumRec c_get_spec_test_num%ROWTYPE;
2860:

Line 2876: l_qc_test gmd_qc_tests%rowtype;

2872: SELECT *
2873: FROM gmd_results
2874: WHERE sample_id = p_sample_id;
2875:
2876: l_qc_test gmd_qc_tests%rowtype;
2877: l_test_mthd gmd_test_methods%rowtype;
2878:
2879: l_in_qc_test gmd_qc_tests%rowtype;
2880: l_in_test_mthd gmd_test_methods%rowtype;

Line 2879: l_in_qc_test gmd_qc_tests%rowtype;

2875:
2876: l_qc_test gmd_qc_tests%rowtype;
2877: l_test_mthd gmd_test_methods%rowtype;
2878:
2879: l_in_qc_test gmd_qc_tests%rowtype;
2880: l_in_test_mthd gmd_test_methods%rowtype;
2881:
2882: l_ret_sts BOOLEAN;
2883:

Line 2912: l_ret_sts := gmd_qc_tests_pvt.fetch_row(p_gmd_qc_tests => l_in_qc_test,

2908: FOR c_result_rec IN C_get_results(p_sample_id) LOOP
2909: l_results_rec_tbl(i).test_id := c_result_rec.test_id;
2910:
2911: l_in_qc_test.test_id := c_result_rec.test_id;
2912: l_ret_sts := gmd_qc_tests_pvt.fetch_row(p_gmd_qc_tests => l_in_qc_test,
2913: x_gmd_qc_tests => l_qc_test);
2914: l_results_rec_tbl(i).test_code := l_qc_test.test_code;
2915: l_results_rec_tbl(i).test_type := l_qc_test.test_type;
2916: l_results_rec_tbl(i).unit := l_qc_test.test_unit;

Line 2913: x_gmd_qc_tests => l_qc_test);

2909: l_results_rec_tbl(i).test_id := c_result_rec.test_id;
2910:
2911: l_in_qc_test.test_id := c_result_rec.test_id;
2912: l_ret_sts := gmd_qc_tests_pvt.fetch_row(p_gmd_qc_tests => l_in_qc_test,
2913: x_gmd_qc_tests => l_qc_test);
2914: l_results_rec_tbl(i).test_code := l_qc_test.test_code;
2915: l_results_rec_tbl(i).test_type := l_qc_test.test_type;
2916: l_results_rec_tbl(i).unit := l_qc_test.test_unit;
2917:

Line 3025: FROM gmd_qc_tests_b

3021: IF X_additional_test = 'Y' THEN
3022:
3023: SELECT display_precision
3024: INTO X_display_precision
3025: FROM gmd_qc_tests_b
3026: WHERE test_id = l_test_id;
3027:
3028: l_results_rec_tbl(i).display_precision := X_display_precision;
3029:

Line 3656: --||' FROM gmd_results r, gmd_spec_results sr, gmd_qc_tests_b t'

3652: ||')'
3653: ;
3654:
3655: -- The code below is now removed/changed from the SQL Above
3656: --||' FROM gmd_results r, gmd_spec_results sr, gmd_qc_tests_b t'
3657: --||' AND r.test_id = t.test_id'
3658: --||' AND t.test_type <> ' || '''' || 'U' || ''''
3659:
3660: -- GO through all the sample_ids and populate _GTMP table

Line 3765: FROM gmd_qc_tests_b

3761: ;
3762:
3763: CURSOR c_test_type (p_test_id NUMBER) IS
3764: SELECT test_type, display_precision
3765: FROM gmd_qc_tests_b
3766: WHERE test_id = p_test_id
3767: ;
3768:
3769: CURSOR c_spec_test (p_spec_id NUMBER, p_test_id NUMBER) IS

Line 4156: FROM gmd_qc_tests_b

4152:
4153: -- Curosrs
4154: CURSOR c_test_type(p_test_id NUMBER) IS
4155: SELECT test_type
4156: FROM gmd_qc_tests_b
4157: WHERE test_id = p_test_id
4158: ;
4159:
4160: CURSOR c_mean(p_test_id NUMBER) IS

Line 4251: FROM gmd_qc_tests_b

4247:
4248: -- Curosrs
4249: CURSOR c_test_type(p_test_id NUMBER) IS
4250: SELECT test_type
4251: FROM gmd_qc_tests_b
4252: WHERE test_id = p_test_id
4253: ;
4254:
4255: CURSOR c_median(p_test_id NUMBER) IS

Line 4449: FROM gmd_qc_tests_b

4445:
4446:
4447: CURSOR c_test (p_test_id NUMBER) IS
4448: SELECT test_type
4449: FROM gmd_qc_tests_b
4450: WHERE test_id = p_test_id
4451: ;
4452:
4453: CURSOR c_num_to_text (p_test_id NUMBER, p_num NUMBER) IS

Line 4584: FROM gmd_qc_tests_b

4580: ;
4581:
4582: CURSOR c_test (p_test_id NUMBER) IS
4583: SELECT test_type
4584: FROM gmd_qc_tests_b
4585: WHERE test_id = p_test_id
4586: ;
4587:
4588: -- Local Variables

Line 4679: FROM gmd_qc_tests_b

4675: ;
4676:
4677: CURSOR c_test (p_test_id NUMBER) IS
4678: SELECT test_type
4679: FROM gmd_qc_tests_b
4680: WHERE test_id = p_test_id
4681: ;
4682:
4683: -- Local Variables

Line 4761: FROM gmd_qc_tests_b

4757:
4758: -- Curosrs
4759: CURSOR c_test_type(p_test_id NUMBER) IS
4760: SELECT test_type
4761: FROM gmd_qc_tests_b
4762: WHERE test_id = p_test_id
4763: ;
4764:
4765: CURSOR c_stddev(p_test_id NUMBER) IS

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:

Line 5792: gmd_qc_tests_b t

5788: t.report_precision, r.result_id, r.result_value_num
5789: FROM gmd_samples s,
5790: gmd_results r,
5791: gmd_spec_results sr,
5792: gmd_qc_tests_b t
5793: WHERE s.sample_id = r.sample_id
5794: AND s.sample_id = p_sample_id
5795: AND s.retain_as IS NULL
5796: AND r.result_id = sr.result_id

Line 5824: FROM gmd_qc_tests_b

5820: ;
5821:
5822: CURSOR c_qc_test_value(p_test_id NUMBER) IS
5823: SELECT min_value_num,max_value_num
5824: FROM gmd_qc_tests_b
5825: WHERE test_id = p_test_id
5826: ;
5827:
5828: l_additional_test_ind VARCHAR2(1);

Line 5841: gmd_qc_tests_b t,

5837: SELECT gtmp.data_num,
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

Line 7197: (p_exp_ref_test_id IN gmd_qc_tests_b.test_id%TYPE

7193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7194: END composite_and_change_lot;
7195:
7196: PROCEDURE update_exptest_value_null
7197: (p_exp_ref_test_id IN gmd_qc_tests_b.test_id%TYPE
7198: , p_sample_id IN gmd_samples.sample_id%TYPE
7199: , p_event_spec_disp_id IN gmd_sample_spec_disp.event_spec_disp_id%TYPE
7200: , x_return_status OUT NOCOPY VARCHAR2
7201: )

Line 7222: CURSOR get_exp_tests (l_exp_ref_test_id gmd_qc_tests_b.test_id%TYPE) IS

7218: l_return_status VARCHAR2(10);
7219: l_sts BOOLEAN;
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:

Line 7228: l_test_id gmd_qc_tests_b.test_id%TYPE,

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,
7229: l_event_spec_disp_id gmd_sample_spec_disp.event_spec_disp_id%TYPE)
7230: IS
7231: SELECT r.result_id
7232: FROM gmd_results r, gmd_spec_results sr