Index: openacs-4/packages/invoices/lib/invoice-list.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/lib/invoice-list.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/invoices/lib/invoice-list.xql	9 Dec 2005 18:26:33 -0000	1.5
+++ openacs-4/packages/invoices/lib/invoice-list.xql	15 Mar 2006 17:05:05 -0000	1.6
@@ -8,8 +8,9 @@
            t.invoice_nr, t.total_amount, t.currency, t.paid_amount,
 	   t.paid_currency, p.first_names, p.last_name, o.creation_user,
 	   to_char(o.creation_date, :timestamp_format) as creation_date,
-	   to_char(t.due_date, :date_format) as due_date, t.parent_invoice_id,
-           t.invoice_id as invoice_rev_id, t.cancelled_p, t.status, t.recipient_id, t.organization_id
+	   to_char(t.due_date, :timestamp_format) as due_date, t.parent_invoice_id,
+           t.invoice_id as invoice_rev_id, t.cancelled_p, t.status, t.recipient_id,
+           t.organization_id as orga_id
     from cr_folders cf, cr_items ci, cr_revisions cr, iv_invoices t,
          acs_objects o, persons p
     where cr.revision_id = ci.latest_revision
@@ -28,7 +29,7 @@
 <fullquery name="iv_invoice_paginated">
       <querytext>
       
-    select cr.item_id as invoice_id
+    select cr.item_id
     from cr_folders cf, cr_items ci, cr_revisions cr, iv_invoices t,
          acs_objects o, persons p
     where cr.revision_id = ci.latest_revision