VIEW: SYS.KU$_AUDIT_POLICY_ENABLE_VIEW

Source

View Text - Preformatted

select
  ng.policy#,
  value(o),
  decode(ng.user#, -1, NULL,
        (select u.name from user$ u where  u.user#=ng.user# )) userid,
  ng."WHEN",
  ng."HOW"
from sys.audit_ng$ ng, ku$_schemaobj_view o
where o.obj_num=ng.policy#

View Text - HTML Formatted

SELECT NG.POLICY#
, VALUE(O)
, DECODE(NG.USER#
, -1
, NULL
, (SELECT U.NAME
FROM USER$ U
WHERE U.USER#=NG.USER# )) USERID
, NG."WHEN"
, NG."HOW" FROM SYS.AUDIT_NG$ NG
, KU$_SCHEMAOBJ_VIEW O WHERE O.OBJ_NUM=NG.POLICY#