Index: openacs-4/packages/invoices-portlet/lib/projects-billable.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/invoices-portlet/lib/projects-billable.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/invoices-portlet/lib/projects-billable.xql	26 Oct 2005 22:45:10 -0000	1.2
+++ openacs-4/packages/invoices-portlet/lib/projects-billable.xql	27 Oct 2005 19:35:38 -0000	1.3
@@ -11,6 +11,7 @@
            	to_char(sub.creation_date, :timestamp_format) as creation_date, 
 		total.count_total, 
 		billed.count_billed, 
+		billed.recipient_id,
 		name
 	from 
 	(
@@ -75,7 +76,8 @@
 	(
     		select 
 			count(i.invoice_id) as count_billed,
-			oi.item_id
+			oi.item_id,
+			i.recipient_id
     		from 
 			cr_items oi, 
 			iv_offer_items ofi
@@ -84,7 +86,7 @@
     		where 
 			ofi.offer_id = oi.latest_revision
 	    	group by 
-			oi.item_id
+			oi.item_id, i.recipient_id
     	) billed, 
 		cr_revisions r
 	where