Can some pls take a look at my tree query below iam able to get correct tree structure but the link to call the reportpage14 isnt working,
i have the items :P2_EMPNO(hidden) and P14_SELECTED_NODE
select case when connect_by_isleaf = 1 then 0
when level = 1 then 1
end as status,
"ENAME" as title,
(case when level = 1 then '#IMAGE_PREFIX#Fndtre11.gif'
when level = 2 then '#IMAGE_PREFIX#Fndtre12.gif'
else '#IMAGE_PREFIX#Fndtre13.gif' end) icon,
"EMPNO" as value,
null as tooltip, 'f?p=&APP_ID.:14:APP_SESSION::::P2_EMPNO,P14_SELECTED_NODE:'||empno||','||empno as link
start with "MGR" is null
connect by prior "EMPNO" = "MGR"
order siblings by "ENAME"