select
  inst_id,                                 -- INST_ID NUMBER
  id,                                      -- FINDING_ID NUMBER
  run_id,                                  -- RUN_ID NUMBER
  name,                                    -- NAME VARCHAR2(32)
  pid,                                     -- PARENT_ID NUMBER
  cid_count,                               -- CHILD_COUNT NUMBER
  clsname,                                 -- CLASS_NAME VARCHAR2(32)
  cast(ctime as timestamp),                -- TIME_DETECTED TIMESTAMP(6)
  cast(mtime as timestamp),                -- MODIFIED TIMESTAMP(6)
  decode(                                  -- PRIORITY VARCHAR2(8)
    priority, 0, 'CRITICAL', 1, 'HIGH', 2, 'LOW', 'UNKNOWN'),
  decode(                                  -- STATUS VARCHAR2(12)
    status, 0, 'OPEN', 1, 'CLOSED', 2, 'UNDER-REPAIR', 'UNKNOWN'),
  decode(                                  -- TYPE VARCHAR2(13)
    type, 0, 'INFORMATIONAL', 1, 'FAILURE', 'UNKNOWN'),
  fdg_msg,                                 -- DESCRIPTION VARCHAR2(1024)
  damage_msg                               -- DAMAGE_DESCRIPTION VARCHAR2(1024)
from
  x$dbkfdg