How to check which concurrent request assign to which responsibility

Hi Folks,

It is very difficult to find out from the front end to which concurrent request is assign to which responsibility.

below is the query to identify which is suitable responsibility for the concurrent request.

SELECT FRT.RESPONSIBILITY_NAME, FRG.REQUEST_GROUP_NAME, FRG.DESCRIPTION ,frt.*

  FROM FND_REQUEST_GROUPS FRG

      ,FND_REQUEST_GROUP_UNITS FRGU

      ,FND_CONCURRENT_PROGRAMS FCP

      ,FND_CONCURRENT_PROGRAMS_TL FCPT

      ,FND_RESPONSIBILITY_TL FRT

      ,FND_RESPONSIBILITY FR

 WHERE     FRGU.UNIT_APPLICATION_ID = FCP.APPLICATION_ID

       AND FRGU.REQUEST_UNIT_ID = FCP.CONCURRENT_PROGRAM_ID

       AND FRG.REQUEST_GROUP_ID = FRGU.REQUEST_GROUP_ID

       AND FRG.APPLICATION_ID = FRGU.APPLICATION_ID

       AND FCPT.SOURCE_LANG = USERENV('LANG')

       AND FCP.APPLICATION_ID = FCPT.APPLICATION_ID

       AND FCP.CONCURRENT_PROGRAM_ID = FCPT.CONCURRENT_PROGRAM_ID

       AND FR.APPLICATION_ID = FRT.APPLICATION_ID

       AND FR.RESPONSIBILITY_ID = FRT.RESPONSIBILITY_ID

       AND FRT.SOURCE_LANG = USERENV('LANG')

       AND FR.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID

       AND FR.APPLICATION_ID = FRG.APPLICATION_ID

       --   AND FCP.CONCURRENT_PROGRAM_NAME = 'OPMTMOPG'  --  YOU CAN PUT THE SHORTNAME HERE

       AND FCPT.USER_CONCURRENT_PROGRAM_NAME  = :Request_name --OR THE USER CONC PROGRAM NAME HERE;