VIEW: SYS.ALL_PROPAGATION

Source

View Text - Preformatted

SELECT p."PROPAGATION_NAME",p."SOURCE_QUEUE_OWNER",p."SOURCE_QUEUE_NAME",p."DESTINATION_QUEUE_OWNER",p."DESTINATION_QUEUE_NAME",p."DESTINATION_DBLINK",p."RULE_SET_OWNER",p."RULE_SET_NAME",p."NEGATIVE_RULE_SET_OWNER",p."NEGATIVE_RULE_SET_NAME",p."QUEUE_TO_QUEUE",p."STATUS",p."ERROR_MESSAGE",p."ERROR_DATE",p."ORIGINAL_PROPAGATION_NAME",p."ORIGINAL_SOURCE_QUEUE_OWNER",p."ORIGINAL_SOURCE_QUEUE_NAME",p."ACKED_SCN",p."AUTO_MERGE_THRESHOLD"
FROM   dba_propagation p, all_queues q
WHERE p.source_queue_owner = q.owner
   AND p.source_queue_name = q.name
   AND ((p.rule_set_owner IS NULL and p.rule_set_name IS NULL) OR
        ((p.rule_set_owner, p.rule_set_name) IN
          (SELECT r.rule_set_owner, r.rule_set_name
             FROM all_rule_sets r)))
   AND ((p.negative_rule_set_owner IS NULL AND
         p.negative_rule_set_name IS NULL) OR
        ((p.negative_rule_set_owner, p.negative_rule_set_name) IN
          (SELECT r.rule_set_owner, r.rule_set_name
             FROM all_rule_sets r)))

View Text - HTML Formatted

SELECT P."PROPAGATION_NAME"
, P."SOURCE_QUEUE_OWNER"
, P."SOURCE_QUEUE_NAME"
, P."DESTINATION_QUEUE_OWNER"
, P."DESTINATION_QUEUE_NAME"
, P."DESTINATION_DBLINK"
, P."RULE_SET_OWNER"
, P."RULE_SET_NAME"
, P."NEGATIVE_RULE_SET_OWNER"
, P."NEGATIVE_RULE_SET_NAME"
, P."QUEUE_TO_QUEUE"
, P."STATUS"
, P."ERROR_MESSAGE"
, P."ERROR_DATE"
, P."ORIGINAL_PROPAGATION_NAME"
, P."ORIGINAL_SOURCE_QUEUE_OWNER"
, P."ORIGINAL_SOURCE_QUEUE_NAME"
, P."ACKED_SCN"
, P."AUTO_MERGE_THRESHOLD" FROM DBA_PROPAGATION P
, ALL_QUEUES Q WHERE P.SOURCE_QUEUE_OWNER = Q.OWNER
AND P.SOURCE_QUEUE_NAME = Q.NAME
AND ((P.RULE_SET_OWNER IS NULL
AND P.RULE_SET_NAME IS NULL) OR ((P.RULE_SET_OWNER
, P.RULE_SET_NAME) IN (SELECT R.RULE_SET_OWNER
, R.RULE_SET_NAME
FROM ALL_RULE_SETS R)))
AND ((P.NEGATIVE_RULE_SET_OWNER IS NULL AND P.NEGATIVE_RULE_SET_NAME IS NULL) OR ((P.NEGATIVE_RULE_SET_OWNER
, P.NEGATIVE_RULE_SET_NAME) IN (SELECT R.RULE_SET_OWNER
, R.RULE_SET_NAME
FROM ALL_RULE_SETS R)))