eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_QMSED dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 226: ,MTL_SYSTEM_ITEMS_B_KFV C

222: INTO L_ITEM_NO,L_ITEM_DESC,L_LOT_NO,
223: L_SAMPLE_SOURCE,L_SPECIFICATION,L_SAMPLE_PLAN,l_item_revision,l_orgn_code
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

Line 260: ,mtl_system_items_b_kfv c

256: INTO l_item_no,l_item_desc,l_lot_no,l_lpn_id,
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

Line 294: ,MTL_SYSTEM_ITEMS_B_KFV C

290: d.SAMPLING_PLAN_NAME||' / '||d.SAMPLING_PLAN_DESC ,e.revision,f.organization_code
291: INTO L_ITEM_NO,L_ITEM_DESC,L_LOT_NO,L_SAMPLE_SOURCE,L_SPECIFICATION,L_SAMPLE_PLAN ,l_item_revision,l_orgn_code
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

Line 327: ,mtl_system_items_b_kfv c

323: INTO l_item_no,l_item_desc,l_lot_no,l_lpn_id,l_sample_source,l_specification,
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