Index: openacs-4/packages/invoices/www/offer-send.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/www/offer-send.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/invoices/www/offer-send.xql	5 Oct 2005 16:17:57 -0000	1.3
+++ openacs-4/packages/invoices/www/offer-send.xql	11 Oct 2005 15:23:29 -0000	1.4
@@ -12,13 +12,14 @@
       </querytext>
 </fullquery>
 
-<fullquery name="get_files">
+<fullquery name="project_data">
       <querytext>
 
-      select max(item_id) as file_ids
-      from cr_items ci
-      where parent_id = :offer_id
-      and ci.storage_type = 'file'
+    select p.title as project_title, p.project_code, contact_id
+    from pm_projectsx p, cr_items oi
+    where oi.latest_revision = p.project_id
+    and oi.item_id = :project_id
+
       </querytext>
 </fullquery>