Query to get Concurrent Program Details

select fcpv.user_concurrent_program_name
       ,fcpv.concurrent_program_name short_name
       ,fcpv.description
       ,fcpv.creation_date
       ,fe.executable_name
       ,fl.meaning execution_method_code
       ,fe.execution_file_name
       , fav.application_name
       ,fcpv.output_file_type
       , null data_definition
       ,null data_template
       ,null rtf_name
from fnd_concurrent_programs_vl fcpv
     ,fnd_executables fe
     ,fnd_lookups fl
     ,fnd_application_vl fav
 where 1=1
and fcpv.executable_id= fe.executable_id
and fl.lookup_type='CP_EXECUTION_METHOD_CODE'
and fl.lookup_code=fe.execution_method_code
and fav.application_id=fcpv.application_id
and fcpv.output_file_type!='XML'

UNION ALL
select fcpv.user_concurrent_program_name
       ,fcpv.concurrent_program_name short_name
       ,fcpv.description
       ,fcpv.creation_date
       ,fe.executable_name
       ,fl.meaning execution_method_code
       ,fe.execution_file_name
       , fav.application_name
       ,fcpv.output_file_type
       , xdd.data_source_name data_definition
       ,xdt.template_name data_template
       ,xdl.file_name rtf_name
from fnd_concurrent_programs_vl fcpv
     ,fnd_executables fe
     ,fnd_lookups fl
     ,fnd_application_vl fav
     ,xdo_ds_definitions_vl xdd
     ,xdo_templates_vl xdt
     ,xdo_lobs xdl
where 1=1
and fcpv.executable_id= fe.executable_id
and fl.lookup_type='CP_EXECUTION_METHOD_CODE'
and fl.lookup_code=fe.execution_method_code
and fav.application_id=fcpv.application_id
and xdd.data_source_code=fcpv.concurrent_program_name
and xdt.data_source_code= xdd.data_source_code
and xdl.lob_code= xdt.template_code
and xdl.lob_type='TEMPLATE_SOURCE'
and xdl.application_short_name=xdt.application_short_name
and xdd.end_date is null;