Diagnosis
Changing the hierarchy of the tables forced the join conditions to
be adjusted.

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