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.11 -r1.12
--- openacs-4/packages/invoices/lib/offer-list.xql	15 Mar 2006 17:05:05 -0000	1.11
+++ openacs-4/packages/invoices/lib/offer-list.xql	18 Jun 2006 14:17:54 -0000	1.12
@@ -26,7 +26,7 @@
            pp.customer_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
+         cr_items pi, cr_revisions pr, pm_projects pp, persons p2 $subproject_from
     where cr.revision_id = ci.latest_revision
     and t.offer_id = cr.revision_id
     and ci.parent_id = cf.folder_id
@@ -51,7 +51,7 @@
     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
+         cr_items pi, cr_revisions pr, pm_projects pp, persons p2 $subproject_from
     where cr.revision_id = ci.latest_revision
     and t.offer_id = cr.revision_id
     and ci.parent_id = cf.folder_id