职责菜单请求组查询

select fa.APPLICATION_ID         应用ID,
       fa.APPLICATION_SHORT_NAME 应用代码,
       fa.APPLICATION_NAME       应用名称,
       fr.RESPONSIBILITY_ID      职责ID,
       fr.RESPONSIBILITY_KEY     职责关键字,
       fr.RESPONSIBILITY_NAME    职责名称,
       fm.MENU_ID                菜单ID,
       fm.MENU_NAME              菜单名称,
       fm.USER_MENU_NAME 用户菜单名称,
       frg.request_group_id      请求组ID,
       frg.request_group_code    请求组代码,
       frg.request_group_name    请求组名称
  from FND_RESPONSIBILITY_VL fr,
       FND_MENUS_VL          fm,
       FND_REQUEST_GROUPS    frg,
       fnd_application_vl    fa
 where fr.MENU_ID = fm.MENU_ID
   and frg.request_group_id = fr.REQUEST_GROUP_ID
   and fr.APPLICATION_ID = fa.APPLICATION_ID;