Index: openacs-4/packages/ecommerce/tcl/ecommerce-customer-service-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-customer-service-procs-oracle.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/ecommerce/tcl/ecommerce-customer-service-procs-oracle.xql	26 May 2002 04:36:49 -0000	1.3
+++ openacs-4/packages/ecommerce/tcl/ecommerce-customer-service-procs-oracle.xql	13 Jan 2005 13:57:55 -0000	1.4
@@ -30,4 +30,25 @@
     </querytext>
   </fullquery>
 
+  <fullquery name="user_customer_service_issue">
+    <querytext>
+      select i.issue_id, i.open_date, i.close_date, m.issue_type
+      from ec_customer_service_issues i, ec_cs_issue_type_map m, ec_user_identification id
+      where i.issue_id = m.issue_id(+)
+      and i.user_identification_id = id.user_identification_id
+      and id.user_id = :user_id
+      order by i.issue_id
+    </querytext>
+  </fullquery>
+
+  <fullquery name="customer_service_issue">
+    <querytext>
+      select i.issue_id, i.open_date, i.close_date, m.issue_type
+      from ec_customer_service_issues i, ec_cs_issue_type_map m
+      where i.issue_id = m.issue_id(+)
+      and i.user_identification_id = :user_identification_id
+      order by i.issue_id
+    </querytext>
+  </fullquery>
+
 </queryset>