请求 菜单 功能 职责 常用脚本

--如何根据职责名称找到当前职责对应的菜单
SELECT MENU_NAME
      ,USER_MENU_NAME
      ,TYPE
      ,DESCRIPTION
  FROM FND_MENUS_VL
 WHERE MENU_ID IN
       (SELECT MENU_ID
          FROM FND_RESPONSIBILITY_VL
         WHERE RESPONSIBILITY_NAME = 'PEWEMG Order Management');
--如何根据功能名找到当前功能名挂靠在哪个职责下或哪个菜单下L
--根据用户功能名找挂靠的菜单
SELECT MENU_NAME
      ,USER_MENU_NAME
      ,TYPE
      ,DESCRIPTION
  FROM FND_MENUS_VL
 WHERE MENU_ID IN
       (SELECT MENU_ID
          FROM FND_MENU_ENTRIES_VL
         WHERE FUNCTION_ID IN
               (SELECT FUNCTION_ID
                  FROM FND_FORM_FUNCTIONS_VL
                 WHERE USER_FUNCTION_NAME = 'MEW基准价目表'));
--根据用户功能名找挂靠的职责
SELECT RESPONSIBILITY_NAME
  FROM FND_RESPONSIBILITY_VL
 WHERE MENU_ID IN
       (SELECT MENU_ID
          FROM FND_MENU_ENTRIES_VL
         WHERE FUNCTION_ID IN
               (SELECT FUNCTION_ID
                  FROM FND_FORM_FUNCTIONS_VL
                 WHERE USER_FUNCTION_NAME = 'MEW基准价目表'));
--根据FORM PROMPT提示查找挂靠在如个菜单下
SELECT MENU_NAME
      ,USER_MENU_NAME
      ,TYPE
      ,DESCRIPTION
  FROM FND_MENUS_VL
 WHERE MENU_ID IN
       (SELECT MENU_ID FROM FND_MENU_ENTRIES_VL WHERE PROMPT = '基准价目表');
--根据FORM PROMPT 提示查找 当前程序的功能名和用户功能名
SELECT FUNCTION_NAME
      ,USER_FUNCTION_NAME
  FROM FND_FORM_FUNCTIONS_VL
 WHERE FUNCTION_ID IN (SELECT FUNCTION_ID
                         FROM FND_MENU_ENTRIES_VL
                        WHERE PROMPT = '基准价目表') 如何根据请求名找到挂靠的职责及请求组：
--根据请求名找挂在哪个职责下面：
  SELECT RESPONSIBILITY_NAME
          FROM FND_RESPONSIBILITY_VL
         WHERE REQUEST_GROUP_ID IN
               (SELECT REQUEST_GROUP_ID
                  FROM FND_REQUEST_GROUPS
                 WHERE REQUEST_GROUP_ID IN
                       (SELECT REQUEST_GROUP_ID
                          FROM FND_REQUEST_GROUP_UNITS
                         WHERE REQUEST_UNIT_ID IN
                               (SELECT CONCURRENT_PROGRAM_ID
                                  FROM FND_CONCURRENT_PROGRAMS_VL
                                 WHERE USER_CONCURRENT_PROGRAM_NAME =
                                       'MEW Receipt Invoice detail Report(SMIE)')));

--根据请求名找挂在哪个请求组下面
SELECT REQUEST_GROUP_NAME
      ,REQUEST_GROUP_CODE
  FROM FND_REQUEST_GROUPS
 WHERE REQUEST_GROUP_ID IN
       (SELECT REQUEST_GROUP_ID
          FROM FND_REQUEST_GROUP_UNITS
         WHERE REQUEST_UNIT_ID IN
               (SELECT CONCURRENT_PROGRAM_ID
                  FROM FND_CONCURRENT_PROGRAMS_VL
                 WHERE USER_CONCURRENT_PROGRAM_NAME =
                       'MEW Receipt Invoice detail Report(SMIE)'));
--如何根据请求名称，查找调用的程序名称及请求类型
SELECT FCP.CONCURRENT_PROGRAM_NAME --请求简称
      ,FEF.EXECUTABLE_NAME --请求可执行简称
      ,FEF.USER_EXECUTABLE_NAME --用户可执行名称
      ,FCP.EXECUTION_METHOD_CODE --请求类型H-host Q-sql 1--Stored Procedure P--Report
      ,FEF.EXECUTION_FILE_NAME --执行文件名称
      ,FEF.EXECUTION_FILE_PATH
      ,FCP.*
  FROM FND_CONCURRENT_PROGRAMS_VL FCP
      ,FND_EXECUTABLES_FORM_V     FEF
 WHERE FCP.USER_CONCURRENT_PROGRAM_NAME =
       'MEW GOS Selling Price Temp to Interface Set' --报表名称
   AND FCP.EXECUTABLE_ID = FEF.EXECUTABLE_ID