APPS.GMD_QMSED dependencies on MTL_PARAMETERS

Line 95: mtl_parameters mp

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

Line 125: mtl_parameters mp

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

Line 160: mtl_parameters mp

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

Line 227: ,MTL_PARAMETERS F

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

Line 260: ,mtl_parameters f

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

Line 295: ,MTL_PARAMETERS F

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

Line 327: ,mtl_parameters f

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