When I run query like  Teiid translates it to query which does not use one of table aliases in whole query. Oracle (11g 188.8.131.52.0) seems to be sensitive to aliasing table and then not using it. Query fails. Source specific query (problematic one) .
Sample query which fails if running directly against Oracle database