根据功能,查找哪些职责有在使用该功能的SQL

最新推荐文章于 2019-10-30 23:30:02 发布

rfb0204421

最新推荐文章于 2019-10-30 23:30:02 发布

阅读量1.1k

点赞数

分类专栏： EBS

本文链接：https://blog.csdn.net/rfb0204421/article/details/9292035

版权

EBS 专栏收录该内容

30 篇文章 2 订阅

订阅专栏

select '生产投料及退回' 功能
      ,frv.RESPONSIBILITY_NAME
      ,frv.RESPONSIBILITY_KEY
      ,frv.DESCRIPTION
      ,frv.MENU_ID
      ,fmv.MENU_NAME
      ,fmv.USER_MENU_NAME
from FND_RESPONSIBILITY_VL frv
inner join FND_MENUS_VL fmv on frv.MENU_ID = fmv.MENU_ID
where (frv.version = '4' or frv.version = 'W' or frv.version = 'M')
   and frv.MENU_ID in (select fmev.MENU_ID
                         from FND_MENU_ENTRIES_VL fmev
                       connect by prior fmev.MENU_ID = fmev.SUB_MENU_ID
                        start with fmev.FUNCTION_ID = 47815) --
   and not exists--排除项
(select 1
          from FND_RESP_FUNCTIONS frf
         where frf.responsibility_id = frv.RESPONSIBILITY_ID)