VIEW: SYS.DBA_APPLY_EXECUTE

Source

View Text - Preformatted

select r.rule_owner, r.rule_name,
  decode(sys.anydata.AccessVarchar2(ctx.nvn_value), 'NO', 'NO', NULL)
from DBA_RULES r, table(r.rule_action_context.actx_list) ctx
where ctx.nvn_name = 'APPLY$_EXECUTE'

View Text - HTML Formatted

SELECT R.RULE_OWNER
, R.RULE_NAME
, DECODE(SYS.ANYDATA.ACCESSVARCHAR2(CTX.NVN_VALUE)
, 'NO'
, 'NO'
, NULL) FROM DBA_RULES R
, TABLE(R.RULE_ACTION_CONTEXT.ACTX_LIST) CTX WHERE CTX.NVN_NAME = 'APPLY$_EXECUTE'