DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on GMD_TEST_METHODS_B

Line 5025: gmd_test_methods_b mthd,

5021:
5022: Cursor Cur_find_max_dur IS
5023: SELECT qc.test_code, mthd.test_duration
5024: FROM gmd_qc_tests_vl qc,
5025: gmd_test_methods_b mthd,
5026: gmd_spec_tests_b spec
5027: WHERE qc.test_method_id = mthd.test_method_id
5028: AND qc.test_id = spec.test_id
5029: AND spec.spec_id = p_spec_id

Line 5031: FROM gmd_test_methods_b mthd2,

5027: WHERE qc.test_method_id = mthd.test_method_id
5028: AND qc.test_id = spec.test_id
5029: AND spec.spec_id = p_spec_id
5030: AND ( mthd.test_duration = (SELECT MAX(test_duration)
5031: FROM gmd_test_methods_b mthd2,
5032: gmd_spec_tests_b spec2
5033: WHERE spec2.TEST_METHOD_ID = mthd2.test_method_id
5034: AND spec2.spec_id = p_spec_id));
5035: