Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Cant able to create TeeTable structure by using single ViewObject

2888183Mar 12 2015 — edited Mar 21 2015

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

Resultset.PNG

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.

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 18 2015
Added on Mar 12 2015
1 comment
832 views