You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Received Response
13
Views
1
Comments

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!