VIEW: SYS.DBA_ADVISOR_FDG_BREAKDOWN

Source

View Text - Preformatted

select a.task_id as task_id,
             a.finding_id as finding_id,
             a.instance_number as instance_number,
             f.impact as impact,
             a.perc_impact as perc_impact,
             a.exec_name as execution_name
      from  wri$_adv_inst_fdg a, dba_advisor_findings f
      where a.task_id = f.task_id
        and a.finding_id = f.finding_id

View Text - HTML Formatted

SELECT A.TASK_ID AS TASK_ID
, A.FINDING_ID AS FINDING_ID
, A.INSTANCE_NUMBER AS INSTANCE_NUMBER
, F.IMPACT AS IMPACT
, A.PERC_IMPACT AS PERC_IMPACT
, A.EXEC_NAME AS EXECUTION_NAME
FROM WRI$_ADV_INST_FDG A
, DBA_ADVISOR_FINDINGS F
WHERE A.TASK_ID = F.TASK_ID
AND A.FINDING_ID = F.FINDING_ID