Related to TEIID-5016 and TEIID-3652, there are additional circumstances where the join planning logic can combine tables from different parts of a join tree involving left outer joins.

The referenced forum posting has a star join against ora_ses such that moving the placement of the nested inner join allows for more grouping of the join tables.