VIEW: SYS.REPORT_FORMATS

Source

View Text - Preformatted

SELECT c.id component_id,
            c.name component_name,
            r.id report_id,
            r.name report_name,
            fo.name format_name,
            fo.description description,
            DECODE(fo.type, 1, 'XSLT',
                            2, 'Text',
                            3, 'Custom') type,
            f.name xslt_filename,
            XMLType(f.data) xslt_data,
            fo.text_linesize
     FROM   wri$_rept_components c,
            wri$_rept_reports    r,
            wri$_emx_files      f,
            wri$_rept_formats    fo
     WHERE  c.id = r.component_id AND
            r.id = fo.report_id AND
            fo.stylesheet_id = f.id(+)

View Text - HTML Formatted

SELECT C.ID COMPONENT_ID
, C.NAME COMPONENT_NAME
, R.ID REPORT_ID
, R.NAME REPORT_NAME
, FO.NAME FORMAT_NAME
, FO.DESCRIPTION DESCRIPTION
, DECODE(FO.TYPE
, 1
, 'XSLT'
, 2
, 'TEXT'
, 3
, 'CUSTOM') TYPE
, F.NAME XSLT_FILENAME
, XMLTYPE(F.DATA) XSLT_DATA
, FO.TEXT_LINESIZE
FROM WRI$_REPT_COMPONENTS C
, WRI$_REPT_REPORTS R
, WRI$_EMX_FILES F
, WRI$_REPT_FORMATS FO
WHERE C.ID = R.COMPONENT_ID AND R.ID = FO.REPORT_ID AND FO.STYLESHEET_ID = F.ID(+)