SELECT typecode,typename from t_s_type where typegroupid=(select id from t_s_typegroup where typegroupcode='orderBz')