find responsibility for a concurrent request

find responsibility for a concurrent request

In oracle apps it often happens that we want to run a concurrent request but we don't know that from which responsibility we have to run it. The following query takes the concurrent program name as input and gives the responsibility name from which it can be run->

SELECT
C.CONCURRENT_PROGRAM_NAME,USER_CONCURRENT_PROGRAM_NAME,REQUEST_GROUP_NAME,fr.responsibility_name
FROM
FND_REQUEST_GROUPS A,
FND_REQUEST_GROUP_UNITS B,
FND_CONCURRENT_PROGRAMS_VL C,
fnd_responsibility_vl fr
WHERE
A.REQUEST_GROUP_ID = B.REQUEST_GROUP_ID
AND A.APPLICATION_ID = B.APPLICATION_ID
AND C.CONCURRENT_PROGRAM_ID = b.REQUEST_UNIT_ID
and a.request_group_id=fr.request_group_id
AND USER_CONCURRENT_PROGRAM_NAME like  :a