VIEW: SYS.D$PENDING_XATRANS$

Source

View Text - Preformatted

(SELECT global_tran_fmt, global_foreign_id, branch_id
   FROM   sys.pending_trans$ tran, sys.pending_sessions$ sess
   WHERE  tran.local_tran_id = sess.local_tran_id
     AND    tran.state != 'collecting'
     AND    BITAND(TO_NUMBER(tran.session_vector),
                   POWER(2, (sess.session_id - 1))) = sess.session_id)

View Text - HTML Formatted

(SELECT GLOBAL_TRAN_FMT
, GLOBAL_FOREIGN_ID
, BRANCH_ID
FROM SYS.PENDING_TRANS$ TRAN
, SYS.PENDING_SESSIONS$ SESS
WHERE TRAN.LOCAL_TRAN_ID = SESS.LOCAL_TRAN_ID
AND TRAN.STATE != 'COLLECTING'
AND BITAND(TO_NUMBER(TRAN.SESSION_VECTOR)
, POWER(2
, (SESS.SESSION_ID - 1))) = SESS.SESSION_ID)