select
  name_xsagopft as name,                   -- NAME VARCHAR2(14)
  desc_xsagopft as longname                -- LONGNAME VARCHAR2(30)
from
  x$xsagop
where
  not bitand(flags_xsagopft, 64) = 0