oracle8.1.6 select ec_products.product_id, ec_products.price, ec_category_product_map.category_id, min(sale_price) as sale_price from acs_objects, ec_products, ec_category_product_map, ec_sale_prices_current where acs_objects.context_id=:event_id and acs_objects.object_id=ec_products.product_id and ec_category_product_map.product_id(+)=ec_products.product_id and ec_sale_prices_current.product_id(+)=ec_products.product_id group by ec_products.product_id, ec_products.price, ec_category_product_map.category_id select ec_products.product_id from acs_objects, ec_products, ec_category_product_map where acs_objects.context_id=:event_id and acs_objects.object_id=ec_products.product_id and ec_category_product_map.product_id(+)=ec_products.product_id update ec_products set product_name='$activity_info(name) $date_time', sku='event_$event_id', one_line_description='$activity_info(name); $date_time; $pretty_location', detailed_description='$activity_info(description)', email_on_purchase_list=:email, search_keywords='$activity_info(name), $venue_info(venue_name), $pretty_location', url='$activity_info(detail_url)', price=:event_price, no_shipping_avail_p='t', present_p='$event_info(available_p)', available_date=sysdate, $audit_update where product_id=:product_id last_modified=sysdate, last_modifying_user=:user_id, modified_ip_address=:peeraddr insert into ec_category_product_map values (:product_id, :category_id, null, sysdate, :user_id, :peeraddr) begin :1 := ec_product.new( creation_user => :user_id, creation_ip => :peeraddr, context_id => :event_id, product_name => '$activity_info(name) $date_time', price => :event_price, sku => 'event_$event_id', one_line_description => '$activity_info(name); $date_time; $pretty_location', detailed_description => '$activity_info(description)', search_keywords => '$activity_info(name), $venue_info(venue_name), $pretty_location', present_p => 't', stock_status => 'i', email_on_purchase_list => :email, url => '$activity_info(detail_url)', no_shipping_avail_p => 't', active_p => 't' ); end; begin ec_product.delete(:product_id); end;