Index: openacs-4/packages/invoices/lib/offer-list.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/lib/offer-list.xql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/invoices/lib/offer-list.xql	3 Nov 2005 22:49:12 -0000	1.7
+++ openacs-4/packages/invoices/lib/offer-list.xql	15 Dec 2005 23:22:53 -0000	1.8
@@ -21,8 +21,7 @@
 	   to_char(t.accepted_date, :timestamp_format) as accepted_date,
 	   to_char(t.finish_date, :timestamp_format) as finish_date,
            pi.item_id as project_id, pr.title as project_title, t.status,
-           pp.contact_id, 
-	   p2.first_names as contact_first_names,
+           p2.first_names as contact_first_names,
            p2.last_name as contact_last_name
     from cr_folders cf, cr_revisions cr, iv_offers t,
          acs_objects o, persons p, cr_items ci, acs_rels r,
@@ -37,7 +36,6 @@
     and r.object_id_two = pi.item_id
     and pr.revision_id = pi.latest_revision
     and pp.project_id = pr.revision_id
-    and p2.person_id = pp.contact_id
     [template::list::filter_where_clauses -and -name iv_offer]
     [template::list::page_where_clause -and -name iv_offer -key cr.item_id]
     [template::list::orderby_clause -name iv_offer -orderby]
@@ -62,7 +60,6 @@
     and r.object_id_two = pi.item_id
     and pr.revision_id = pi.latest_revision
     and pp.project_id = pr.revision_id
-    and p2.person_id = pp.contact_id
     [template::list::filter_where_clauses -and -name iv_offer]
     [template::list::orderby_clause -name iv_offer -orderby]