Concurrent Program and Executable Details
--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%';
