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