When I run specific query Teiid translates it to query which does not use one of table aliases in whole query. Oracle seems to be sensitive to aliasing table and then not using it. See TEIID-4988