Query to get details of XML/BI Publisher Template and Data Definition

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