VIEW: SYS.DBA_ADDM_TASK_DIRECTIVES

Source

View Text - Preformatted

SELECT i.TASK_ID as TASK_ID,
             i.TASK_NAME as TASK_NAME,
             i.USERNAME as USERNAME,
             i.SEQ_ID as SEQ_ID,
             i.INSTANCE_NAME as INSTANCE_NAME,
             d.DIRECTIVE_NAME as DIRECTIVE_NAME,
             prvt_hdm.describe_directive(d.DIRECTIVE_NAME, i.data)
                 as DESCRIPTION
      FROM   dba_advisor_dir_task_inst i,
             dba_advisor_dir_definitions d
      WHERE  i.DIRECTIVE_ID = d.ID
        AND  d.ADVISOR_ID = 1

View Text - HTML Formatted

SELECT I.TASK_ID AS TASK_ID
, I.TASK_NAME AS TASK_NAME
, I.USERNAME AS USERNAME
, I.SEQ_ID AS SEQ_ID
, I.INSTANCE_NAME AS INSTANCE_NAME
, D.DIRECTIVE_NAME AS DIRECTIVE_NAME
, PRVT_HDM.DESCRIBE_DIRECTIVE(D.DIRECTIVE_NAME
, I.DATA) AS DESCRIPTION
FROM DBA_ADVISOR_DIR_TASK_INST I
, DBA_ADVISOR_DIR_DEFINITIONS D
WHERE I.DIRECTIVE_ID = D.ID
AND D.ADVISOR_ID = 1