Index: openacs-4/packages/ecommerce/tcl/ecommerce-email-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-email-procs.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/ecommerce/tcl/ecommerce-email-procs.xql	28 Aug 2003 09:41:53 -0000	1.5
+++ openacs-4/packages/ecommerce/tcl/ecommerce-email-procs.xql	17 Dec 2008 06:39:58 -0000	1.6
@@ -40,7 +40,7 @@
 
   <fullquery name="ec_email_order_shipped.shipment_select">      
     <querytext>
-      select u.email, u.user_id, s.shipment_date, s.address_id, o.order_state, o.order_id
+      select u.email, u.user_id, s.shipment_date, s.address_id, s.expected_arrival_date, s.carrier, s.tracking_number, o.order_state, o.order_id
       from ec_orders o, cc_users u, ec_shipments s
       where o.user_id = u.user_id
       and o.order_id = s.order_id