SQL-How I get all the children/parent of account in GL ?

Summary:

SQL-How I get all the children/parent of account in GL ?

Content (please ensure you mask any confidential information):

Hello

I am looking for a custom report to get all the GL Hierarchy Parent / Child . I already ran the custom report "Enterprise Structure Report" however it does not have all the children information.

I tried several SQL's but none of them provided all the Children and I already ran the SQL that Oracle Suggested in MOS but I does not have all the children as well.

Thanks for your help

SELECT Decode(pos, 9, value,

                  8, NULL,

                  7, NULL,

                  6, NULL,

                  5, NULL,

                  4, NULL,