Monday, June 5, 2017

Query - Get all Custom BI Publisher Reports with Excel Output


SELECT 
prog.user_concurrent_program_name,
exe.executable_name,
exe.execution_method_code,
exe.execution_file_name
FROM 
fnd_executables_form_v exe,
fnd_concurrent_programs_vl prog,
xdo_templates_b rtf
WHERE
 exe.executable_id = prog.executable_id
AND rtf.application_short_name = 'XX' 
AND rtf.default_output_type = 'EXCEL'
AND concurrent_program_name = rtf.data_source_code

0 comments:

Post a Comment

 
Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | Justin Bieber, Gold Price in India