Query to find Request Group, Responsibility name,and so on...

Use this query if you know the concurrent program name

SELECT DISTINCT
            FCPL.USER_CONCURRENT_PROGRAM_NAME,
            FCP.CONCURRENT_PROGRAM_NAME,
            FAPP.APPLICATION_NAME,
            FRG.REQUEST_GROUP_NAME, 
            FNRTL.RESPONSIBILITY_NAME
  FROM APPS.FND_REQUEST_GROUPS FRG,
           APPS.FND_APPLICATION_TL FAPP,
           APPS.FND_REQUEST_GROUP_UNITS FRGU,
           APPS.FND_CONCURRENT_PROGRAMS FCP,
           APPS.FND_CONCURRENT_PROGRAMS_TL FCPL,
           APPS.FND_RESPONSIBILITY FNR,
           APPS.FND_RESPONSIBILITY_TL FNRTL
WHERE FRG.APPLICATION_ID =FAPP.APPLICATION_ID
    AND FRG.APPLICATION_ID = FRGU.APPLICATION_ID
    AND FRG.REQUEST_GROUP_ID = FRGU.REQUEST_GROUP_ID
    AND FRG.REQUEST_GROUP_ID = FNR.REQUEST_GROUP_ID
    AND FRG.APPLICATION_ID = FNR.APPLICATION_ID
    AND FNR.RESPONSIBILITY_ID = FNRTL.RESPONSIBILITY_ID
    AND FRGU.REQUEST_UNIT_ID = FCP.CONCURRENT_PROGRAM_ID
    AND FRGU.UNIT_APPLICATION_ID = FCP.APPLICATION_ID
    AND FCP.CONCURRENT_PROGRAM_ID = FCPL.CONCURRENT_PROGRAM_ID
    AND FCPL.USER_CONCURRENT_PROGRAM_NAME LIKE 'Name of concurrent program'
    AND FNRTL.LANGUAGE = 'US'AND FAPP.LANGUAGE = 'US'