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.type, fo.content_type, fo.text_linesize,
          f.name xslt_filename
   FROM   wri$_rept_components c, wri$_rept_reports r,
          wri$_emx_files f, wri$_rept_formats fo
   WHERE  c.id = r.component_id AND
          fo.report_id = r.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.TYPE
, FO.CONTENT_TYPE
, FO.TEXT_LINESIZE
, F.NAME XSLT_FILENAME
FROM WRI$_REPT_COMPONENTS C
, WRI$_REPT_REPORTS R
, WRI$_EMX_FILES F
, WRI$_REPT_FORMATS FO
WHERE C.ID = R.COMPONENT_ID AND FO.REPORT_ID = R.ID AND FO.STYLESHEET_ID = F.ID (+)