select alt_mod.object_id, vers_name.value_, alt_mod.ver_number, list_num.value_ as list_num from
objects alt_mod, eav_memo vers_name, eav_objects alt_vers, eav_int list_num where
alt_vers.value_ = vers_name.object_id and
vers_name.attribute_id = 312 and
alt_vers.attribute_id = 314 and
alt_mod.object_id=alt_vers.value_ and
list_num.object_id=alt_mod.object_id and
list_num.attribute_id=310
order by list_num.value_(+)
|