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_QUALITY_GRP dependencies on GMD_SPEC_TESTS_B

Line 251: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;

247: l_composite_spec_disp_id NUMBER;
248: i NUMBER := 0;
249: l_row_num NUMBER := 0;
250: l_test_type gmd_qc_tests_b.test_type%TYPE;
251: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;
252: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;
253: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;
254: l_max_value_char gmd_spec_tests_b.max_value_char%TYPE;
255: l_display_precision gmd_spec_tests_b.display_precision%TYPE;

Line 252: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;

248: i NUMBER := 0;
249: l_row_num NUMBER := 0;
250: l_test_type gmd_qc_tests_b.test_type%TYPE;
251: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;
252: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;
253: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;
254: l_max_value_char gmd_spec_tests_b.max_value_char%TYPE;
255: l_display_precision gmd_spec_tests_b.display_precision%TYPE;
256:

Line 253: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;

249: l_row_num NUMBER := 0;
250: l_test_type gmd_qc_tests_b.test_type%TYPE;
251: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;
252: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;
253: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;
254: l_max_value_char gmd_spec_tests_b.max_value_char%TYPE;
255: l_display_precision gmd_spec_tests_b.display_precision%TYPE;
256:
257: l_result_id gmd_results.result_id%TYPE;

Line 254: l_max_value_char gmd_spec_tests_b.max_value_char%TYPE;

250: l_test_type gmd_qc_tests_b.test_type%TYPE;
251: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;
252: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;
253: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;
254: l_max_value_char gmd_spec_tests_b.max_value_char%TYPE;
255: l_display_precision gmd_spec_tests_b.display_precision%TYPE;
256:
257: l_result_id gmd_results.result_id%TYPE;
258: l_result_value_num gmd_results.result_value_num%TYPE;

Line 255: l_display_precision gmd_spec_tests_b.display_precision%TYPE;

251: l_min_value_num gmd_spec_tests_b.min_value_num%TYPE;
252: l_max_value_num gmd_spec_tests_b.max_value_num%TYPE;
253: l_min_value_char gmd_spec_tests_b.min_value_char%TYPE;
254: l_max_value_char gmd_spec_tests_b.max_value_char%TYPE;
255: l_display_precision gmd_spec_tests_b.display_precision%TYPE;
256:
257: l_result_id gmd_results.result_id%TYPE;
258: l_result_value_num gmd_results.result_value_num%TYPE;
259: l_result_value_char gmd_results.result_value_char%TYPE;

Line 288: FROM gmd_spec_tests_b

284: Cursor get_spec_tests(vSpec_id NUMBER,
285: vTest_id NUMBER) IS
286: SELECT min_value_num, max_value_num,
287: min_value_char, max_value_char, display_precision
288: FROM gmd_spec_tests_b
289: WHERE spec_id = vSpec_id
290: AND test_id = vTest_id;
291:
292: -- Get composite results

Line 702: FROM gmd_spec_tests_b st, gmd_qc_tests_b qt

698: st.min_value_char, st.min_value_num ,
699: st.max_value_char, st.max_value_num ,
700: qt.test_type, st.spec_id,
701: NVL(st.display_precision, qt.display_precision) display_precision
702: FROM gmd_spec_tests_b st, gmd_qc_tests_b qt
703: WHERE st.spec_id = vSpec_id
704: AND st.test_id = vTest_id
705: AND st.test_id = qt.test_id;
706: