oracle 8.1.6 SELECT p.customer_id, c.name as customer_name FROM pm_projectsx p , organizations c WHERE p.customer_id = c.organization_id (+) and p.project_id = :original_project_id and exists (select 1 from acs_object_party_privilege_map ppm where ppm.object_id = :original_project_id and ppm.privilege = 'read' and ppm.party_id = :user_id)