CAST Engineering Dashboard - Information - Get list of reports defined on central site and their parameters

SELECT   vr.name          AS "Report Name"          ,
         vrs.section_name AS "Section Name"         ,
         vrs.section_id   AS "Section Internal Type",
         (SELECT vpt.value
         FROM    viewer_parameters vpt,
                 viewer_parameters vp
         WHERE   vpt.component_id = 'ENGLISH'
         AND     vpt.id        LIKE vp.value
         AND     vp.id            = 'PANEL_REPORTING_CART'
         AND     vp.component_id  = vrs.section_id
         )      AS "Section External Type",
         vrp.id AS "Parameter ID"         ,
         CASE vrp.id
                  WHEN 'object'
                  THEN
                           (SELECT ob.object_name
                           FROM    dss_objects ob
                           WHERE   TO_CHAR(ob.object_id) = vrp.value
                           )
                  WHEN 'system'
                  THEN
                           (SELECT ob.object_name
                           FROM    dss_objects ob
                           WHERE   TO_CHAR(ob.object_id) = vrp.value
                           )
                  WHEN 'bcrit'
                  THEN
                           (SELECT dmt.metric_name
                           FROM    dss_metric_types dmt
                           WHERE   TO_CHAR(dmt.metric_id) = vrp.value
                           )
                  WHEN 'tcrit'
                  THEN
                           (SELECT dmt.metric_name
                           FROM    dss_metric_types dmt
                           WHERE   TO_CHAR(dmt.metric_id) = vrp.value
                           )
                  WHEN 'metric'
                  THEN
                           (SELECT dmt.metric_name
                           FROM    dss_metric_types dmt
                           WHERE   TO_CHAR(dmt.metric_id) = vrp.value
                           )
                  ELSE vrp.value
         END       AS "Parameter Translated Value",
         vrp.value AS "Parameter Raw Value"
FROM     viewer_report_parameters vrp,
         viewer_report_sections vrs  ,
         viewer_reports vr
WHERE    vrp.report_section_id = vrs.id
AND      vrs.report_id         = vr.id
ORDER BY vr.name,
         vrs.section_offset