VIEW: SYS.USER_ADVISOR_DIR_TASK_INST

Source

View Text - Preformatted

select a.dir_id as directive_id,
             a.inst_id as instance_id,
             a.name as instance_name,
             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
      where a.task_id = b.id
        and b.owner# = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT A.DIR_ID AS DIRECTIVE_ID
, A.INST_ID AS INSTANCE_ID
, A.NAME AS INSTANCE_NAME
, 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
WHERE A.TASK_ID = B.ID
AND B.OWNER# = USERENV('SCHEMAID')