Posts

Showing posts from December, 2018

Query to Fetch RDF file and RTF Template Name

SELECT fev.execution_file_name,        fcp.concurrent_program_name,        xtb.default_output_type,        fcp.user_concurrent_program_name,        fat.application_name,        '$' || fat.basepath || '/' || 'reports/US' reports_path,        xtt.template_name,        xddt.data_source_name,        fcp.enabled_flag,        fcp.output_file_type cp_output_file_type,        xtb.default_output_type rtf_default_output_type,        xtb.template_type_code,        fev.execution_method_code   FROM fnd_executables_vl fev,        fnd_application_vl fat,        fnd_concurrent_programs_vl fcp,        xdo_ds_definitions_tl xddt,        xdo_templates_b xtb,   ...