Need SQL to get Email Addresses for all Managers in Supervisor Hierarchy — Cloud Customer Connect
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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Need SQL to get Email Addresses for all Managers in Supervisor Hierarchy

edited Nov 18, 2019 3:17PM in Reporting and Analytics for HCM 3 comments

Summary

SQL to get Email Addresses for all Managers in Supervisor Hierarchy

Content

Hi Experts

I am looking for a query which can get me a list of all supervisor's email addresses for a person's supervisor hierarchy.

Here is an example of what i am looking for 

Person John has 5 supervisors - the result i am looking for is

sup1@gmail.com, sup2@gmail.com, sup3@gmail.com,sup4@gmail.com, sup5@gmail.com

We are on 19c. 

 

Please let me know if you have any questions on the same. thanks!

Mansur 

 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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