Index: openacs-4/packages/invoices/www/journal-add.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/www/journal-add.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/invoices/www/journal-add.xql	2 Apr 2006 22:08:02 -0000	1.1
+++ openacs-4/packages/invoices/www/journal-add.xql	19 Apr 2006 14:23:12 -0000	1.2
@@ -44,6 +44,15 @@
 			      and o.object_id = ii.item_id
 			      and i.status in ('billed', 'cancelled', 'paid')
 			      and o.creation_date > to_timestamp(:last_checkout, 'YYYY-MM-DD HH24:MI:SS'))
+    union
+    select o.organization_id, oi.latest_revision as orga_revision_id, p.email
+    from organizations o, cr_items oi, parties p, acs_objects ro, group_member_map g
+    where oi.item_id = o.organization_id
+    and p.party_id = o.organization_id
+    and g.member_id = o.organization_id
+    and g.group_id = :customer_group_id
+    and g.rel_id = ro.object_id
+    and ro.creation_date > to_timestamp(:last_checkout, 'YYYY-MM-DD HH24:MI:SS')
 
       </querytext>
 </fullquery>