VIEW: SYS._DEFTRANDEST

Source

View Text - Preformatted

select C.enq_tid deferred_tran_id, C.cscn delivery_order, D.dblink,
         D.catchup
    from system.def$_aqcall C, system.def$_destination D
    where C.cscn IS NOT NULL
      AND C.cscn >= D.last_delivered
      AND (C.cscn > D.last_delivered
          OR
          (C.cscn = D.last_delivered
           AND (C.enq_tid > D.last_enq_tid)))
      and (( C.recipient_key = 0
            AND EXISTS (
              select /*+ index(CD def$_calldest_primary) */ NULL
                from system.def$_calldest CD
                where  CD.enq_tid=C.enq_tid
                  AND  CD.dblink = D.dblink
                  AND  CD.catchup = D.catchup ))
          OR ( C.recipient_key > 0
            AND ( (EXISTS (
                     SELECT NULL
                       FROM system.repcat$_repprop p
                         WHERE D.dblink = P.dblink
                           AND D.catchup = P.extension_id
                           AND P.how = 1
                           AND P.recipient_key = C.recipient_key
                           AND ((P.delivery_order is NULL)
                              OR (P.delivery_order < C.cscn))))
               OR (EXISTS (
                     SELECT NULL
                       from system.def$_aqcall C2, system.repcat$_repprop P
                       WHERE C2.enq_tid=C.enq_tid
                         AND C2.cscn IS NULL
                         AND D.dblink = P.dblink
                         AND D.catchup = P.extension_id
                         AND P.how = 1
                         AND P.recipient_key = C2.recipient_key
                         AND ((P.delivery_order is NULL) OR
                              (P.delivery_order < C.cscn)))))))

View Text - HTML Formatted

SELECT C.ENQ_TID DEFERRED_TRAN_ID
, C.CSCN DELIVERY_ORDER
, D.DBLINK
, D.CATCHUP
FROM SYSTEM.DEF$_AQCALL C
, SYSTEM.DEF$_DESTINATION D
WHERE C.CSCN IS NOT NULL
AND C.CSCN >= D.LAST_DELIVERED
AND (C.CSCN > D.LAST_DELIVERED OR (C.CSCN = D.LAST_DELIVERED
AND (C.ENQ_TID > D.LAST_ENQ_TID)))
AND (( C.RECIPIENT_KEY = 0
AND EXISTS ( SELECT /*+ INDEX(CD DEF$_CALLDEST_PRIMARY) */ NULL
FROM SYSTEM.DEF$_CALLDEST CD
WHERE CD.ENQ_TID=C.ENQ_TID
AND CD.DBLINK = D.DBLINK
AND CD.CATCHUP = D.CATCHUP )) OR ( C.RECIPIENT_KEY > 0
AND ( (EXISTS ( SELECT NULL
FROM SYSTEM.REPCAT$_REPPROP P
WHERE D.DBLINK = P.DBLINK
AND D.CATCHUP = P.EXTENSION_ID
AND P.HOW = 1
AND P.RECIPIENT_KEY = C.RECIPIENT_KEY
AND ((P.DELIVERY_ORDER IS NULL) OR (P.DELIVERY_ORDER < C.CSCN)))) OR (EXISTS ( SELECT NULL
FROM SYSTEM.DEF$_AQCALL C2
, SYSTEM.REPCAT$_REPPROP P
WHERE C2.ENQ_TID=C.ENQ_TID
AND C2.CSCN IS NULL
AND D.DBLINK = P.DBLINK
AND D.CATCHUP = P.EXTENSION_ID
AND P.HOW = 1
AND P.RECIPIENT_KEY = C2.RECIPIENT_KEY
AND ((P.DELIVERY_ORDER IS NULL) OR (P.DELIVERY_ORDER < C.CSCN)))))))