APPS.GMD_COA_DATA_OM_NEW dependencies on GMD_EVENT_SPEC_DISP

Line 366: gmd_event_spec_disp ges

362: r.result_date,
363: r.text_code
364: from gmd_results r,
365: gmd_spec_results sr,
366: gmd_event_spec_disp ges
367: where r.sample_id = p_sample_id
368: and r.result_id = sr.result_id
369: and nvl(sr.evaluation_ind,'N') in ('0A','1V','2R','N') -- srakrish bug 5747932: To fetch results for non validated tests.
370: and sr.event_spec_disp_id = ges.event_spec_disp_id

Line 441: gmd_event_spec_disp ges

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
444: and sd.event_spec_disp_id = ges.event_spec_disp_id
445: and nvl(ges.spec_used_for_lot_attrib_ind,'N') = 'Y'

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 951: GMD_EVENT_SPEC_DISP ges,

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
955: gs.inventory_item_id = l_inventory_item_id

Line 978: GMD_EVENT_SPEC_DISP sd,

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
982: gs.inventory_item_id = l_inventory_item_id

Line 1232: gmd_event_spec_disp b,

1228:
1229: CURSOR c_samples IS
1230: select a.organization_id, c.organization_code, a.sample_no
1231: from gmd_samples a,
1232: gmd_event_spec_disp b,
1233: mtl_parameters c
1234: where a.sampling_event_id = b.sampling_event_id
1235: and b.event_spec_disp_id = p_event_spec_disp_id
1236: and a.organization_id = c.organization_id;