select
  inst_id,                                 -- INST_ID NUMBER
  kwqpdsqs,                                -- SRC_QUEUE_SCHEMA VARCHAR2(30)
  kwqpdsqn,                                -- SRC_QUEUE_NAME VARCHAR2(30)
  kwqpddbn,                                -- SRC_DBNAME VARCHAR2(128)
  decode(                                  -- DST_QUEUE_SCHEMA VARCHAR2(30)
    bitand(max(kwqpdflg), 1), 1, max(kwqpddqs), null),
  decode(                                  -- DST_QUEUE_NAME VARCHAR2(30)
    bitand(max(kwqpdflg), 1), 1, max(kwqpddqn), null),
  min(kwqpdtim),                           -- STARTUP_TIME DATE
  decode(                                  -- HIGH_WATER_MARK NUMBER
    bitand(max(kwqpdflg), 2), 0, max(kwqpdhwm), 0),
  min(kwqpdack),                           -- ACKNOWLEDGEMENT NUMBER
  max(kwqpdhwm),                           -- LAST_RECEIVED_MSG NUMBER
  max(kwqpdmsg),                           -- TOTAL_MSGS NUMBER
  min(kwqpdupc)/10000,                     -- ELAPSED_UNPICKLE_TIME NUMBER
  min(kwqpdrul)/10000,                     -- ELAPSED_RULE_TIME NUMBER
  (min(kwqpdenq) - min(kwqpdupc) - min(kwqpdrul))/10000,-- ELAPSED_ENQUEUE_TIME NUMBER
  kwqpdsid,                                -- SESSION_ID NUMBER
  kwqpdser,                                -- SERIAL# NUMBER
  kwqpdospid,                              -- SPID VARCHAR2(24)
  kwqpdprpn,                               -- PROPAGATION_NAME VARCHAR2(30)
  decode(                                  -- STATE VARCHAR2(43)
    bitand(max(kwqpdflg), 4), 4, decode(max(kwqpdstate), 0, 'Initializing', 1, 'Sending unapplied txns', 2, 'Waiting for message 
    from
      client',
      3,
      'Receiving LCRs',
      4,
      'Evaluating rules',
      5,
      'Enqueueing LCRS',
      6,
      'Waiting for memory',
      7,
      'Waiting for apply to read',
      8,
      'Waiting for message
    from
      propagation sender',
      null), 'Normal'), 
  max(kwqpdlrmpos),                        -- LAST_RECEIVED_MSG_POSITION RAW(64)
  min(kwqpdackpos)                         -- ACKNOWLEDGEMENT_POSITION RAW(64)
from
  x$kwqpd
group by
  inst_id,
  kwqpdsqs,
  kwqpdsqn,
  kwqpddbn,
  kwqpdsid,
  kwqpdser,
  kwqpdospid,
  kwqpdprpn,
  kwqpdstate