VIEW: SYS.D$XATRANS$

Source

View Text - Preformatted

(((SELECT k2gtifmt, k2gtitid_ext, k2gtibid
   FROM x$k2gte2
   WHERE  k2gterct=k2gtdpct)
 MINUS
  SELECT global_tran_fmt, global_foreign_id, branch_id
   FROM   d$pending_xatrans$)
UNION
 SELECT global_tran_fmt, global_foreign_id, branch_id
   FROM   d$pending_xatrans$)

View Text - HTML Formatted

(((SELECT K2GTIFMT
, K2GTITID_EXT
, K2GTIBID
FROM X$K2GTE2
WHERE K2GTERCT=K2GTDPCT) MINUS SELECT GLOBAL_TRAN_FMT
, GLOBAL_FOREIGN_ID
, BRANCH_ID
FROM D$PENDING_XATRANS$) UNION SELECT GLOBAL_TRAN_FMT
, GLOBAL_FOREIGN_ID
, BRANCH_ID
FROM D$PENDING_XATRANS$)