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'
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