AnsweredAssumed Answered

Need a help in finding parent and direct & indirect child projects

Question asked by ArunAngusamy on Jul 24, 2015
Latest reply on Jul 24, 2015 by Dave_3.0

I am trying to find a parent and all the child projects which are attached directly and indirectly to the program. I tried using INV_FLAT_HIERARCHIES but it is not providing the accurate results. When I use the INV_FLAT_HIERARCHIES, it displays the child project though it is deleted from the application. Can anyone help me to suggest alternate way to achieve this one ? Need a ORACLE SQL.

Outcomes