EBS XML - XML报表的模板文件存在哪里？

文件以blob格式存储在表xdo.xdo_lobs，字段file_data

SELECT *
  FROM (SELECT templatesvleo.template_id,
               templatesvleo.template_code,
               templatesvleo.application_short_name,
               templatesvleo.ds_app_short_name,
               templatesvleo.data_source_code,
               xdolobseo1.language,
               xdolobseo1.territory,
               xdolobseo1.file_name,
               decode(xdolobseo1.language,
                      '00',
                      '(Language independent)',
                      fnd_iso_lang.name) AS language_meaning,
               xdolobseo2.file_name sample_file_name,
               (CASE
                 WHEN templatesvleo.dependency_flag = 'C' OR
                      xdolobseo2.file_name IS NULL THEN
                  decode((CASE
                           WHEN templatesvleo.mls_language = xdolobseo1.language AND
                                templatesvleo.mls_territory = xdolobseo1.territory THEN
                            'Y'
                           ELSE
                            'N'
                         END),
                         'Y',
                         'MLSBasePreviewDisabled',
                         'PreviewDisabled')
                 ELSE
                  decode((CASE
                           WHEN templatesvleo.mls_language = xdolobseo1.language AND
                                templatesvleo.mls_territory = xdolobseo1.territory THEN
                            'Y'
                           ELSE
                            'N'
                         END),
                         'Y',
                         'MLSBasePreviewEnabled',
                         'PreviewEnabled')
               END) AS previewimage,
               NULL AS selected_flag,
               decode(xdolobseo1.territory,
                      '00',
                      '',
                      fnd_territories.territory_short_name) AS description,
               templatesvleo.template_type_code AS template_type,
               template_name AS template_name,
               (CASE
                 WHEN templatesvleo.template_status = 'L' OR
                      (templatesvleo.default_language = xdolobseo1.language AND
                      templatesvleo.default_territory = xdolobseo1.territory) OR
                      (templatesvleo.mls_language = xdolobseo1.language AND
                      templatesvleo.mls_territory = xdolobseo1.territory AND
                      NOT EXISTS
                       (SELECT xl.lob_code
                          FROM xdo_lobs xl
                         WHERE xl.application_short_name =
                               templatesvleo.application_short_name
                           AND xl.lob_code = templatesvleo.template_code
                           AND xl.language = templatesvleo.default_language
                           AND xl.territory = templatesvleo.default_territory
                           AND xl.lob_type = 'TEMPLATE')) THEN
                  decode((CASE
                           WHEN templatesvleo.mls_language = xdolobseo1.language AND
                                templatesvleo.mls_territory = xdolobseo1.territory THEN
                            'Y'
                           ELSE
                            'N'
                         END),
                         'Y',
                         'MLSBaseDeleteDisabled',
                         'DeleteDisabled')
                 ELSE
                  decode((CASE
                           WHEN templatesvleo.mls_language = xdolobseo1.language AND
                                templatesvleo.mls_territory = xdolobseo1.territory THEN
                            'Y'
                           ELSE
                            'N'
                         END),
                         'Y',
                         'MLSBaseDeleteEnabled',
                         'DeleteEnabled')
               END) AS delete_switcher,
               (CASE
                 WHEN templatesvleo.template_status = 'L' THEN
                  decode((CASE
                           WHEN templatesvleo.mls_language = xdolobseo1.language AND
                                templatesvleo.mls_territory = xdolobseo1.territory THEN
                            'Y'
                           ELSE
                            'N'
                         END),
                         'Y',
                         'MLSBaseUpdateDisabled',
                         'UpdateDisabled')
                 ELSE
                  decode((CASE
                           WHEN templatesvleo.mls_language = xdolobseo1.language AND
                                templatesvleo.mls_territory = xdolobseo1.territory THEN
                            'Y'
                           ELSE
                            'N'
                         END),
                         'Y',
                         'MLSBaseUpdateEnabled',
                         'UpdateEnabled')
               END) AS update_switcher,
               (CASE
                 WHEN templatesvleo.mls_language = xdolobseo1.language AND
                      templatesvleo.mls_territory = xdolobseo1.territory THEN
                  'Y'
                 ELSE
                  'N'
               END) AS mls_template
          FROM xdo_templates_vl     templatesvleo,
               xdo_lobs             xdolobseo1,
               xdo_lobs             xdolobseo2,
               fnd_iso_languages_vl fnd_iso_lang,
               fnd_territories_vl   fnd_territories
         WHERE templatesvleo.application_short_name =
               xdolobseo1.application_short_name
           AND templatesvleo.template_code = xdolobseo1.lob_code
           AND ((xdolobseo1.lob_type = 'TEMPLATE' AND
               xdolobseo1.xdo_file_type != 'RTF' AND
               xdolobseo1.xdo_file_type = templatesvleo.template_type_code) OR
               (xdolobseo1.lob_type = 'TEMPLATE_SOURCE' AND
               xdolobseo1.xdo_file_type IN
               ('RTF', 'RTF-ETEXT', 'RTF-EFTIN')))
           AND templatesvleo.ds_app_short_name =
               xdolobseo2.application_short_name(+)
           AND templatesvleo.data_source_code = xdolobseo2.lob_code(+)
           AND xdolobseo2.lob_type(+) = 'XML_SAMPLE'
           AND lower(xdolobseo1.language) = fnd_iso_lang.iso_language_2(+)
           AND fnd_territories.territory_code(+) = xdolobseo1.territory) qrslt
 WHERE (template_code = 'BHSC_DEMO_XML_RPT')