用sql语句如何导出application某个用户的menu

纵横四海

试试这,不过得分2步.我还没想好怎么合起来.
1.先找出主菜单和职责
SELECT C.MENU_ID,D.USER_MENU_NAME,A.RESPONSIBILITY_ID,C.RESPONSIBILITY_NAME
FROM FND_USER_RESP_GROUPS A,FND_USER B ,FND_RESPONSIBILITY_VL C,FND_MENUS_TL D
WHERE A.USER_ID = B.USER_ID
AND A.RESPONSIBILITY_ID = C.RESPONSIBILITY_ID
AND C.MENU_ID = D.MENU_ID
AND D.LANGUAGE = 使用语言的代码
AND B.USER_NAME = 用户名
2 查寻菜单(子菜单),FUNCTION的信息
SELECT B.MENU_ID,C.USER_MENU_NAME,B.FUNCTION_ID,D.FUNCTION_NAME
FROM FND_MENU_ENTRIES_VL A,FND_MENU_ENTRIES_VL B, FND_MENUS_TL C,FND_FORM_FUNCTIONS_VL D
WHERE A.SUB_MENU_ID IS NOT NULL
AND A.SUB_MENU_ID = B.MENU_ID
AND B.SUB_MENU_ID IS NULL
AND B.MENU_ID = C.MENU_ID
AND B.FUNCTION_ID = D.FUNCTION_ID
AND A.MENU_ID = 1.取得的菜单ID
AND C.LANGUAGE = 使用语言的代码
ORDER BY 1