Localizar package pelo nome do concurrent

SELECT a.user_concurrent_program_name
      ,b.executable_name
      ,b.execution_file_name package_name
  FROM apps.fnd_concurrent_programs_vl a
      ,apps.fnd_executables_vl         b
 WHERE a.executable_id = b.executable_id
   AND upper(user_concurrent_program_name) like '%NOME_CONCORRENTE%'

 

 

NO CASO DO CONCORRENTE SER UM REPORT OU ALGO DIFERENTE, USAR A QUERY ABAIXO

 

SELECT prog. user_concurrent_program_name "Concurrent Program Name"
        ,prog.concurrent_program_name "Concurrent Program short name"
        ,exe.executable_name "Executable Name"
        ,exe.execution_file_name "executable file name"
        ,decode(exe.execution_method_code, 'I', 'PLSQL Stored Procedure', 'P',
               'Report', 'L', 'SQL Loader', 'Q', 'SQL*Plus',
               exe.execution_method_code) "Program Execution Method"
        ,appl.application_name "application name"
        ,prog.description "Program description"
   FROM apps.fnd_executables            exe
       ,apps.fnd_application_tl         appl
       ,apps.fnd_concurrent_programs_vl prog
  WHERE exe.application_id = appl.application_id
    AND exe.executable_id = prog.executable_id
    AND UPPER(prog.user_concurrent_program_name) like UPPER('%NOME DO CONCORRENTE%')