Get Request Group and Responsibility by Concurrent Program

It happens a lot when debugging any issue an user has with Oracle E-Business Suite a concurrent program is mentioned which seems to fail. You can relogin as that user to reproduce the error but it might also be handy if you know in which request group and it which responsibility this concurrent program is available. I always use the below SQL statement to get this information from the database. Filter on the concurrent request name or use the concurrent program short name (commented out) to get this information.

SELECT
    FRG.REQUEST_GROUP_NAME,  
    FRG.DESCRIPTION,  
    CP.CONCURRENT_PROGRAM_ID,  
    CP.CONCURRENT_PROGRAM_NAME,  
    CPT.USER_CONCURRENT_PROGRAM_NAME,
    FRV.RESPONSIBILITY_NAME
FROM 
    FND_REQUEST_GROUPS FRG,  
    FND_REQUEST_GROUP_UNITS FRGU,  
    FND_CONCURRENT_PROGRAMS CP,  
    FND_CONCURRENT_PROGRAMS_TL CPT,
    FND_RESPONSIBILITY_VL FRV
WHERE 
    FRG.REQUEST_GROUP_ID = FRGU.REQUEST_GROUP_ID  
    AND FRGU.REQUEST_UNIT_ID = CP.CONCURRENT_PROGRAM_ID  
    AND CP.CONCURRENT_PROGRAM_ID = CPT.CONCURRENT_PROGRAM_ID  
    AND FRV.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID(+)
    AND CPT.USER_CONCURRENT_PROGRAM_NAME LIKE 'AUD%Missing%Timecar%'
    --AND cp.concurrent_program_name = 'PAXAUMTC'