435: r.high_num,
436: r.range,
437: r.non_validated_result,
438: r.standard_deviation , ges.spec_id
439: from gmd_composite_results r,
440: gmd_composite_spec_disp sd,
441: gmd_event_spec_disp ges
442: where r.composite_spec_disp_id =sd.composite_spec_disp_id
443: and sd.event_spec_disp_id = p_event_spec_disp_id
975: gr.mean result_value_num,
976: gr.mode_char result_value_char,'EVENT_SPEC_DISP'
977: FROM GMD_SAMPLING_EVENTS gs ,
978: GMD_EVENT_SPEC_DISP sd,
979: GMD_COMPOSITE_RESULTS gr, -- possble change here
980: GMD_COMPOSITE_SPEC_DISP ges
981: WHERE
982: gs.inventory_item_id = l_inventory_item_id
983: AND (gs.revision = l_revision OR gs.revision IS NULL)