Request Group and Responsibility by Concurrent Program

To debug an issue of any concurrent program which fails with errors we need to relogin to  reproduce the error. It would be useful if we know in which request group and in which responsibility the concurrent program is available. The below SQL query will help us 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 frg.request_group_name                LIKE  'All Reports'

    AND frg.description                              = 'All Purchasing SRS Reports'

    AND cpt.user_concurrent_program_name LIKE 'Account Analysis Report%'