根据功能名称, 追溯所属菜单和职责

1. 根据功能名称，获取功能ID

SELECT FUNCTION_ID

  FROM FND_FORM_FUNCTIONS_VL
WHERE USER_FUNCTION_NAME = 'SLA: Application Accounting Definitions';

2. 根据功能ID，查询该功能所在菜单和职责：
   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 = 1031138);

3. 获取当前职责菜单ID

 SELECT RESPONSIBILITY_NAME,
       RESPONSIBILITY_KEY,
       DESCRIPTION,
       MENU_ID 
  FROM FND_RESPONSIBILITY_VL
WHERE (version = '4' or version = 'W' or version = 'M')
   and RESPONSIBILITY_NAME='SCM SUPER USER'

4. 查询该功能所在菜单路径。

select level, a.*
  from (select fmev.MENU_ID, fmev.SUB_MENU_ID, fmev.PROMPT
          from FND_MENU_ENTRIES_VL fmev
        connect by prior fmev.MENU_ID = fmev.SUB_MENU_ID
         start with fmev.FUNCTION_ID = 1031138) a
connect by prior a.sub_menu_id = a.menu_id
 start with a.menu_id = 1026527

Reference: http://luoyong0201.blog.163.com/blog/static/1129305201101985646463/