select
    'f?p=4600:7:'||:app_session||':::7:P7_EMPNO:'||e.empno edit_link,
    '#IMAGE_PREFIX#menu/user_red_64.gif' icon,
    e.EMPNO,
    e.ENAME,
    e.JOB,
    e.MGR,
    e.HIREDATE,
    e.SAL,
    e.COMM,
    e.DEPTNO,
    d.dname,
    e.work_city city,
    e.work_country country,
    (select count(*) from wwv_demo_emp e2 where e2.mgr = e.empno) direct_reports
from WWV_DEMO_EMP e,
     wwv_demo_dept d
where e.deptno = d.deptno