SELECT RESPONSIBILITY_NAME RESP,FM.MENU_NAME,PROG.USER_CONCURRENT_PROGRAM_NAME
FROM FND_RESPONSIBILITY_VL RESP,FND_REQUEST_GROUP_UNITS RGU, FND_CONCURRENT_PROGRAMS_VL PROG,
FND_MENUS FM
WHERE RESP.REQUEST_GROUP_ID = RGU.REQUEST_GROUP_ID
AND FM.MENU_ID = RESP.MENU_ID
AND RGU.REQUEST_UNIT_ID = PROG.CONCURRENT_PROGRAM_ID
AND RGU.UNIT_APPLICATION_ID = PROG.APPLICATION_ID
AND PROG.USER_CONCURRENT_PROGRAM_NAME LIKE 'Concc Program Name'
ORDER BY RESP
FROM FND_RESPONSIBILITY_VL RESP,FND_REQUEST_GROUP_UNITS RGU, FND_CONCURRENT_PROGRAMS_VL PROG,
FND_MENUS FM
WHERE RESP.REQUEST_GROUP_ID = RGU.REQUEST_GROUP_ID
AND FM.MENU_ID = RESP.MENU_ID
AND RGU.REQUEST_UNIT_ID = PROG.CONCURRENT_PROGRAM_ID
AND RGU.UNIT_APPLICATION_ID = PROG.APPLICATION_ID
AND PROG.USER_CONCURRENT_PROGRAM_NAME LIKE 'Concc Program Name'
ORDER BY RESP
No comments:
Post a Comment