APPS.GMD_COA_DATA_OM_NEW dependencies on GMD_SAMPLING_EVENTS

Line 774: from gmd_sampling_events

770: CURSOR c_sampling_event(p_spec_id IN NUMBER) IS
771: select nvl(a.SAMPLE_ACTIVE_CNT,0) sample_active_cnt,
772: b.event_spec_disp_id,
773: b.sampling_event_id
774: from gmd_sampling_events
775: a,gmd_event_spec_disp b
776: where b.spec_id =p_spec_id
777: and (a.lot_number = p_lot_number or p_lot_number is null)
778: and b.disposition in ('4A','5AV','5RJ')

Line 887: FROM GMD_SAMPLING_EVENTS gs ,

883: gr.sample_id sample_id,ges.event_spec_disp_id,
884: gr.test_id,
885: gr.result_value_num,
886: gr.result_value_char,'SAMPLE'
887: FROM GMD_SAMPLING_EVENTS gs ,
888: GMD_EVENT_SPEC_DISP ges,
889: GMD_RESULTS gr,
890: GMD_SPEC_RESULTS sp
891: WHERE

Line 912: FROM GMD_SAMPLING_EVENTS gs ,

908: null sample_id,ges.event_spec_disp_id,
909: gr.test_id,
910: gr.mean result_value_num,
911: gr.mode_char result_value_char,'EVENT_SPEC_DISP'
912: FROM GMD_SAMPLING_EVENTS gs ,
913: GMD_EVENT_SPEC_DISP sd,
914: GMD_COMPOSITE_RESULTS gr,
915: GMD_COMPOSITE_SPEC_DISP ges
916: WHERE