Concurrent Program name to find out

Based on the Concurrent Program name to find out the Responsibility name, Executable name, Application Name, Request Group

/* Formatted on dd/mm/rrrr 16:50 (Formatter Plus v4.8.8) */

SELECT rt.responsibility_name, b.execution_options, e.execution_file_name,
       t.user_concurrent_program_name, g.request_group_name,
       AT.application_name, ab.application_short_name, e.executable_name
  FROM apps.fnd_executables e,
       apps.fnd_concurrent_programs_tl t,
       apps.fnd_concurrent_programs b,
       apps.fnd_request_group_units r,
       apps.fnd_responsibility_tl rt,
       apps.fnd_responsibility rb,
       apps.fnd_application_tl AT,
       apps.fnd_application ab,
       apps.fnd_request_groups g
 WHERE e.executable_id = b.executable_id
   AND t.concurrent_program_id = r.request_unit_id
   AND b.application_id = t.application_id
   AND b.concurrent_program_id = t.concurrent_program_id
   AND t.LANGUAGE = USERENV ('LANG')
   AND rb.responsibility_id = rt.responsibility_id
   AND rb.application_id = rt.application_id
   AND rt.LANGUAGE = USERENV ('LANG')
   AND ab.application_id = AT.application_id
   AND AT.LANGUAGE = USERENV ('LANG')
   AND rb.request_group_id = r.request_group_id
   AND ab.application_id = e.application_id
   AND g.request_group_id = r.request_group_id
--AND rt.responsibility_name  like '%US%'

  AND t.user_concurrent_program_name = 'Sri Program Job Routing Sheet' --;   -- Give u r Concurrent prog name