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

最新推荐文章于 2025-09-05 21:27:49 发布

weixin_33747129

最新推荐文章于 2025-09-05 21:27:49 发布

阅读量127

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/st-sun/p/3777967.html

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

转载于:https://www.cnblogs.com/st-sun/p/3777967.html