select frt.responsibility_name,

         fr.menu_id,

         fm.menu_name,

         fr.request_group_id,

         frg.request_group_name

 from fnd_responsibility      fr,

         fnd_responsibility_tl frt,

         fnd_menus              fm,

         fnd_request_groups    frg

 where frt.responsibility_id = fr.responsibility_id

    and frt.language = userenv('LANG')

    and frt.responsibility_name like '%X%'

    and fm.menu_id = fr.menu_id

    and frg.request_group_id = fr.request_group_id