Query to find Templates details of XML publisher reports

SELECT distinct(XL.file_name )"File Name",
xddv.data_source_code "Data Definition Code",
       xddv.data_source_name "Data Definition",
       xddv.description "Data Definition Description",
       xtb.template_code "Template Code",
       xtt.template_name "Template Name",
       xtt.description "Template Description",
       xtb.template_type_code "Type",
       xl.file_name "File Name",
       xtb.default_output_type "Default Output Type"
  FROM apps.XDO_DS_DEFINITIONS_VL xddv,
       apps.XDO_TEMPLATES_B xtb,
       apps.XDO_TEMPLATES_TL xtt,
       apps.XDO_LOBS xl,
       apps.FND_APPLICATION_TL fat,
       APPS.FND_APPLICATION fa
WHERE  xddv.data_source_code like 'XX%'  --Need to change
       AND xddv.application_short_name = fa.application_short_name
       AND fat.application_id = fa.application_id
       AND xtb.application_short_name = xddv.application_short_name
       AND xddv.data_source_code = xtb.data_source_code
       AND xtt.template_code = xtb.template_code
       AND xl.LOB_CODE = xtb.template_code   
       AND xl.xdo_file_type = xtb.template_type_code;