Oracle applications SQL Query to select all the functions Submenu comprises by a menu if you know its responsibility name

Oracle applications SQL Query to select all the functions Submenu comprises by a menu if you know its responsibility name
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

SELECT
0 num,
RPAD ('Hirarchy for ' '-' user_menu_name,60,'-') '(' menu_id ')--(Main Menu)' menu_hirarchy
FROM fnd_menus_vl
WHERE user_menu_name = 'ABM Intelligence'
UNION
SELECT
ROWNUM num,
RPAD ( LPAD (' ', 7 * LEVEL) entry_sequence '-' NVL (prompt, function_id),60,'-')
'(' NVL (sub_menu_id, function_id) ')--(' DECODE (sub_menu_id, NULL, 'Function', 'Sub Menu') ')'
menu_hirarchy
FROM fnd_menu_entries_vl
START WITH menu_id = (SELECT menu_id FROM fnd_menus_vl WHERE menu_id =
(SELECT menu_id FROM fnd_responsibility_vl WHERE UPPER (responsibility_name) =
'APPLICATION DEVELOPER'))
CONNECT BY PRIOR sub_menu_id = menu_id
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!