VIEW: SYS.KU$_RADM_POLICY_VIEW

Source

View Text - Preformatted

select '1','0',
         r.obj#,
         value(o),
         r.pname,
         r.pexpr,
         r.enable_flag,
         cast( multiset(select * from ku$_radm_mc_view m
                        where m.obj_num = r.obj#
                       ) as ku$_radm_mc_list_t
             )
  from sys.radm$ r, ku$_schemaobj_view o
  where r.obj# = o.obj_num

View Text - HTML Formatted

SELECT '1'
, '0'
, R.OBJ#
, VALUE(O)
, R.PNAME
, R.PEXPR
, R.ENABLE_FLAG
, CAST( MULTISET(SELECT *
FROM KU$_RADM_MC_VIEW M
WHERE M.OBJ_NUM = R.OBJ# ) AS KU$_RADM_MC_LIST_T )
FROM SYS.RADM$ R
, KU$_SCHEMAOBJ_VIEW O
WHERE R.OBJ# = O.OBJ_NUM