select
  a.inst_id,                               -- INST_ID NUMBER
  a.addr,                                  -- SADDR RAW(8)
  a.indx,                                  -- SID NUMBER
  a.ksuseser,                              -- SERIAL# NUMBER
  decode(                                  -- QCSID NUMBER
    b.kxfpdpqcsid,NULL,a.indx,b.kxfpdpqcsid),
  b.kxfpdpqcser,                           -- QCSERIAL# NUMBER
  b.kxfpdpcin,                             -- QCINST_ID NUMBER
  b.kxfpdpsvgrp,                           -- SERVER_GROUP NUMBER
  b.kxfpdpsvset,                           -- SERVER_SET NUMBER
  b.kxfpdpsvnum,                           -- SERVER# NUMBER
  b.kxfpdpadg,                             -- DEGREE NUMBER
  b.kxfpdprdg                              -- REQ_DEGREE NUMBER
from
  x$ksuse a,
  x$kxfpdp b
where
  bitand(a.ksspaflg,1)!=0 and bitand(a.ksuseflg,1)!=0 and a.ksuseqcsid > 0 and a.ksusepro = b.kxfpdppro(+)