select
  inst_id,                                 -- INST_ID NUMBER
  sid_knst,                                -- SID NUMBER
  serial_knst,                             -- SERIAL# NUMBER
  decode(                                  -- NAME VARCHAR2(71)
    type_knst, 3, 'Replication Parallel Prop Slave'|| slavenum_knstrpp, 4, 'Replication Parallel Prop Coordinator'),
  dblink_knstrpp,                          -- DBLINK VARCHAR2(128)
  decode(                                  -- STATE VARCHAR2(12)
    state_knstrpp, 0, NULL, 1, 'WAIT', 2, 'SLEEP', 3, 'PUSH', 4, 'PURGE' , 5, 'CREATE ERROR', 6, 'SCHEDULE TXN'),
  decode(                                  -- XID VARCHAR2(22)
    type_knst, 4, NULL, xid_knstrpp),
  sequence_knstrpp                         -- SEQUENCE NUMBER
from
  x$knstrpp x
where
  type_knst in (3,4) and exists (
  select
    1
  from
    v$session s
  where
    s.sid=x.sid_knst and s.serial#=x.serial_knst)