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.