Depends on the error but you have ..
and order_id = (Select * from #Order_id)
As this will return a list it should be
..
and order_id in (select order_id from #order_id)
This assumes the order_id is the name of the field in #order_id table you are filtering on..