DBA Data[Home] [Help]

APPS.GMD_COA_DATA_OM_NEW dependencies on GMD_COMPOSITE_RESULTS

Line 439: from gmd_composite_results r,

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

Line 979: GMD_COMPOSITE_RESULTS gr, -- possble change here

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)