VIEW: SYS.USER_ADVISOR_TEMPLATES

Source

View Text - Preformatted

select a.id as task_id,
             a.name as task_name,
             a.description as description,
             a.advisor_name as advisor_name,
             a.ctime as created,
             a.mtime as last_modified,
             a.source as source,
             decode(bitand(a.property,1), 1, 'TRUE', 'FALSE') as read_only
      from wri$_adv_tasks a
      where a.owner# = userenv('SCHEMAID')
        and bitand(a.property,6) = 6

View Text - HTML Formatted

SELECT A.ID AS TASK_ID
, A.NAME AS TASK_NAME
, A.DESCRIPTION AS DESCRIPTION
, A.ADVISOR_NAME AS ADVISOR_NAME
, A.CTIME AS CREATED
, A.MTIME AS LAST_MODIFIED
, A.SOURCE AS SOURCE
, DECODE(BITAND(A.PROPERTY
, 1)
, 1
, 'TRUE'
, 'FALSE') AS READ_ONLY
FROM WRI$_ADV_TASKS A
WHERE A.OWNER# = USERENV('SCHEMAID')
AND BITAND(A.PROPERTY
, 6) = 6