How to synchronize the level Id's in MDP_MATRIX with Hierarchy changes to Items or Locations
Hi,
In MDP_MATRIX table we have De-normalized list of all the location hierarchy id's and Item Hierarchy ids for a particular item and location combination. We have a situation where there are some hierarchy changes (not levels but members re-alignment taking place). With this we are going to get the latest hierarchy data for items and locations (item and location at lowest level remains same, they are remapped to new levels). Now once we load it, the item hierarchy tables and location hierarchy tables are reflected with the changes, but the mdp_matrix is still pointing to old id's (id's that are