Wednesday, September 26, 2018

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 
FROM   fnd_executables_form_v a, 
       fnd_concurrent_programs_vl b, 
       fnd_application c 
WHERE  a.application_id = c.application_id 
       AND 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 'XXX: Program Name'; 

No comments:

Post a Comment

What is the process of getting a permanent driving license after getting learning license in Noida? Please answer in detail.

This also answers “Uttar Pradesh - How to Obtain a Learner Driver Licence? ” No Agent, No Third Party. To get your driving license is...