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 -N -r1.12 -r1.13
--- openacs-4/packages/invoices/lib/offer-list.xql	18 Jun 2006 14:17:54 -0000	1.12
+++ openacs-4/packages/invoices/lib/offer-list.xql	20 Oct 2006 17:43:59 -0000	1.13
@@ -49,20 +49,14 @@
       <querytext>
       
     select cr.item_id
-    from cr_folders cf, cr_revisions cr, iv_offers t,
-         acs_objects o, persons p, cr_items ci, acs_data_links r,
-         cr_items pi, cr_revisions pr, pm_projects pp, persons p2 $subproject_from
+    from cr_revisions cr, iv_offers t, cr_items ci, acs_data_links r,
+         cr_items pi, cr_revisions pr, pm_projects pp $subproject_from
     where cr.revision_id = ci.latest_revision
     and t.offer_id = cr.revision_id
-    and ci.parent_id = cf.folder_id
-    and cf.package_id = :package_id
-    and o.object_id = cr.item_id
-    and p.person_id = o.creation_user
     and r.object_id_one = ci.item_id
     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]