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'),
  pddfp,                                   -- FILE# NUMBER
  to_number(pdcrs),                        -- CREATION_CHANGE# NUMBER
  to_date(                                 -- CREATION_TIME DATE
    pdcrt,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_number(pdrls),                        -- RESETLOGS_CHANGE# NUMBER
  to_date(                                 -- RESETLOGS_TIME DATE
    pdrlc,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_number(pdcps),                        -- CHECKPOINT_CHANGE# NUMBER
  to_date(                                 -- CHECKPOINT_TIME DATE
    pdcpt,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_number(pdafs),                        -- ABSOLUTE_FUZZY_CHANGE# NUMBER
  to_number(pdrfs),                        -- RECOVERY_FUZZY_CHANGE# NUMBER
  to_date(                                 -- RECOVERY_FUZZY_TIME DATE
    pdrft,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  decode(                                  -- INCREMENTAL_LEVEL NUMBER
    bitand(pdflg, 1),1,0,NULL),
  decode(                                  -- ONLINE_FUZZY VARCHAR2(3)
    bitand(pdflg, 2),0,'NO','YES'),
  decode(                                  -- BACKUP_FUZZY VARCHAR2(3)
    bitand(pdflg, 4),0,'NO','YES'),
  pdfsz,                                   -- BLOCKS NUMBER
  pdbsz,                                   -- BLOCK_SIZE NUMBER
  pdlor,                                   -- OLDEST_OFFLINE_RANGE 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
  decode(                                  -- CONTROLFILE_TYPE VARCHAR2(1)
    pddfp, 0, decode(bitand(pcflg,8),8,'S','B'), NULL),
  decode(                                  -- KEEP VARCHAR2(3)
    bitand(pdflg, 1792), 0, 'NO', 'YES'),
  to_date(                                 -- KEEP_UNTIL DATE
    pdkpt,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  decode(                                  -- KEEP_OPTIONS VARCHAR2(11)
    bitand(pdflg, 1792), 256, 'LOGS', 512, 'NOLOGS', 1024, 'BACKUP_LOGS', NULL),
  pcrsi,                                   -- RMAN_STATUS_RECID NUMBER
  pcrst,                                   -- RMAN_STATUS_STAMP NUMBER
  pcfdi,                                   -- FOREIGN_DBID NUMBER
  decode(                                  -- PLUGGED_READONLY VARCHAR2(3)
    bitand(pdflg, 16), 0, 'NO', 'YES'),
  pcplus,                                  -- PLUGIN_CHANGE# NUMBER
  pcprls,                                  -- PLUGIN_RESETLOGS_CHANGE# NUMBER
  pcprlt                                   -- PLUGIN_RESETLOGS_TIME DATE
from
  x$kccpd