SELECT UNIQUE appl.application_name, 
       prog.user_concurrent_program_name, 
       f.application_short_name, 
       prog.concurrent_program_name, 
       e.executable_name 
FROM   fnd_executables e, 
       fnd_application f, 
       fnd_application_tl appl, 
       fnd_concurrent_programs_vl prog, 
       fnd_request_groups frg, 
       fnd_request_group_units frgu 
WHERE  prog.application_id = appl.application_id 
       AND f.application_id = appl.application_id 
       AND e.executable_id = prog.executable_id 
       AND prog.enabled_flag = 'Y' 
       AND frgu.request_group_id = frg.request_group_id 
       AND frgu.request_unit_id = PROG.concurrent_program_id 
       --and f.application_short_name like '%AR%' 
       AND prog.user_concurrent_program_name LIKE 'STL%' 
-- Replace with your Concurrent Program Name 
ORDER  BY prog.user_concurrent_program_name