select i.item_id from cr_items i, cr_revisions r, pm_projects p where lower(r.title) like '%${keyword}%' and i.latest_revision = r.revision_id and r.revision_id = p.project_id order by r.title asc select item_id, o.package_id as object_package_id from cr_items i, acs_objects o, pm_projects p where lower(p.project_code) like '%${keyword}%' and i.latest_revision = o.object_id and o.object_id = p.project_id order by title asc