Query for User wise Responsibility , Menus and Functions

select distinct
       FU.USER_NAME,
       FU.END_DATE USER_END_DATE,
       fr.responsibility_name,
       fm.user_menu_name,
       fme.prompt prompt_name,
       fff.user_function_name
from   
       FND_USER fu,
       FND_USER_RESP_GROUPS_DIRECT urg,
       apps.fnd_menu_entries_vl fme,
       apps.fnd_menus_vl fm,
       apps.fnd_form_functions_vl fff,
       apps.fnd_form_vl ff,
       APPS.FND_RESPONSIBILITY_VL FR
where fff.user_function_name = 'XX_FUNC_NAME'
and FU.USER_ID = URG.USER_ID
and FU.END_DATE is null
and FR.RESPONSIBILITY_ID = URG.RESPONSIBILITY_ID
and    FME.FUNCTION_ID = FFF.FUNCTION_ID
and    FM.MENU_ID = FME.MENU_ID
AND    fr.menu_id = fm.menu_id ;