List of Menus Excluded from a given Responsibility. How to fetch Menu name from the given Responsibility or How Many Menu Attached to the Respective Responsibility. How to find the Menu Name or User Menu Name from the given Responsibility in oracle apps

• List of Menus Excluded from a given Responsibility.

• How to fetch Menu name from the given Responsibility or How Many Menu Attached to the Respective Responsibility.

•  How to find the Menu Name or User Menu Name from the given Responsibility in Oracle apps

SELECT frv.responsibility_name,

       fmv.user_menu_name

  FROM fnd_resp_functions frf,

       fnd_menus_vl fmv,

       fnd_responsibility_vl frv

 WHERE frf.rule_type = 'M'

   AND frf.action_id = fmv.menu_id

   AND frf.responsibility_id = frv.responsibility_id

   AND frv.responsibility_name = '&resp_name';