Hi,
I am using JDev 11.1.1.7.0.
I have a requirement to design a tree which would look like: 
Is it possible with Single VO , or shall I use both the VO's of Employees and Departments tables.
I have already tried to replicate the same by creating a separate VO from existing entities, but my output is somewhat not as per my requirements.
Here in my tree, I have the Root Node (EmployeeId, Employee Name, Manager Id, Department Id) which in itself is all the managers in my table.
The First Child node(ManagerIdModifiedManagersofEmployees) is employees under the Managers in similar format.
Second Child Node is Department of the Root Node Employee.
My requirement is to get the Department of the Root Node as a Child_Node_1, followed by Department of the Child_Node Employee(If any) as described in my first image of this post.
For a clear understanding I will try to explain my requirement using the last Root Node in my tree. Last Root Node is of Lex (Employee Id - 102, Employee Name - Lex, Manager Id - 100, Department - 90). Lex himself works in department as"Executive", and in turn is Manager for Alexander (Employee Id - 103, Employee Name - Alexander, Manager Id - 102, Department - 60). Alexander works for "IT" department.
My requirement is to get a tree which displays Lex as root node, followed by his department "Executive" as child_node_1, followed by department "IT" as child_node_2 under "Executive".
