Responsibility&Access org
SELECT D.ORGANIZATION_CODE,
D.APPLICATION_NAME,
D.RESPONSIBILITY_NAME,
A.RESPONSIBILITY_NAME,
A.RESPONSIBILITY_KEY,
B.APPLICATION_SHORT_NAME,
C.MENU_NAME
FROM FND_RESPONSIBILITY_VL A,
FND_APPLICATION B,
FND_MENUS_VL C,
ORG_ACCESS_V D
WHERE 1=1
AND A.RESPONSIBILITY_NAME LIKE '%S%1'
AND A.APPLICATION_ID=B.APPLICATION_ID
AND A.MENU_ID=C.MENU_ID
AND A.RESPONSIBILITY_ID=D.RESPONSIBILITY_ID
AND D.ORGANIZATION_CODE =X ORDER BY D.RESPONSIBILITY_NAME
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/41594/viewspace-50531/，如需转载，请注明出处，否则将追究法律责任。
上一篇：
判断料号在那些org里面
下一篇：
委外工单对应供应商之SQL
请登录后发表评论
登录
全部评论
