APPS.GMD_COA_DATA_OM_NEW dependencies on GMD_SAMPLING_EVENTS

Line 824: from gmd_samples a,gmd_event_spec_disp b, gmd_sampling_events c

820:
821: select nvl(c.SAMPLE_ACTIVE_CNT,0) sample_active_cnt,
822: b.event_spec_disp_id,
823: b.sampling_event_id
824: from gmd_samples a,gmd_event_spec_disp b, gmd_sampling_events c
825: where b.spec_id =p_spec_id
826: and (((a.lot_number = p_lot_number or p_lot_number is null)
827: and (a.parent_lot_number = p_parent_lot_number or p_parent_lot_number is null) ) -- 9655426 added
828: or (a.parent_lot_number = p_parent_lot_number and a.lot_number is null) ) -- 9655426 added latest

Line 950: FROM GMD_SAMPLING_EVENTS gs ,

946: gr.sample_id sample_id,ges.event_spec_disp_id,
947: gr.test_id,
948: gr.result_value_num,
949: gr.result_value_char,'SAMPLE'
950: FROM GMD_SAMPLING_EVENTS gs ,
951: GMD_EVENT_SPEC_DISP ges,
952: GMD_RESULTS gr,
953: GMD_SPEC_RESULTS sp
954: WHERE

Line 977: FROM GMD_SAMPLING_EVENTS gs ,

973: null sample_id,ges.event_spec_disp_id,
974: gr.test_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