如何根据职责名称找到当前职责对应的菜单
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