VIEW: SYS.DBA_ADVISOR_DIR_TASK_INST

Source

View Text - Preformatted

select a.dir_id as directive_id,
             a.inst_id as seq_id,
             a.name as instance_name,
             d.name as username,
             a.task_id as task_id,
             b.name as task_name,
             a.data as data
      from wri$_adv_directive_instances a,wri$_adv_tasks b, user$ d
      where a.task_id = b.id
        and d.user# = b.owner#

View Text - HTML Formatted

SELECT A.DIR_ID AS DIRECTIVE_ID
, A.INST_ID AS SEQ_ID
, A.NAME AS INSTANCE_NAME
, D.NAME AS USERNAME
, A.TASK_ID AS TASK_ID
, B.NAME AS TASK_NAME
, A.DATA AS DATA
FROM WRI$_ADV_DIRECTIVE_INSTANCES A
, WRI$_ADV_TASKS B
, USER$ D
WHERE A.TASK_ID = B.ID
AND D.USER# = B.OWNER#