APPS.GMD_QMSMC dependencies on GME_BATCH_HEADER

Line 2305: -- Bug 4165704: 1. a.wip_subinventory taken out since it no longer exists in gme_batch_header

2301: FROM gmd_specifications_b
2302: WHERE spec_id = x_spec_id_in;
2303:
2304: /* This cursor works for both batch created and batchstep created event */
2305: -- Bug 4165704: 1. a.wip_subinventory taken out since it no longer exists in gme_batch_header
2306: -- 2. a.revision added
2307: CURSOR C1(x_batch_id varchar2, x_batch_step_id varchar2) is
2308: SELECT A.BATCH_NO,
2309: A.BATCH_ID,

Line 2332: FROM GME_BATCH_HEADER A,

2328: I.DESCRIPTION ITEM_DESC1,
2329: A.LAST_UPDATED_BY,
2330: nvl(f.wip_plan_qty, f.plan_qty) trans_qty, -- 13107927
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

Line 2380: FROM GME_BATCH_HEADER A,

2376: I.DESCRIPTION,
2377: A.LAST_UPDATED_BY,
2378: d.plan_step_qty trans_qty, -- 13107927
2379: d.step_qty_um um -- 13107927
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,