APPS.GMD_QMSED dependencies on MTL_PARAMETERS

Line 97: mtl_parameters mp

93: gmd_sampling_events c,gmd_all_spec_vrs_vl d ,
94: gmd_sampling_events gse,
95: gmd_event_spec_disp ges,
96: gmd_sample_spec_disp gss,
97: mtl_parameters mp
98: WHERE
99: A.sample_id=l_event_key AND
100: a.inventory_item_id=b.inventory_item_id AND
101: a.sampling_event_id=c.sampling_event_id AND

Line 127: mtl_parameters mp

123: gmd_specifications e,
124: gmd_sampling_events gse,
125: gmd_event_spec_disp ges,
126: gmd_sample_spec_disp gss,
127: mtl_parameters mp
128: WHERE
129: A.sample_id=l_event_key AND
130: a.inventory_item_id=b.inventory_item_id AND
131: a.sampling_event_id=c.sampling_event_id AND

Line 162: mtl_parameters mp

158: WHERE spec_used_for_lot_attrib_ind = 'Y'
159: AND ges.event_spec_disp_id = gss.event_spec_disp_id
160: AND ges.delete_mark = 0
161: AND gss.sample_id = l_event_key ) ges,
162: mtl_parameters mp
163: WHERE a.sample_id = l_event_key AND
164: a.inventory_item_id = b.inventory_item_id AND
165: ges.spec_id = e.spec_id AND
166: a.sampling_event_id = gse.sampling_event_id AND

Line 229: ,MTL_PARAMETERS F

225: ,GMD_COM_SPEC_VRS_VL B
226: ,MTL_SYSTEM_ITEMS_B_KFV C
227: ,GMD_SAMPLING_PLANS D
228: ,GMD_SPECIFICATIONS_B E
229: ,MTL_PARAMETERS F
230: WHERE a.original_spec_vr_id=b.SPEC_VR_ID AND
231: b.spec_id = e.spec_id AND
232: e.inventory_item_id=c.inventory_item_id AND
233: b.organization_id = f.organization_id(+) AND

Line 262: ,mtl_parameters f

258: from gmd_sampling_events a
259: ,gmd_com_spec_vrs_vl b
260: ,mtl_system_items_b_kfv c
261: ,gmd_specifications_b e
262: ,mtl_parameters f
263: where a.original_spec_vr_id = b.spec_vr_id and
264: b.spec_id = e.spec_id and
265: e.inventory_item_id = c.inventory_item_id and
266: e.owner_organization_id = c.organization_id and --RLNAGARA B5714223 Added this condition

Line 297: ,MTL_PARAMETERS F

293: ,GMD_COM_SPEC_VRS_VL B
294: ,MTL_SYSTEM_ITEMS_B_KFV C
295: ,GMD_SAMPLING_PLANS D
296: ,GMD_SPECIFICATIONS_B E
297: ,MTL_PARAMETERS F
298: WHERE a.original_spec_vr_id=b.SPEC_VR_ID AND
299: b.spec_id = e.spec_id AND
300: e.inventory_item_id=c.inventory_item_id AND
301: b.organization_id = f.organization_id(+) AND

Line 329: ,mtl_parameters f

325: from gmd_sampling_events a
326: ,gmd_com_spec_vrs_vl b
327: ,mtl_system_items_b_kfv c
328: ,gmd_specifications_b e
329: ,mtl_parameters f
330: where a.original_spec_vr_id = b.spec_vr_id and
331: b.spec_id = e.spec_id and
332: e.inventory_item_id = c.inventory_item_id and
333: e.owner_organization_id = c.organization_id and --RLNAGARA B5714223 Added this condition