查看某一职责下对应的菜单&功能&请求

最新推荐文章于 2025-06-09 22:48:10 发布

原创

最新推荐文章于 2025-06-09 22:48:10 发布 · 3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#EBS #SQL #职责 #菜单 #请求

本文主要探讨如何查看在特定职责下的相关菜单、功能以及请求处理流程，通过对EBS系统的深入理解和SQL查询技巧，帮助读者理解职责权限与操作间的关联。

查看菜单&功能

SELECT res.RESPONSIBILITY_NAME 职责名称,
       menu.MENU_NAME 菜单编码,
       menu.USER_MENU_NAME 菜单名称,
       func.FUNCTION_NAME 功能编码,
       func.USER_FUNCTION_NAME 菜单名称,
       sub_menu.PROMPT 
  FROM FND_RESPONSIBILITY_VL res,
       fnd_menus_vl          menu,
       FND_MENU_ENTRIES_VL   sub_menu,
       FND_FORM_FUNCTIONS_VL func
 WHERE res.MENU_ID = sub_menu.MENU_ID
   AND menu.MENU_ID = sub_menu.MENU_ID
   AND sub_menu.FUNCTION_ID = func.FUNCTION_ID
   AND res.RESPONSIBILITY_NAME LIKE 'HJSJ%'
   AND sub_menu.SUB_MENU_ID IS NULL
   AND sub_menu.FUNCTION_ID IS NOT NULL
   AND sub_menu.PROMPT IS NOT NULL
UNION ALL
SELECT res.RESPONSIBILITY_NAME,
       menu.MENU_NAME,
       menu.USER_MENU_NAME,
       func.FUNCTION_NAME,
       func.USER_FUNCTION_NAME,
       sub_menu1.PROMPT
  FROM FND_RESPONSIBILITY_VL res,
       fnd_menus_vl          menu,
       FND_MENU_ENTRIES_VL   sub_menu,
       FND_MENU_ENTRIES_VL   sub_menu1,
       FND_F