select
  FINDING_ID,                              -- FINDING_ID NUMBER
  RUN_ID,                                  -- RUN_ID NUMBER
  NAME,                                    -- NAME VARCHAR2(32)
  PARENT_ID,                               -- PARENT_ID NUMBER
  CHILD_COUNT,                             -- CHILD_COUNT NUMBER
  CLASS_NAME,                              -- CLASS_NAME VARCHAR2(32)
  TIME_DETECTED,                           -- TIME_DETECTED TIMESTAMP(6)
  MODIFIED,                                -- MODIFIED TIMESTAMP(6)
  PRIORITY,                                -- PRIORITY VARCHAR2(8)
  STATUS,                                  -- STATUS VARCHAR2(12)
  TYPE,                                    -- TYPE VARCHAR2(13)
  DESCRIPTION,                             -- DESCRIPTION VARCHAR2(1024)
  DAMAGE_DESCRIPTION                       -- DAMAGE_DESCRIPTION VARCHAR2(1024)
from
  GV$HM_FINDING
where
  inst_id=USERENV('Instance')