Manager Hierarchy starting with CEO
We are looking to get the manager hierarchy with CEO as level 1 of the organization. The Flattened Hierarchy table (PER_MANAGER_HRCHY_DN) has data with manager levels, however manager level 1 is the immediate line manager, and the CEO is the last level in the chain which is in reverse to what we were looking for. Is there a different way to get to the manager hierarchy with CEO at Level 1?
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):