Query to validate migration of XML/BI Publisher Template and Data Definition

1SELECT xt_list.*, xdo_db.*
2    FROM (SELECT XDDV.data_source_code "Data Definition Code",
3                 XDDV.data_source_name "Data Definition",
4                 XDDV.description      "Data Definition Description",
5                 XTB.template_code     template_code,
6                 XTT.template_name     "Template Name",
7                 XTT.description       "Template Description",
8                 XTB.template_type_code "Type",
9                 XTB.default_output_type "Default Output Type",
10                 XLtemp.file_name      "Template File Name",
11                 xlbur.FILE_NAME       "Bursting File Name",
12                 xldd.FILE_NAME        "Data Template File Name"
13            FROM apps.XDO_DS_DEFINITIONS_VL XDDV,
14                 apps.XDO_TEMPLATES_B     XTB,
15                 apps.XDO_TEMPLATES_TL    XTT,
16                 apps.XDO_LOBS            XLTemp,
17                 apps.XDO_LOBS            XLDD,
18                 apps.XDO_LOBS            XLBUR,
19                 apps.FND_APPLICATION_TL  FAT,
20                 APPS.FND_APPLICATION     FA
21           WHERE     XDDV.application_short_name = FA.application_short_name
22                 AND FAT.application_id = FA.application_id
23                 AND XTB.application_short_name = XDDV.application_short_name
24                 AND XDDV.data_source_code = XTB.data_source_code
25                 AND XTT.template_code = XTB.template_code
26                 AND XTT.language = 'US'
27                 AND fat.language = 'US'
28                 AND XLtemp.LOB_CODE(+) = XTB.TEMPLATE_CODE
29                 AND XLtemp.XDO_FILE_TYPE(+) = XTB.TEMPLATE_TYPE_CODE
30                 AND xldd.LOB_CODE(+) = XDDV.data_source_code
31                 AND xldd.LOB_TYPE(+) = 'DATA_TEMPLATE'
32                 AND xlbur.LOB_CODE(+) = XDDV.data_source_code
33                 AND xlbur.LOB_TYPE(+) = 'BURSTING_FILE') xdo_db,
34         (SELECT 'XXTEMPLATE_CODE1' xt_code FROM DUAL
35          UNION
36          SELECT ' XXTEMPLATE_CODE2' xt_code FROM DUAL) xt_list
37   WHERE xdo_db.TEMPLATE_CODE(+) = xt_list.xt_code
38ORDER BY 1;