How to Find the Responsibility to which the Concurrent Program is Attached

There will be a situation where you don't know from which responsibility to submit the concurrent program and in that case first you have find to which responsibility the concurrent program is attached so that you can submit the concurrent request from same responsibility.

The below query helps you to find the responsibility & request group details to which your concurrent program is attached.

SELECT frt.responsibility_name,
  frg.request_group_name,
  frg.description,
  frgu.request_unit_type,
  frgu.request_unit_id,
  fcpt.user_concurrent_program_name
FROM fnd_Responsibility fr,
  fnd_responsibility_tl frt,
  fnd_request_groups frg,
  fnd_request_group_units frgu,
  fnd_concurrent_programs fcp ,
  fnd_concurrent_programs_tl fcpt
WHERE frt.responsibility_id                 = fr.responsibility_id
AND frg.request_group_id                     = fr.request_group_id
AND frgu.request_group_id                   = frg.request_group_id
AND fcpt.concurrent_program_id         = frgu.request_unit_id
AND fcp.application_id                         = fcpt.application_id
AND fcp.concurrent_program_id          = fcpt.concurrent_program_id
AND frt.LANGUAGE                           = USERENV('LANG')
AND fcpt.LANGUAGE                         = USERENV('LANG')
AND UPPER(fcp.concurrent_program_name)       = UPPER(:Conc_prog_shrt_name) /*Pass Your Concurrent Program Short Name */
AND UPPER(fcpt.user_concurrent_program_name) = UPPER(:Conc_prg_name)/*Pass Your Concurrent Program Name*/
ORDER BY 1,2,3,4;
/

HAPPY LEARNING...!!!