VIEW: SYS.DBA_ADVISOR_RECOMMENDATIONS

Source

View Text - Preformatted

select b.owner_name as owner,
            a.id as rec_id,
            a.task_id as task_id,
            b.name as task_name,
            a.exec_name as execution_name,
            a.finding_id as finding_id,
            a.type,
            a.rank as rank,
            a.parent_recs as parent_rec_ids,
            dbms_advisor.format_message_group(a.benefit_msg_id) as benefit_type,
            a.benefit_val as benefit,
            decode(annotation, 1, 'ACCEPT',
                               2, 'REJECT',
                               3, 'IGNORE',
                               4, 'IMPLEMENTED') as annotation_status,
            a.flags as flags,
            nvl(a.filtered, 'N') as filtered
     from wri$_adv_recommendations a, wri$_adv_tasks b
     where a.task_id = b.id and
          bitand(b.property,6) = 4

View Text - HTML Formatted

SELECT B.OWNER_NAME AS OWNER
, A.ID AS REC_ID
, A.TASK_ID AS TASK_ID
, B.NAME AS TASK_NAME
, A.EXEC_NAME AS EXECUTION_NAME
, A.FINDING_ID AS FINDING_ID
, A.TYPE
, A.RANK AS RANK
, A.PARENT_RECS AS PARENT_REC_IDS
, DBMS_ADVISOR.FORMAT_MESSAGE_GROUP(A.BENEFIT_MSG_ID) AS BENEFIT_TYPE
, A.BENEFIT_VAL AS BENEFIT
, DECODE(ANNOTATION
, 1
, 'ACCEPT'
, 2
, 'REJECT'
, 3
, 'IGNORE'
, 4
, 'IMPLEMENTED') AS ANNOTATION_STATUS
, A.FLAGS AS FLAGS
, NVL(A.FILTERED
, 'N') AS FILTERED
FROM WRI$_ADV_RECOMMENDATIONS A
, WRI$_ADV_TASKS B
WHERE A.TASK_ID = B.ID AND BITAND(B.PROPERTY
, 6) = 4