select
  inst_id,                                 -- INST_ID NUMBER
  decode(                                  -- OWNERID NUMBER
    kglobt00,1,kglobt17,null),
  kglnaobj,                                -- NAME VARCHAR2(1000)
  decode(                                  -- TYPE VARCHAR2(7)
    kglobt00,1,'PRIVATE','PUBLIC'),
  kglobhs0+kglobhs1+kglobhs2+kglobhs3+kglobhs4+kglobhs5+kglobhs6 -- PIPE_SIZE NUMBER
from
  x$kglob
where
  kglhdnsp=7 and kglobsta != 0