Concurrent Program Name, Responsibility Name and User Name for a concurrent request id? How to find the Report Concurrent Program Name using Short Name of the Report, Responsibility Name and User Name.

• Concurrent Program Name, Responsibility Name and User Name for a concurrent request id?

• How to find the Report Concurrent Program Name using Short Name of the Report, Responsibility Name and User Name.

SELECT fcr.request_id,

       frv.responsibility_name,

       fcpv.concurrent_program_name prog_short_name,

       fcpv.user_concurrent_program_name con_prog_name,

       fu.user_name requested_by

  FROM fnd_concurrent_requests fcr,

       fnd_concurrent_programs_vl fcpv,

       fnd_user fu,

       fnd_responsibility_vl frv

 WHERE fcpv.concurrent_program_id = fcr.concurrent_program_id

   AND fu.user_id = fcr.requested_by

   AND frv.responsibility_id = fcr.responsibility_id   

   AND fcr.request_id = NVL(:P_request_id,fcr.request_id)

   AND fcpv.user_concurrent_program_name = NVL(:P_user_concurrent_program_name,fcpv.user_concurrent_program_name)