VIEW: SYS.KU$_TBS_ILM_POLICY_VIEW

Source

View Text - Preformatted

select t.ts#,t.name,
         cast( multiset(select * from ku$_ilm_policy_view2 p
                        where p.obj_num = t.ts#
                        order by p.policy_num
                        ) as ku$_ilm_policy_list_t
              )
 from ts$ t
 where exists (select 1 from ku$_ilm_policy_view2 p where p.obj_num = t.ts#)
   and (SYS_CONTEXT('USERENV','CURRENT_USERID') = 0
        OR EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT T.TS#
, T.NAME
, CAST( MULTISET(SELECT *
FROM KU$_ILM_POLICY_VIEW2 P
WHERE P.OBJ_NUM = T.TS# ORDER BY P.POLICY_NUM ) AS KU$_ILM_POLICY_LIST_T )
FROM TS$ T
WHERE EXISTS (SELECT 1
FROM KU$_ILM_POLICY_VIEW2 P
WHERE P.OBJ_NUM = T.TS#)
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 0 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))