select
  le.inst_id,                              -- INST_ID NUMBER
  le.lenum,                                -- GROUP# NUMBER
  le.lethr,                                -- THREAD# NUMBER
  le.leseq,                                -- SEQUENCE# NUMBER
  le.lesiz*le.lebsz,                       -- BYTES NUMBER
  le.lebsz,                                -- BLOCKSIZE NUMBER
  ledup,                                   -- MEMBERS NUMBER
  decode(                                  -- ARCHIVED VARCHAR2(3)
    bitand(le.leflg,1),0,'NO','YES'),
  decode(                                  -- STATUS VARCHAR2(16)
    bitand(le.leflg,24), 8, 'CURRENT', 16,'CLEARING', 24,'CLEARING_CURRENT', decode(sign(leseq),0,'UNUSED', decode(sign((to_number(rt.rtckp_scn)-to_number(le.lenxs))* bitand(rt.rtsta,2)),-1,'ACTIVE','INACTIVE'))),
  to_number(le.lelos),                     -- FIRST_CHANGE# NUMBER
  to_date(                                 -- FIRST_TIME DATE
    le.lelot,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_number(le.lenxs),                     -- NEXT_CHANGE# NUMBER
  to_date(                                 -- NEXT_TIME DATE
    le.lenxt,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian') 
from
  x$kccle le,
  x$kccrt rt
where
  le.ledup!=0 and le.lethr=rt.rtnum and le.inst_id = rt.inst_id