APPS.GMF_VIB dependencies on GME_BATCH_STEP_ITEMS

Line 453: FROM gme_material_details m, gme_batch_step_items s

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

Line 610: FROM gme_batch_step_items s,

606: NULL,
607: gmf_vib_id_s.nextval,
608: p.organization_id,
609: l_vib_profile_value
610: FROM gme_batch_step_items s,
611: gme_material_details m
612: WHERE batchstep_id = ds.dep_step_id AND
613: s.material_detail_id = m.material_detail_id AND
614: m.line_type <> 1;