select
  inst_id,                                 -- INST_ID NUMBER
  pcrid,                                   -- RECID NUMBER
  pcstm,                                   -- STAMP NUMBER
  pcdev,                                   -- DEVICE_TYPE VARCHAR2(17)
  pchdl,                                   -- HANDLE VARCHAR2(513)
  pccmt,                                   -- COMMENTS VARCHAR2(81)
  pcmdh,                                   -- MEDIA VARCHAR2(65)
  pcmpl,                                   -- MEDIA_POOL NUMBER
  pctag,                                   -- TAG VARCHAR2(32)
  decode(                                  -- STATUS VARCHAR2(1)
    bitand(pcflg, 1+2+4),0,'A',1,'D',2,'X',4,'U','?'),
  decode(                                  -- DELETED VARCHAR2(3)
    bitand(pcflg,1),1,'YES','NO'),
  pathp,                                   -- THREAD# NUMBER
  paseq,                                   -- SEQUENCE# NUMBER
  to_number(parls),                        -- RESETLOGS_CHANGE# NUMBER
  to_date(                                 -- RESETLOGS_TIME DATE
    parlc,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_number(palos),                        -- FIRST_CHANGE# NUMBER
  to_date(                                 -- FIRST_TIME DATE
    palot,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_number(panxs),                        -- NEXT_CHANGE# NUMBER
  to_date(                                 -- NEXT_TIME DATE
    panxt,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  pabct,                                   -- BLOCKS NUMBER
  pabsz,                                   -- BLOCK_SIZE NUMBER
  to_date(                                 -- START_TIME DATE
    pctsm,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_date(                                 -- COMPLETION_TIME DATE
    pctim,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  abs((to_date(pctim,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian')- to_date(pctsm,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'))*86400),-- ELAPSED_SECONDS NUMBER
  pcrsi,                                   -- RMAN_STATUS_RECID NUMBER
  pcrst,                                   -- RMAN_STATUS_STAMP NUMBER
  decode(                                  -- TERMINAL VARCHAR2(3)
    bitand(paflg, 1), 1, 'YES', 'NO'),
  decode(                                  -- KEEP VARCHAR2(3)
    bitand(paflg, 1792), 0, 'NO', 'YES'),
  to_date(                                 -- KEEP_UNTIL DATE
    pakpt,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  decode(                                  -- KEEP_OPTIONS VARCHAR2(11)
    bitand(paflg, 1792), 256, 'LOGS', 512, 'NOLOGS', 1024, 'BACKUP_LOGS', NULL) 
from
  x$kccpa