Given this code
select sys_connect_by_path(n.label, '>') "NAVIGATOR PATH",
level "LEVEL",
upper(n.entry_type) "TYPE",
g.role,
n.projection
from fnd_navigator_all n
left join fnd_projection_grant g
on n.projection=g.projection
where n.projection like nvl('&Projection','%')
and g.role like upper(nvl('&Role','%'))
connect by prior n.id = n.parent_id
start with n.parent_id = 0
order siblings by n.sort_order
How would I show the Access Level of each projection.
Not really finding this as a selectable field on any view...
