SQL for Organizational hierarchy

[chicha]

Hi,

I'm new to JDE and wondering if anyone has any SQL/script to generate organization hierarchy.

Thanks!

 

[Zoltan_Gyimesi]

Hi chicha,
Your issue is a bit cloudy for me.
What kind of hierarchy are you interested in?
Company Master, Bussines Unit Master and Accont Master tables can be your friend.
At last, but not least WHY SQL Script.
Regards,
Zoltán