Hell All
I am trying to make tree table using single Read OnlyViewObject.
The viewObject query is this.
select papf.employee_number,paaf.person_id personId,
paaf.supervisor_assignment_id suprtvisor_id
,papf.full_name, papf.per_information3||' '||papf.per_information4||' '||papf.per_information5||' '||papf.per_information6 full_name_english
from per_all_people_f papf, per_all_assignments_f paaf
where papf.person_id = paaf.person_id
and papf.current_employee_flag = 'Y'
and paaf.primary_flag = 'Y'
--and papf.employee_number =:emp_number
and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date
and trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date

Person id of one employee is the supervisor id for another employee.
My aim is this: The Logged in user can see all employees works under him/her and also can see all employees works under those employee whose loged in user is supervisor.
For eg: - User1
|\_> User2
|\_>User3
|\_>User4
|\_>User5
Please help me in this
Thanks in Advance.