APPS.GMD_QUALITY_GRP dependencies on GMD_COMPOSITE_SPEC_DISP

Line 297: FROM gmd_composite_results rst, gmd_composite_spec_disp csd

293: Cursor get_composite_results(vComposite_spec_disp_id NUMBER) IS
294: SELECT rst.mean, rst.mode_char, rst.high_num, rst.low_num,
295: rst.high_char, rst.low_char, rst.composite_result_id,
296: rst.test_id
297: FROM gmd_composite_results rst, gmd_composite_spec_disp csd
298: WHERE rst.test_id = p_inv_rslt_inp_rec.test_id
299: AND rst.delete_mark = 0
300: AND rst.composite_spec_disp_id = csd.composite_spec_disp_id
301: AND csd.composite_spec_disp_id = vComposite_spec_disp_id

Line 306: FROM gmd_composite_spec_disp

302: AND csd.latest_ind ='Y';
303:
304: Cursor get_composite_disp(vEvent_spec_disp_id NUMBER) IS
305: SELECT composite_spec_disp_id
306: FROM gmd_composite_spec_disp
307: WHERE event_spec_disp_id = vEvent_spec_disp_id
308: -- B3698232 Added disposition 'Complete' for the composite sample
309: -- AND disposition IN ('4A','5AV');
310: AND disposition IN ('3C', '4A','5AV');