VIEW: SYS.REPORT_COMPONENTS

Source

View Text - Preformatted

SELECT c.id component_id, c.name component_name,
            c.description component_description,
            r.id report_id, r.name report_name,
            r.description report_description,
            f.name schema_filename,
            XMLType(f.data) schema_data
     FROM   wri$_rept_components c,
            wri$_rept_reports r,
            wri$_emx_files f
     WHERE  c.id = r.component_id AND
            r.schema_id = f.id (+)

View Text - HTML Formatted

SELECT C.ID COMPONENT_ID
, C.NAME COMPONENT_NAME
, C.DESCRIPTION COMPONENT_DESCRIPTION
, R.ID REPORT_ID
, R.NAME REPORT_NAME
, R.DESCRIPTION REPORT_DESCRIPTION
, F.NAME SCHEMA_FILENAME
, XMLTYPE(F.DATA) SCHEMA_DATA
FROM WRI$_REPT_COMPONENTS C
, WRI$_REPT_REPORTS R
, WRI$_EMX_FILES F
WHERE C.ID = R.COMPONENT_ID AND R.SCHEMA_ID = F.ID (+)