In Apex Oracle 5.1,I tried using an interactive report to display employee details based on Hierarchy. I have used the below query to display data:
SELECT last_name, employee_id, manager_id, LEVEL
FROM employees
START WITH employee_id = 100
CONNECT BY PRIOR employee_id = manager_id
ORDER SIBLINGS BY last_name;
The output was as below :
LAST_NAME EMPLOYEE_ID MANAGER_ID LEVEL
------------------------- ----------- ---------- ----------
King 100 1
Cambrault 148 100 2
Bates 172 148 3
Bloom 169 148 3
Fox 170 148 3
Kumar 173 148 3
Ozer 168 148 3
Smith 171 148 3
De Haan 102 100 2
Hunold 103 102 3
Austin 105 103 4
Ernst 104 103 4
Lorentz 107 103 4
Pataballa 106 103 4
Errazuriz 147 100 2
Ande 166 147 3
Banda 167 147 3
...
Now, i would like to display data based on Login of employees.
For example(based on above query): If an employee named - Cambrault is login,only employees under him (Bates,Bloom ,Fox ,Kumar ,Smith,Ozer) and his own details should display in the report.
Kindly advise.
regards,
mebu