VIEW: SYS.ALL_APPLY

Source

View Text - Preformatted

select a."APPLY_NAME",a."QUEUE_NAME",a."QUEUE_OWNER",a."APPLY_CAPTURED",a."RULE_SET_NAME",a."RULE_SET_OWNER",a."APPLY_USER",a."APPLY_DATABASE_LINK",a."APPLY_TAG",a."DDL_HANDLER",a."PRECOMMIT_HANDLER",a."MESSAGE_HANDLER",a."STATUS",a."MAX_APPLIED_MESSAGE_NUMBER",a."NEGATIVE_RULE_SET_NAME",a."NEGATIVE_RULE_SET_OWNER",a."STATUS_CHANGE_TIME",a."ERROR_NUMBER",a."ERROR_MESSAGE",a."MESSAGE_DELIVERY_MODE",a."PURPOSE"
  from dba_apply a, all_queues q
 where a.queue_name = q.name
   and a.queue_owner = q.owner
   and ((a.rule_set_owner is null and a.rule_set_name is null) or
        ((a.rule_set_owner, a.rule_set_name) in
          (select r.rule_set_owner, r.rule_set_name
             from all_rule_sets r)))
   and ((a.negative_rule_set_owner is null and
         a.negative_rule_set_name is null) or
        ((a.negative_rule_set_owner, a.negative_rule_set_name) in
          (select r.rule_set_owner, r.rule_set_name
             from all_rule_sets r)))

View Text - HTML Formatted

SELECT A."APPLY_NAME"
, A."QUEUE_NAME"
, A."QUEUE_OWNER"
, A."APPLY_CAPTURED"
, A."RULE_SET_NAME"
, A."RULE_SET_OWNER"
, A."APPLY_USER"
, A."APPLY_DATABASE_LINK"
, A."APPLY_TAG"
, A."DDL_HANDLER"
, A."PRECOMMIT_HANDLER"
, A."MESSAGE_HANDLER"
, A."STATUS"
, A."MAX_APPLIED_MESSAGE_NUMBER"
, A."NEGATIVE_RULE_SET_NAME"
, A."NEGATIVE_RULE_SET_OWNER"
, A."STATUS_CHANGE_TIME"
, A."ERROR_NUMBER"
, A."ERROR_MESSAGE"
, A."MESSAGE_DELIVERY_MODE"
, A."PURPOSE"
FROM DBA_APPLY A
, ALL_QUEUES Q
WHERE A.QUEUE_NAME = Q.NAME
AND A.QUEUE_OWNER = Q.OWNER
AND ((A.RULE_SET_OWNER IS NULL
AND A.RULE_SET_NAME IS NULL) OR ((A.RULE_SET_OWNER
, A.RULE_SET_NAME) IN (SELECT R.RULE_SET_OWNER
, R.RULE_SET_NAME
FROM ALL_RULE_SETS R)))
AND ((A.NEGATIVE_RULE_SET_OWNER IS NULL AND A.NEGATIVE_RULE_SET_NAME IS NULL) OR ((A.NEGATIVE_RULE_SET_OWNER
, A.NEGATIVE_RULE_SET_NAME) IN (SELECT R.RULE_SET_OWNER
, R.RULE_SET_NAME
FROM ALL_RULE_SETS R)))