SQL for creating organisation hierarchy in a tabular view
Hi,
Im looking for some help in creating a SQL Script that flattens the Organisation Hierarchy in Oracle EBS, the tables that store the information are HR_ALL_ORGANIZATION_UNITS & PER_ORG_STRUCTURE_ELEMENTS
Im trying to retrieve the organization and its subsequent levels from 1-12 within the hierarchy, i would tell the query which org to start with (top org)
Eg
OrgName, Org_Level1, Org_Level2, Org_Level3, Org_Level4, Org_Level5, Org_Level6 ..........
HR Vision PLC Corporate HR Pay & Benefits Payroll International Payroll
Currently the Org data is stored like...
Child_Org Parent_Org
Vision PLC <NULL>
Corporate Vision PLC