# Oracle EBS SQL Query that will list all employees in the hr.per_all_assignments_f
# table and their supervisor, in readable format.
SELECT DISTINCT papf1.full_name leve1_full_name
, papf1.employee_number level1_empno
, papf2.full_name leve2_full_name
, papf2.employee_number level2_empno
FROM hr.per_all_people_f papf1
, hr.per_all_assignments_f paaf1
, hr.per_all_assignments_f paaf2
, hr.per_all_people_f papf2
WHERE papf1.person_id = paaf1.person_id
AND paaf1.supervisor_id = papf2.person_id(+)
AND papf2.person_id = paaf2.person_id
ORDER BY leve1_full_name;
# table and their supervisor, in readable format.
SELECT DISTINCT papf1.full_name leve1_full_name
, papf1.employee_number level1_empno
, papf2.full_name leve2_full_name
, papf2.employee_number level2_empno
FROM hr.per_all_people_f papf1
, hr.per_all_assignments_f paaf1
, hr.per_all_assignments_f paaf2
, hr.per_all_people_f papf2
WHERE papf1.person_id = paaf1.person_id
AND paaf1.supervisor_id = papf2.person_id(+)
AND papf2.person_id = paaf2.person_id
ORDER BY leve1_full_name;
It's really a great and helpful piece of info. I'm glad that you just shared this useful information with us. Please keep us up to date like this. Thank you for sharing.Here is the right place to Submit Guest Post Big Data.
ReplyDelete