Diagnosis
The change to the hierarcy of the tables forced an adjustment of thejoin conditions.

System Response
Some join conditions were converted from left-outer to inner join orfrom inner to left-outer join.
The remaining join conditions are now consistent.