oracle case statement in where clause multiple values

how to order from walmart warehouse