select * from eqi_equipments where class_group_code||class_group_serial in 
(select a.class_group_code||a.class_group_serial
from eqi_equipments a, eqi_class_groups b, eqi_class_group_types c, 
eqi_brands d, eqi_status e, eqi_change_plate f
where (a.class_group_code=b.class_group_code
and a.class_group_code=c.class_group_code
and a.type_code=c.type_code
and a.brand_code=d.brand_code
and a.status_code=e.status_code
and a.class_group_code=f.class_group_code(+)
and a.class_group_serial=f.class_group_serial(+))
and ( upper(a.class_group_code) like '%'||'SIDES'||'%'
or  upper(a.class_group_serial) like '%'||'SIDES'||'%'
or  upper(b.class_group_desc) like '%'||'SIDES'||'%'
or  upper(a.type_code) like '%'||'SIDES'||'%'
or  upper(c.description) like '%'||'SIDES'||'%'
or  a.brand_code like ''||'SIDES'||''
or  upper(d.brand_desc) like '%'||'SIDES'||'%'
or  a.status_code like ''||'SIDES'||''
or  upper(e.status_desc) like '%'||'SIDES'||'%'
or  upper(a.factory_sn) like '%'||'SIDES'||'%'
or  upper(a.fixed_asset_flag) like '%'||'SIDES'||'%'
or  upper(a.plate_no) like '%'||'SIDES'||'%'
or  a.purchase_price like ''||'SIDES'||''
or  a.odometer_reading like ''||'SIDES'||''
or  upper(a.remark) like '%'||'SIDES'||'%'
or  a.model_year like ''||'SIDES'||''
or  upper(f.old_plate_number) like '%'||'SIDES'||'%'))

upper(a.class_group_code) like '%SIDES%'