Saturday, April 16, 2011

SQL Query to find concurrent program responsibilities menus that are attached

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

No comments:

Post a Comment