select e."RULE_OWNER",e."RULE_NAME",e."EXECUTE_EVENT"
from dba_apply_execute e, ALL_RULES r
where e.rule_owner = r.rule_owner and e.rule_name = r.rule_name
View Text - HTML Formatted
SELECT E."RULE_OWNER" , E."RULE_NAME" , E."EXECUTE_EVENT"
FROM DBA_APPLY_EXECUTE E , ALL_RULES R
WHERE E.RULE_OWNER = R.RULE_OWNER AND E.RULE_NAME = R.RULE_NAME