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