SELECT LEVEL,
CONNECT_BY_ISLEAF,
CONNECT_BY_ROOT t.PROMPT,
SYS_CONNECT_BY_PATH(t.PROMPT, '->')
FROM (select tt.*
from fnd_menu_entries_vl tt
where (tt.SUB_MENU_ID is not null or tt.FUNCTION_ID is not null)
and tt.PROMPT is not null) t
START WITH t.MENU_ID =
(select fr.MENU_ID
from fnd_responsibility_vl fr
where fr.RESPONSIBILITY_NAME like '%总帐超级%')
CONNECT BY PRIOR t.SUB_MENU_ID = t.MENU_ID
ORDER SIBLINGS BY t.ENTRY_SEQUENCE;