VIEW: SYS.DBA_ADVISOR_SQLA_TABLES

Source

View Text - Preformatted

select d.owner_name as owner,
             b.task_id as task_id,
             d.name as task_name,
             b.sql_id as sql_id,
             b.stmt_id as stmt_id,
             b.table_owner  as table_owner,
             b.table_name as table_name
      from wri$_adv_sqla_tables b, wri$_adv_tasks d
      where d.id = b.task_id
        and d.advisor_id = 2

View Text - HTML Formatted

SELECT D.OWNER_NAME AS OWNER
, B.TASK_ID AS TASK_ID
, D.NAME AS TASK_NAME
, B.SQL_ID AS SQL_ID
, B.STMT_ID AS STMT_ID
, B.TABLE_OWNER AS TABLE_OWNER
, B.TABLE_NAME AS TABLE_NAME
FROM WRI$_ADV_SQLA_TABLES B
, WRI$_ADV_TASKS D
WHERE D.ID = B.TASK_ID
AND D.ADVISOR_ID = 2