VIEW: SYS.USER_ADVISOR_DIRECTIVES

Source

View Text - Preformatted

select a.task_id as task_id,
             b.name as task_name,
             a.src_task_id as source_task_id,
             a.id as directive_id,
             a.obj_owner as rec_obj_owner,
             a.obj_name as rec_obj_name,
             a.rec_id as rec_id,
             a.rec_action_id as rec_action_id,
             c.command_name as command,
             a.attr1 as attr1,
             a.attr2 as attr2,
             a.attr3 as attr3,
             a.attr4 as attr4,
             a.attr5 as attr5
      from wri$_adv_directives a, wri$_adv_tasks b,
           x$keacmdn c
      where a.task_id = b.id
        and a.command = c.indx
        and b.owner# = userenv('SCHEMAID')
        and bitand(b.property,6) = 4

View Text - HTML Formatted

SELECT A.TASK_ID AS TASK_ID
, B.NAME AS TASK_NAME
, A.SRC_TASK_ID AS SOURCE_TASK_ID
, A.ID AS DIRECTIVE_ID
, A.OBJ_OWNER AS REC_OBJ_OWNER
, A.OBJ_NAME AS REC_OBJ_NAME
, A.REC_ID AS REC_ID
, A.REC_ACTION_ID AS REC_ACTION_ID
, C.COMMAND_NAME AS COMMAND
, A.ATTR1 AS ATTR1
, A.ATTR2 AS ATTR2
, A.ATTR3 AS ATTR3
, A.ATTR4 AS ATTR4
, A.ATTR5 AS ATTR5
FROM WRI$_ADV_DIRECTIVES A
, WRI$_ADV_TASKS B
, X$KEACMDN C
WHERE A.TASK_ID = B.ID
AND A.COMMAND = C.INDX
AND B.OWNER# = USERENV('SCHEMAID')
AND BITAND(B.PROPERTY
, 6) = 4