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_QMSMC dependencies on GME_MATERIAL_DETAILS

Line 2335: GME_MATERIAL_DETAILS F,

2331: f.dtl_um um -- 13107927
2332: FROM GME_BATCH_HEADER A,
2333: GMD_RECIPE_VALIDITY_RULES b,
2334: GMD_RECIPES_B C, --GMD_RECIPES C performance bug# 4916912
2335: GME_MATERIAL_DETAILS F,
2336: FM_FORM_MST_B H, --FM_FORM_MST H performance bug# 4916912
2337: MTL_PARAMETERS P,
2338: --QZENG Bug 13881118 Change view from mtl_system_items_b_kfv to mtl_system_items_vl to support NLS
2339: --MTL_SYSTEM_ITEMS_B_KFV I

Line 2384: GME_MATERIAL_DETAILS F,

2380: FROM GME_BATCH_HEADER A,
2381: GMD_RECIPE_VALIDITY_RULES b,
2382: GMD_RECIPES_B C, --GMD_RECIPES C performance bug# 4916912
2383: GME_BATCH_STEPS D,
2384: GME_MATERIAL_DETAILS F,
2385: FM_FORM_MST_B H, --FM_FORM_MST H performance bug# 4916912
2386: MTL_PARAMETERS P,
2387: --QZENG Bug 13881118 Change view from mtl_system_items_b_kfv to mtl_system_items_vl to support NLS
2388: --MTL_SYSTEM_ITEMS_B_KFV I

Line 2438: from mtl_lot_numbers mln, gme_material_details d, GME_PENDING_PRODUCT_LOTS ppl

2434: -- old cursor was bringing back too many rows and was not using org id and item id in query so the wrong lot information was being returned
2435:
2436: CURSOR Cur_pending_lot(x_material_detail_id number) is
2437: select mln.lot_number, mln.parent_lot_number
2438: from mtl_lot_numbers mln, gme_material_details d, GME_PENDING_PRODUCT_LOTS ppl
2439: where mln.lot_number = ppl.lot_number
2440: and ppl.material_detail_id = x_material_detail_id
2441: and ppl.material_detail_id = d.material_detail_id
2442: and d.organization_id = mln.organization_id