Oracle ERP Professionals

SQL Query to get the RTF files from database 

(XML Publisher Reports)

SELECT XTT.TEMPLATE_NAME "TEMPLATE NAME", 

       XTB.TEMPLATE_CODE "TEMPLATE CODE",

       FAT.APPLICATION_NAME "APPLICATION NAME",

       XDDT.DATA_SOURCE_NAME "DATA DEFINITION",

       XTB.TEMPLATE_TYPE_CODE "TEMPLATE TYPE",

       XTB.DEFAULT_LANGUAGE "LANGUAGE", 

       XTB.DEFAULT_TERRITORY "TERRITORY",

       XL.FILE_NAME "FILE NAME", XL.FILE_DATA "FILE"

FROM XDO_TEMPLATES_TL XTT,

       XDO_TEMPLATES_B XTB,

       FND_APPLICATION_TL FAT,

       XDO_DS_DEFINITIONS_TL XDDT,

       XDO_LOBS XL

WHERE (XTT.TEMPLATE_NAME LIKE '%TEMPLATE NAME%')

   AND XTT.LANGUAGE = 'US'

   AND XTB.TEMPLATE_CODE = XTT.TEMPLATE_CODE

   AND FAT.APPLICATION_ID = XTB.APPLICATION_ID

   AND FAT.LANGUAGE = 'US'

   AND XDDT.DATA_SOURCE_CODE = XTB.DATA_SOURCE_CODE

   AND XDDT.LANGUAGE = 'US'

   AND XL.LOB_CODE = XTB.TEMPLATE_CODE

   AND NVL (XL.PROGRAM, 'X') <> 'RTF2XSLPARSER 5.6.3'

   AND XL.LANGUAGE = XTB.DEFAULT_LANGUAGE

   AND XL.TERRITORY = XTB.DEFAULT_TERRITORY