Query to Display the employee and the supervisor chain bottom up

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