358: we.wip_entity_name wip_entity
359: FROM cst_pac_explosion_temp cpet,
360: mtl_material_transactions mmt1,
361: mtl_material_transactions mmt2,
362: mtl_system_items_kfv msik1,
363: mtl_system_items_kfv msik2,
364: wip_entities we
365: WHERE cpet.pac_period_id = c_pac_period_id
366: AND cpet.cost_group_id = c_cost_group_id
359: FROM cst_pac_explosion_temp cpet,
360: mtl_material_transactions mmt1,
361: mtl_material_transactions mmt2,
362: mtl_system_items_kfv msik1,
363: mtl_system_items_kfv msik2,
364: wip_entities we
365: WHERE cpet.pac_period_id = c_pac_period_id
366: AND cpet.cost_group_id = c_cost_group_id
367: AND cpet.deleted = 'N'