VIEW: SYS.DEFCALLDEST

Source

View Text - Preformatted

select C1.step_no callno, C.enq_tid deferred_tran_id,
         D.dblink
    from system.def$_aqcall C, system.def$_aqcall C1,
         system.def$_destination D
    where C.cscn IS NOT NULL
      and C1.enq_tid = c.enq_tid
      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 (( C1.recipient_key = 0
            AND EXISTS (
              select NULL
                from system.def$_calldest CD
                where  CD.enq_tid=C1.enq_tid
                  AND  CD.step_no=C1.step_no
                  AND  CD.dblink = D.dblink
                  AND  CD.catchup = D.catchup))
          OR ( C1.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 = C1.recipient_key
                  AND  ((P.delivery_order is NULL) OR
                        (P.delivery_order < C.cscn)))))

View Text - HTML Formatted

SELECT C1.STEP_NO CALLNO
, C.ENQ_TID DEFERRED_TRAN_ID
, D.DBLINK
FROM SYSTEM.DEF$_AQCALL C
, SYSTEM.DEF$_AQCALL C1
, SYSTEM.DEF$_DESTINATION D
WHERE C.CSCN IS NOT NULL
AND C1.ENQ_TID = C.ENQ_TID
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 (( C1.RECIPIENT_KEY = 0
AND EXISTS ( SELECT NULL
FROM SYSTEM.DEF$_CALLDEST CD
WHERE CD.ENQ_TID=C1.ENQ_TID
AND CD.STEP_NO=C1.STEP_NO
AND CD.DBLINK = D.DBLINK
AND CD.CATCHUP = D.CATCHUP)) OR ( C1.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 = C1.RECIPIENT_KEY
AND ((P.DELIVERY_ORDER IS NULL) OR (P.DELIVERY_ORDER < C.CSCN)))))