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

Query to Display the employee and the supervisor chain bottom up

Received Response
12
Views
5
Comments

Summary:

Does someone have a query for the employment and Supervisor/Manager hierarchy ?

Content (required):

Hello , I have very little experience in HCM tables, hence I was wondering if you can share with me any SQL that have BU, LE, employee and supervisor/manager hierarchy.

I was trying to generated the report through OTBI-Workforce Management- Person Real Time, but it does not have all the information requiered.

Thanks for your help

I have only this SQL

select

ppx.person_number,

ppnf.full_name,

asg.assignment_number asg_num,

asg.assignment_type asg_type,

term.assignment_number term_num,

term.assignment_type term_type

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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