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_B

Line 1167: FROM gmd_qc_tests_b t, gmd_spec_tests_b st

1163:
1164: -- Cursors
1165: CURSOR c_spec_test_val (p_spec_id NUMBER, p_test_id NUMBER) IS
1166: SELECT t.test_type, st.min_value_num, st.max_value_num, st.target_value_char
1167: FROM gmd_qc_tests_b t, gmd_spec_tests_b st
1168: WHERE t.test_id= st.test_id
1169: AND st.exclude_ind IS NULL
1170: AND st.spec_id = p_spec_id
1171: AND st.test_id = p_test_id

Line 1413: FROM gmd_qc_tests_b t, gmd_test_methods_b tm

1409: tm.test_method_id, -- 5353794
1410: tm.test_qty,
1411: tm.test_qty_uom,
1412: tm.test_duration -- Bug 13476354
1413: FROM gmd_qc_tests_b t, gmd_test_methods_b tm
1414: WHERE t.test_id = p_test_id
1415: AND t.test_method_id = tm.test_method_id
1416: ;
1417:

Line 1555: FROM gmd_qc_tests_b

1551: l_resources := NULL;
1552:
1553: SELECT test_type
1554: INTO l_test_type
1555: FROM gmd_qc_tests_b
1556: WHERE test_id = p_test_ids(i)
1557: ;
1558:
1559: IF (l_debug = 'Y') THEN

Line 2179: FROM gmd_qc_tests_b t , gmd_test_methods_b m

2175:
2176: CURSOR c_get_type IS
2177: SELECT t.test_type, t.test_code, t.test_method_id, t.expression, t.test_unit,
2178: m.test_method_code
2179: FROM gmd_qc_tests_b t , gmd_test_methods_b m
2180: WHERE t.test_id = l_test_id
2181: AND t.test_method_id = m.test_method_id;
2182:
2183: LocalTypeRec c_get_type%ROWTYPE;

Line 3003: FROM gmd_qc_tests_b t , gmd_test_methods_b m

2999:
3000: CURSOR c_get_type IS
3001: SELECT t.test_type, t.test_code, t.test_method_id, t.expression, t.test_unit,
3002: m.test_method_code
3003: FROM gmd_qc_tests_b t , gmd_test_methods_b m
3004: WHERE t.test_id = l_test_id
3005: AND t.test_method_id = m.test_method_id;
3006: LocalTypeRec c_get_type%ROWTYPE;
3007:

Line 3024: X_display_precision gmd_qc_tests_b.display_precision%TYPE;

3020: AND s.test_id = l_test_id
3021: AND s.exclude_ind IS NULL;
3022:
3023: X_additional_test gmd_spec_results.additional_test_ind%TYPE;
3024: X_display_precision gmd_qc_tests_b.display_precision%TYPE;
3025: --END BUG#2871126.
3026:
3027: LocalNumRec c_get_spec_test_num%ROWTYPE;
3028:

Line 3193: FROM gmd_qc_tests_b

3189: IF X_additional_test = 'Y' THEN
3190:
3191: SELECT display_precision
3192: INTO X_display_precision
3193: FROM gmd_qc_tests_b
3194: WHERE test_id = l_test_id;
3195:
3196: l_results_rec_tbl(i).display_precision := X_display_precision;
3197:

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

3821: ||')'
3822: ;
3823:
3824: -- The code below is now removed/changed from the SQL Above
3825: --||' FROM gmd_results r, gmd_spec_results sr, gmd_qc_tests_b t'
3826: --||' AND r.test_id = t.test_id'
3827: --||' AND t.test_type <> ' || '''' || 'U' || ''''
3828:
3829: -- GO through all the sample_ids and populate _GTMP table

Line 3934: FROM gmd_qc_tests_b

3930: ;
3931:
3932: CURSOR c_test_type (p_test_id NUMBER) IS
3933: SELECT test_type, display_precision
3934: FROM gmd_qc_tests_b
3935: WHERE test_id = p_test_id
3936: ;
3937:
3938: CURSOR c_spec_test (p_spec_id NUMBER, p_test_id NUMBER) IS

Line 4325: FROM gmd_qc_tests_b

4321:
4322: -- Curosrs
4323: CURSOR c_test_type(p_test_id NUMBER) IS
4324: SELECT test_type
4325: FROM gmd_qc_tests_b
4326: WHERE test_id = p_test_id
4327: ;
4328:
4329: CURSOR c_mean(p_test_id NUMBER) IS

Line 4420: FROM gmd_qc_tests_b

4416:
4417: -- Curosrs
4418: CURSOR c_test_type(p_test_id NUMBER) IS
4419: SELECT test_type
4420: FROM gmd_qc_tests_b
4421: WHERE test_id = p_test_id
4422: ;
4423:
4424: CURSOR c_median(p_test_id NUMBER) IS

Line 4618: FROM gmd_qc_tests_b

4614:
4615:
4616: CURSOR c_test (p_test_id NUMBER) IS
4617: SELECT test_type
4618: FROM gmd_qc_tests_b
4619: WHERE test_id = p_test_id
4620: ;
4621:
4622: CURSOR c_num_to_text (p_test_id NUMBER, p_num NUMBER) IS

Line 4753: FROM gmd_qc_tests_b

4749: ;
4750:
4751: CURSOR c_test (p_test_id NUMBER) IS
4752: SELECT test_type
4753: FROM gmd_qc_tests_b
4754: WHERE test_id = p_test_id
4755: ;
4756:
4757: -- Local Variables

Line 4848: FROM gmd_qc_tests_b

4844: ;
4845:
4846: CURSOR c_test (p_test_id NUMBER) IS
4847: SELECT test_type
4848: FROM gmd_qc_tests_b
4849: WHERE test_id = p_test_id
4850: ;
4851:
4852: -- Local Variables

Line 4930: FROM gmd_qc_tests_b

4926:
4927: -- Curosrs
4928: CURSOR c_test_type(p_test_id NUMBER) IS
4929: SELECT test_type
4930: FROM gmd_qc_tests_b
4931: WHERE test_id = p_test_id
4932: ;
4933:
4934: CURSOR c_stddev(p_test_id NUMBER) IS

Line 5047: FROM gmd_qc_tests_b t , gmd_test_methods_b m

5043: LocalComResRec c_get_composite_results%ROWTYPE;
5044:
5045: CURSOR c_get_type IS
5046: SELECT t.test_type, t.test_code, t.test_method_id, m.test_method_code
5047: FROM gmd_qc_tests_b t , gmd_test_methods_b m
5048: WHERE t.test_id = l_test_id
5049: AND t.test_method_id = m.test_method_id;
5050: LocalTypeRec c_get_type%ROWTYPE;
5051:

Line 5992: gmd_qc_tests_b t

5988: t.report_precision, r.result_id, r.result_value_num , r.test_replicate_cnt -- 14021970 added r.test_replicate_cnt
5989: FROM gmd_samples s,
5990: gmd_results r,
5991: gmd_spec_results sr,
5992: gmd_qc_tests_b t
5993: WHERE s.sample_id = r.sample_id
5994: AND s.sample_id = p_sample_id
5995: AND s.retain_as IS NULL
5996: AND r.result_id = sr.result_id

Line 6027: FROM gmd_qc_tests_b

6023: ;
6024:
6025: CURSOR c_qc_test_value(p_test_id NUMBER) IS
6026: SELECT min_value_num,max_value_num
6027: FROM gmd_qc_tests_b
6028: WHERE test_id = p_test_id
6029: ;
6030:
6031: l_additional_test_ind VARCHAR2(1);

Line 6044: gmd_qc_tests_b t,

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

Line 7574: (p_exp_ref_test_id IN gmd_qc_tests_b.test_id%TYPE

7570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7571: END composite_and_change_lot;
7572:
7573: PROCEDURE update_exptest_value_null
7574: (p_exp_ref_test_id IN gmd_qc_tests_b.test_id%TYPE
7575: , p_sample_id IN gmd_samples.sample_id%TYPE
7576: , p_event_spec_disp_id IN gmd_sample_spec_disp.event_spec_disp_id%TYPE
7577: , x_return_status OUT NOCOPY VARCHAR2
7578: )

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

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

Line 7605: l_test_id gmd_qc_tests_b.test_id%TYPE,

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,
7606: l_event_spec_disp_id gmd_sample_spec_disp.event_spec_disp_id%TYPE)
7607: IS
7608: SELECT r.result_id
7609: FROM gmd_results r, gmd_spec_results sr

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

7688: ||')'
7689: ;
7690:
7691: -- The code below is now removed/changed from the SQL Above
7692: --||' FROM gmd_results r, gmd_spec_results sr, gmd_qc_tests_b t'
7693: --||' AND r.test_id = t.test_id'
7694: --||' AND t.test_type <> ' || '''' || 'U' || ''''
7695:
7696: -- GO through all the sample_ids and populate _GTMP table