select report=o.object_name, o.object_owner,
  o.short_remark, r.reptype
  from ii_objects o, ii_reports r
  where (o.object_class = 1501 or
    o.object_class = 1502 or
    o.object_class = 1511)
   /* object_classes 1501, 1502, 1511 = reports
   */
  and o.object_id = r.object_id