APPS.GMD_QMSED dependencies on GMD_SPECIFICATIONS_B

Line 154: gmd_specifications_b e,

150: L_SPEC_VERS, L_GRADE_CODE, L_ORGN_CODE
151: FROM
152: gmd_samples a,
153: mtl_system_items_kfv b,
154: gmd_specifications_b e,
155: gmd_sampling_events gse,
156: (SELECT ges.sampling_event_id , ges.disposition ,ges.spec_vr_id,ges.spec_id
157: FROM gmd_event_spec_disp ges, gmd_sample_spec_disp gss
158: WHERE spec_used_for_lot_attrib_ind = 'Y'

Line 228: ,GMD_SPECIFICATIONS_B E

224: FROM GMD_SAMPLING_EVENTS A
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

Line 261: ,gmd_specifications_b e

257: l_sample_source,l_specification,l_item_revision,l_orgn_code
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

Line 296: ,GMD_SPECIFICATIONS_B E

292: FROM GMD_SAMPLING_EVENTS A
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

Line 328: ,gmd_specifications_b e

324: l_item_revision,l_orgn_code
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