select
  INST_ID,                                 -- INST_ID NUMBER
  TS#,                                     -- TS# NUMBER
  decode(                                  -- ENCRYPTIONALG VARCHAR2(7)
    ALG, 0, 'NONE', 1, '3DES168', 2, 'AES128', 3, 'AES192', 4, 'AES256'),
  decode(ENCTS, 0, 'NO', 'YES')            -- ENCRYPTEDTS VARCHAR2(3)
from
  X$KCBTEK
where
  ENCTS <> 0 and DROPPEDTS = 0