VIEW: SYS.ALL_APPLY_ENQUEUE

Source

View Text - Preformatted

select e."RULE_OWNER",e."RULE_NAME",e."DESTINATION_QUEUE_NAME"
from dba_apply_enqueue e, ALL_RULES r, ALL_QUEUES aq
where e.rule_owner = r.rule_owner and e.rule_name = r.rule_name
  and e.destination_queue_name = '"'||aq.owner||'"' ||'.'|| '"'||aq.name||'"'

View Text - HTML Formatted

SELECT E."RULE_OWNER"
, E."RULE_NAME"
, E."DESTINATION_QUEUE_NAME" FROM DBA_APPLY_ENQUEUE E
, ALL_RULES R
, ALL_QUEUES AQ WHERE E.RULE_OWNER = R.RULE_OWNER
AND E.RULE_NAME = R.RULE_NAME
AND E.DESTINATION_QUEUE_NAME = '"'||AQ.OWNER||'"' ||'.'|| '"'||AQ.NAME||'"'