select
  inst_id,                                 -- INST_ID NUMBER
  birid,                                   -- RECID NUMBER
  bistm,                                   -- STAMP NUMBER
  bibss,                                   -- SET_STAMP NUMBER
  bibsc,                                   -- SET_COUNT NUMBER
  to_date(                                 -- MODIFICATION_TIME DATE
    bimdt, 'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  bifsz,                                   -- BYTES NUMBER
  to_date(                                 -- COMPLETION_TIME DATE
    bitsm, 'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  bidun                                    -- DB_UNIQUE_NAME VARCHAR2(30)
from
  x$kccbi
where
  bitand(biflg, 1) != 1