Oracle EBS-SQL (SYS-20):职责使用菜单2.sql

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