APPS.GMF_VIB dependencies on GME_BATCH_STEP_ITEMS

Line 452: FROM gme_material_details m, gme_batch_step_items s

448: CURSOR c_batch_products (c_batch_id NUMBER) IS
449: SELECT m.material_detail_id, m.inventory_item_id as item_id, m.organization_id,
450: decode(m.plan_qty, 0, nvl(m.wip_plan_qty,0), m.plan_qty) prod_plan_qty,
451: m.cost_alloc, s.batchstep_id
452: FROM gme_material_details m, gme_batch_step_items s
453: WHERE m.batch_id = c_batch_id AND
454: m.line_type = 1 AND
455: m.material_detail_id = s.material_detail_id and
456: decode(m.plan_qty, 0, m.wip_plan_qty, m.plan_qty) <> 0 and

Line 601: FROM gme_batch_step_items s,

597: NULL,
598: gmf_vib_id_s.nextval,
599: p.organization_id,
600: l_vib_profile_value
601: FROM gme_batch_step_items s,
602: gme_material_details m
603: WHERE batchstep_id = ds.dep_step_id AND
604: s.material_detail_id = m.material_detail_id AND
605: m.line_type <> 1;