Sunday, February 23, 2014

Find out Executable Details of a Concurrent Program in Oracle Apps R12

SELECT prog.user_concurrent_program_name "program name",
       prog.concurrent_program_name "program short name",
       appl.application_name "program application name",
       prog.description "program description",
       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
              ) "execution method"
  FROM fnd_executables exe,
       fnd_application_tl appl,
       fnd_concurrent_programs_vl prog
 WHERE exe.application_id = appl.application_id
   AND exe.executable_id = prog.executable_id
   AND appl.LANGUAGE = 'US'
   AND prog.user_concurrent_program_name = 'XXDA User Concurrent Program Name'

No comments:

Post a Comment