Deactivating a location
Due to the way we have loaded past sales history(one time conversion) and post go-live collections, we've ended up with 2 location ids in Location table for the same Customer Ship To location (only one location in t_ep_site).
Let me call them L1 (old-created during conversion) and L2 (new-created during collections from EBS).
We've figured out a solution to copy the series data from L2 to L1 and make sure that collection process posts data into L1. Now,we need to make sure to have L2 de-activated for all purposes (we donot want to delete it as of now,but only de-activate). That means any Item-L2 combination should not be visible on Demantra worksheet and when users enter over-rides at higher levels of L2, it should not proporation the values at L2 (because L2 needs to be deactivated).