1149: mr.alternate_routing_designator
1150: into var_alternate_routing
1151: from msc_supplies ms,
1152: msc_process_effectivity mpe, 1153: msc_routings mr 1154: where
1155: ms.plan_id = var_plan_id -- Plan_id
1156: and ms.order_type = 5 -- Order type for planned order
1157: and ms.plan_id = mpe.plan_id