select p.item_id as project_item_id, p.title, to_char(p.planned_end_date, 'YYYY-MM-DD') as planned_end_date from pm_projectsx p, cr_items i where p.project_id = i.live_revision and p.item_id = i.item_id and p.object_package_id = :package_id and exists ( select 1 from acs_object_party_privilege_map ppm where ppm.object_id = p.project_id and ppm.privilege = 'read' and ppm.party_id = :user_id) $extra_query [template::list::filter_where_clauses -and -name projects] order by planned_end_date asc select amount_total from iv_offers where offer_id = :offer_id