SELECT p.item_id, p.project_id, p.title as project_name, p.project_code, p.goal, p.description, p.mime_type, to_char(p.planned_start_date,'YYYY-MM-DD HH24:MI') as planned_start_date, to_char(p.planned_end_date,'YYYY-MM-DD HH24:MI') as planned_end_date, p.ongoing_p, i.live_revision, to_char(p.estimated_finish_date,'YYYY-MM-DD HH24:MI') as estimated_finish_date, to_char(p.earliest_finish_date,'YYYY-MM-DD HH24:MI') as earliest_finish_date, to_char(p.latest_finish_date,'YYYY-MM-DD HH24:MI') as latest_finish_date, p.actual_hours_completed, p.estimated_hours_total, p.parent_id, s.status_type FROM pm_projectsx p, cr_items i, pm_project_status s WHERE p.item_id = :project_item_id and p.project_id = :project_id and p.item_id = i.item_id and p.status_id = s.status_id and exists (select 1 from acs_object_party_privilege_map ppm where ppm.object_id = :project_id and ppm.privilege = 'read' and ppm.party_id = :user_id)