select alt_mod.object_id, alt_mod.object_name, alt_mod.ver_number, list_num.value_ from
objects alt_mod, eav_memo vers_name, eav_objects alt_vers, eav_int list_num where
alt_vers.object_id = 45533 and 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_(+)
|