Oracle ERP二次开发常用脚本（3）

(3)./*查找在菜单里提交的报表所在职责*/
SELECT A.RESPONSIBILITY_NAME,B.PROMPT,F.USER_CONCURRENT_PROGRAM_NAME
FROM FND_RESPONSIBILITY_VL A,
FND_MENU_ENTRIES_VL B,
FND_FORM_FUNCTIONS_VL C,
FND_REQUEST_GROUPS D,
FND_REQUEST_GROUP_UNITS E,
FND_CONCURRENT_PROGRAMS_VL F
WHERE A.MENU_ID=B.MENU_ID
AND B.FUNCTION_ID=C.FUNCTION_ID
AND C.PARAMETERS LIKE '%'||D.REQUEST_GROUP_CODE||'%'
AND D.APPLICATION_ID=E.APPLICATION_ID
AND D.REQUEST_GROUP_ID=E.REQUEST_GROUP_ID
AND E.UNIT_APPLICATION_ID=F.APPLICATION_ID
AND E.REQUEST_UNIT_ID=F.CONCURRENT_PROGRAM_ID
AND F.USER_CONCURRENT_PROGRAM_NAME LIKE '%杂项出入库报表%'

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/81023/viewspace-799847/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/81023/viewspace-799847/