ERPstuff - Oracle EBS Community

hi
i'd like to know how can i merge two hierarchical trees together.
for instnace to query for each deparatment all its employees with considering to the employees hierarchicy.

AOA,

I will send u the complete example within two days inshaallah.

Zafar Iqbal