select
  ID,                                      -- ID NUMBER
  NAME,                                    -- NAME VARCHAR2(64)
  CHECK_ID,                                -- CHECK_ID NUMBER
  TYPE,                                    -- TYPE VARCHAR2(20)
  DEFAULT_VALUE,                           -- DEFAULT_VALUE VARCHAR2(64)
  FLAGS,                                   -- FLAGS NUMBER
  DESCRIPTION                              -- DESCRIPTION VARCHAR2(1024)
from
  GV$HM_CHECK_PARAM
where
  inst_id=USERENV('Instance')