SELECT
  INST_ID,                                 -- INST_ID NUMBER
  WRL_TYPE,                                -- WRL_TYPE VARCHAR2(20)
  WRL_PARAMETER,                           -- WRL_PARAMETER VARCHAR2(4000)
  decode(                                  -- STATUS VARCHAR2(18)
    BITAND(STATUS,15), 1, 'UNDEFINED', 2, 'CLOSED', 4, 'OPEN', 8, 'OPEN_NO_MASTER_KEY') 
FROM
  X$KZEKMENCWAL