Index: openacs-4/packages/ecommerce/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/index-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/ecommerce/www/index-oracle.xql	26 May 2002 04:36:50 -0000	1.2
+++ openacs-4/packages/ecommerce/www/index-oracle.xql	12 Sep 2002 22:15:01 -0000	1.3
@@ -15,4 +15,16 @@
     </querytext>
   </fullquery>
 
+  <fullquery name="get_tl_products">      
+    <querytext>
+      select p.product_id, p.product_name, p.one_line_description, o.offer_code
+      from ec_products_searchable p, ec_user_session_offer_codes o
+      where (p.product_id(+)=o.product_id and user_session_id = :user_session_id)
+      and not exists (select 1 
+          from ec_category_product_map m
+          where p.product_id = m.product_id)
+      order by p.product_name
+    </querytext>
+  </fullquery>
+
 </queryset>