Way to success...

--"Running Away From Any PROBLEM Only Increases The DISTANCE From The SOLUTION"--.....--"Your Thoughts Create Your FUTURE"--.....--"EXCELLENCE is not ACT but a HABIT"--.....--"EXPECT nothing and APPRECIATE everything"--.....

Tuesday, December 22, 2015

Query to find concurrent program execution file name, type from user 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'
              ) AS "Method Type",
       a.execution_file_name, a.application_name, a.execution_file_path
  FROM fnd_executables_form_v a, fnd_concurrent_programs_vl b
 WHERE a.executable_id = b.executable_id
   AND a.application_id = b.application_id
   AND a.executable_id > 4
   AND b.user_concurrent_program_name LIKE 'Active Users%' --Enter user concurrent program name here
   AND a.execution_method_code <> 'A' 
   AND b.ENABLED_FLAG = 'Y'
   order by a.execution_method_code;

No comments:

Post a Comment