Index: openacs-4/packages/invoices/lib/invoice-items-list.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/lib/invoice-items-list.tcl,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/invoices/lib/invoice-items-list.tcl	3 Nov 2005 22:49:12 -0000	1.2
+++ openacs-4/packages/invoices/lib/invoice-items-list.tcl	4 Nov 2005 14:40:06 -0000	1.3
@@ -189,6 +189,9 @@
     if { $categories_p && [exists_and_not_null category_id]} {
 	set category_$category_id "[_ invoices.Mapped]"
     }
+    
+    set item_id [db_string get_offer_item_id { }]
+    
     set project_item_id [lindex [application_data_link::get_linked -from_object_id $item_id -to_object_type content_item] 0]
     if { $project_status_p } {
 	if { [exists_and_not_null project_item_id] } {
Index: openacs-4/packages/invoices/lib/invoice-items-list.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/lib/invoice-items-list.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/invoices/lib/invoice-items-list.xql	3 Nov 2005 22:49:12 -0000	1.2
+++ openacs-4/packages/invoices/lib/invoice-items-list.xql	4 Nov 2005 14:40:06 -0000	1.3
@@ -65,5 +65,18 @@
     </querytext>
 </fullquery>
 
+<fullquery name="get_offer_item_id">
+    <querytext>
+	select 
+		o.item_id
+	from 
+		iv_offersx o,
+		iv_offer_items oi
+	where
+		oi.offer_item_id = :offer_item_id
+		and oi.offer_id = o.offer_id
+    </querytext>
+</fullquery>
+
 </queryset>