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>