Query behind User Status in Oracle User Form

 SELECT v.lookup_code, v.meaning
  FROM fnd_lookup_values_vl v
 WHERE v.lookup_type = 'FND_USRDEF_STATUS';