Hi Senthil,
That is well-known table functions(kokbf$-) limitations: they block such
transformations. You can google about it, there are few standard
solutions(precompute_subquery hint, laterals, etc...), but the best one is
to avoid table functions in such complex queries.
On Thu, May 16, 2019 at 6:44 PM Senthil Subramanian <skumar.sen@xxxxxxxxx>
wrote:
--
from table(cast(multiset(select level from dual
