Scripts for menu , user name menu , User , Responsibility

/* Formatted on 25-09-2014 15:19:08 (QP5 v5.115.810.9015) */

SELECT   FRV.RESPONSIBILITY_NAME,

fmv.MENU_NAME,

FMV.USER_MENU_NAME,

FU.USER_NAME , fmev.PROMPT

FROM   FND_RESPONSIBILITY_VL FRV,

FND_MENUS_VL FMV,

fnd_user fu,

fnd_user_resp_groups furg ,

FND_MENU_ENTRIES_VL fmev

WHERE     --  RESPONSIBILITY_NAME = 'Su-Kam India Local Inventory Super User'

    FRV.menu_id = 80345

AND FRV.menu_id = FMV.menu_id

AND fu.user_id = furg.user_id

AND FRV.RESPONSIBILITY_ID = furg.RESPONSIBILITY_ID

and fmev.MENU_ID = fmv.MENU_ID

and fmev.prompt= 'Miscellaneous Transaction'