Also try using the query rewrite hint to see if you can prod it into rewriting.