APPS.GMD_COA_DATA_OM_NEW dependencies on GMD_SPEC_TESTS

Line 469: FROM gmd_spec_tests s,

465: s.target_value_num, s.min_value_num, s.max_value_num,
466: s.target_value_char, s.min_value_char, s.max_value_char,
467: s.text_code spec_text_code,t.test_code,t.test_id,t.test_unit,
468: decode(m.test_method_code,'DEFAULT',NULL, m.test_method_code) test_method_code
469: FROM gmd_spec_tests s,
470: gmd_qc_tests t,
471: gmd_test_methods_b m
472: --Bug 3785184 backing out fix 3588346
473: -- gmd_results r, --BUG#3588346

Line 877: FROM GMD_SPEC_TESTS_B gst

873: --RLNAGARA Bug # 4916856
874: --Bug# 5223677. Pick all tests. Commented optional_ind condition.
875: CURSOR cr_get_req_spec_tests IS
876: SELECT gst.test_id
877: FROM GMD_SPEC_TESTS_B gst
878: WHERE gst.spec_id = p_spec_id;
879: -- AND gst.optional_ind is NULL ;
880:
881: CURSOR cr_get_sample_for_lot IS