VIEW: SYS.ALL_AUDIT_POLICY_COLUMNS

Source

View Text - Preformatted

(select d.OBJECT_SCHEMA, d.OBJECT_NAME,
          d.POLICY_NAME, d.POLICY_COLUMN
from DBA_AUDIT_POLICY_COLUMNS d, ALL_TABLES t
where d.OBJECT_SCHEMA = t.OWNER AND d.OBJECT_NAME = t.TABLE_NAME)
union
(select d.OBJECT_SCHEMA, d.OBJECT_NAME,
          d.POLICY_NAME, d.POLICY_COLUMN
from DBA_AUDIT_POLICY_COLUMNS d, ALL_VIEWS v
where d.OBJECT_SCHEMA = v.OWNER AND d.OBJECT_NAME = v.VIEW_NAME)

View Text - HTML Formatted

(SELECT D.OBJECT_SCHEMA
, D.OBJECT_NAME
, D.POLICY_NAME
, D.POLICY_COLUMN FROM DBA_AUDIT_POLICY_COLUMNS D
, ALL_TABLES T WHERE D.OBJECT_SCHEMA = T.OWNER
AND D.OBJECT_NAME = T.TABLE_NAME) UNION (SELECT D.OBJECT_SCHEMA
, D.OBJECT_NAME
, D.POLICY_NAME
, D.POLICY_COLUMN FROM DBA_AUDIT_POLICY_COLUMNS D
, ALL_VIEWS V WHERE D.OBJECT_SCHEMA = V.OWNER
AND D.OBJECT_NAME = V.VIEW_NAME)