SYS.DBMS_FEATURE_SEGADV_USER dependencies on DBA_ADVISOR_TASKS

Line 32: FROM dba_advisor_tasks task,

28:
29: -- total # of recommendations and total potential space saving
30: SELECT count(task.task_id), NVL(sum(msg.p3),0)
31: INTO total_recs, total_space_saving
32: FROM dba_advisor_tasks task,
33: sys.wri$_adv_findings fin,
34: sys.wri$_adv_recommendations rec,
35: sys.wri$_adv_message_groups msg
36: WHERE task.advisor_name = 'Segment Advisor' AND