Responsibility (Menu & Functions) LEVEL-1 - Oracle EBS R12

https://systemadministratorsys.blogspot.com/2018/06/responsibility-menu-functions.html

Responsibility (Menu & Functions) LEVEL-1

SELECT   distinct a.RESPONSIBILITY_NAME, menu.DESCRIPTION MENU_DESCRIPTION,
/*LPAD(' ', 6*((LEVEL-1))) ||*/ menu_entry.entry_sequence "SEQUENCE (LEVEL-1)"
,menu_entry.PROMPT "PROMPT (LEVEL-1)"
, /*LPAD(' ', 6*((LEVEL-1))) ||*/ menu.user_menu_name "SUBMENU DESCRIPTION (LEVEL-1)"
,/* LPAD(' ', 6*((LEVEL-1))) ||*/ func.user_function_name "FUNCTION DESCRIPTION (LEVEL-1)"
,menu_entry.DESCRIPTION "DESCRIPTION (LEVEL-1)"
, menu.menu_id
, func.function_id
, menu_entry.grant_flag Grant_Flag
, DECODE( menu_entry.sub_menu_id
, null, 'FUNCTION'
, DECODE( menu_entry.function_id
, null, 'SUBMENU'
, 'BOTH')
) Type
FROM FND_MENU_ENTRIES_VL menu_entry,
fnd_menus_tl menu,--FND_USER_RESP_GROUPS_DIRECT c,
fnd_form_functions_tl func , Fnd_Responsibility_Vl a
WHERE menu_entry.sub_menu_id = menu.menu_id(+)
AND menu_entry.function_id = func.function_id(+)
and a.MENU_ID =  menu_entry.MENU_ID
--and c.RESPONSIBILITY_ID(+)=a.RESPONSIBILITY_ID
--and a.RESPONSIBILITY_NAME =  'AP ADMINISTRATOR'
AND grant_flag = 'Y'
--and LPAD(' ', 6*((LEVEL-1))) || menu_entry.entry_sequence = 5

CONNECT BY menu_entry.menu_id = PRIOR menu_entry.sub_menu_id
ORDER SIBLINGS BY menu_entry.entry_sequence