APPS.GMD_RESULT_TRANSFER_GRP dependencies on GMD_EVENT_SPEC_DISP

Line 96: gmd_event_spec_disp esd

92: r.test_method_id
93: FROM gmd_results r,
94: gmd_spec_results sr,
95: gmd_sample_spec_disp ssd,
96: gmd_event_spec_disp esd
97: WHERE r.sample_id = p_parent_sample_id
98: AND r.test_id = p_test_id
99: AND r.test_method_id = p_test_method_id
100: AND r.result_id = sr.result_id

Line 125: gmd_event_spec_disp ges

121: r.standard_deviation , ges.spec_id,
122: r.creation_date
123: from gmd_composite_results r,
124: gmd_composite_spec_disp sd,
125: gmd_event_spec_disp ges
126: where r.composite_spec_disp_id =sd.composite_spec_disp_id
127: --and sd.event_spec_disp_id = 1
128: and sd.event_spec_disp_id = ges.event_spec_disp_id
129: and nvl(ges.spec_used_for_lot_attrib_ind,'N') = 'Y'

Line 135: gmd_event_spec_disp ges

131: and ges.sampling_event_id = p_parent_id
132: and r.test_id in (select r1.test_id
133: from gmd_composite_results r1,
134: gmd_composite_spec_disp gcs,
135: gmd_event_spec_disp ges
136: where ges.event_spec_disp_id = gcs.event_spec_disp_id
137: and gcs.latest_ind = 'Y'
138: and gcs.composite_spec_disp_id = r1.composite_spec_disp_id
139: and ges.sampling_event_id = p_child_id

Line 147: gmd_event_spec_disp ges

143: p_test_id IN NUMBER) IS
144: select r1.composite_result_id
145: from gmd_composite_results r1,
146: gmd_composite_spec_disp gcs,
147: gmd_event_spec_disp ges
148: where ges.event_spec_disp_id = gcs.event_spec_disp_id
149: and gcs.latest_ind = 'Y'
150: and gcs.composite_spec_disp_id = r1.composite_spec_disp_id
151: and ges.sampling_event_id = p_sampling_event_id

Line 511: FROM gmd_event_spec_disp

507: SELECT spec_id,
508: event_spec_disp_id
509: INTO l_spec_id,
510: l_event_spec_disp_id
511: FROM gmd_event_spec_disp
512: WHERE sampling_event_id = p_sampling_event_id
513: AND spec_used_for_lot_attrib_ind = 'Y';
514: l_place := 1;
515: