select
inst_id, -- INST_ID NUMBER
name_xsagopft as name, -- NAME VARCHAR2(14)
desc_xsagopft as longname, -- LONGNAME VARCHAR2(30)
case -- DEFAULT_WEIGHT NUMBER
when weight_xsagopft >= 0
then weight_xsagopft
else null end as default_weight
from
x$xsagop
where
not bitand(flags_xsagopft, 32) = 0