APPS.GMD_QMSED dependencies on GMD_SPECIFICATIONS_B

Line 152: gmd_specifications_b e,

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

Line 226: ,GMD_SPECIFICATIONS_B E

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

Line 259: ,gmd_specifications_b e

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

Line 294: ,GMD_SPECIFICATIONS_B E

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

Line 326: ,gmd_specifications_b e

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