VIEW: SYS._DBA_STREAMS_RECOMMENDATIONS

Source

View Text - Preformatted

SELECT r.benefit_msg_id BENEFIT_ID,
       m.p1 BENEFIT_ARG1,
       m.p2 BENEFIT_ARG2,
       m.p3 BENEFIT_ARG3,
       m.p4 BENEFIT_ARG4,
       m.p5 BENEFIT_ARG5,
       t.advisor_name ADVISOR_TYPE,
       sysdate RUN_TIME
FROM wri$_adv_recommendations r, wri$_adv_tasks t,
     wri$_adv_message_groups m
WHERE r.task_id = t.id
  AND r.task_id = m.task_id
  AND r.benefit_msg_id = m.id
  -- wri$_adv_tasks.property 0x04 -> Task
  AND bitand(t.property,4) = 4

View Text - HTML Formatted

SELECT R.BENEFIT_MSG_ID BENEFIT_ID
, M.P1 BENEFIT_ARG1
, M.P2 BENEFIT_ARG2
, M.P3 BENEFIT_ARG3
, M.P4 BENEFIT_ARG4
, M.P5 BENEFIT_ARG5
, T.ADVISOR_NAME ADVISOR_TYPE
, SYSDATE RUN_TIME FROM WRI$_ADV_RECOMMENDATIONS R
, WRI$_ADV_TASKS T
, WRI$_ADV_MESSAGE_GROUPS M WHERE R.TASK_ID = T.ID
AND R.TASK_ID = M.TASK_ID
AND R.BENEFIT_MSG_ID = M.ID -- WRI$_ADV_TASKS.PROPERTY 0X04 -> TASK
AND BITAND(T.PROPERTY
, 4) = 4