Concurrent Program and Executable Details

Concurrent Program and Executable Details

The following SQL query provide you executable file name ,top name , etc...

--Oracle Applications Query to get the actual concurrent program file executable if we know the concurrent program name

SELECT b.user_concurrent_program_name,
       b.concurrent_program_name,
       a.user_executable_name,
       DECODE (a.execution_method_code,
               'I', 'PL/SQL Stored Procedure',
               'H', 'Host',
               'S', 'Immediate',
               'J', 'Java Stored Procedure',
               'K', 'Java concurrent program',
               'M', 'Multi Language Function',
               'P', 'Oracle reports',
               'B', 'Request Set Stage Function',
               'A', 'Spawned',
               'L', 'SQL*Loader',
               'Q', 'SQL*Plus',
               'E', 'Pearl concurrent Programm',
               'Unkown Type')
          TYPE,
       a.execution_file_name,
       a.execution_file_path,
       a.application_name,
       c.basepath,
       a.executable_id
  FROM fnd_executables_form_v a,
       fnd_concurrent_programs_vl b,
       fnd_application c
 WHERE     a.executable_id = b.executable_id
       AND a.application_id = c.application_id
--       AND EXECUTABLE_NAME = 'XX'
       AND b.user_concurrent_program_name like'XX%';