drop procedure ec_apply_gift_cert_balance;
drop procedure ec_reinst_gift_cert_on_order;
drop function ec_total_price;
drop function ec_total_shipping;
drop function ec_total_tax;
drop function ec_shipment_price;
drop function ec_shipment_shipping;
drop function ec_shipment_tax;
drop function ec_order_gift_cert_amount;
drop function ec_shipment_gift_certificate;
drop function ec_tax;
drop function ec_order_cost;
drop function ec_shipment_cost;
drop function ec_total_refund;
drop function ec_gift_certificate_balance;
drop function ec_order_amount_owed;
drop function gift_certificate_amount_left;
drop function ec_cash_amount_to_refund;
drop function ec_one_gift_cert_on_one_order;
drop function ec_earlier_certs_on_one_order;
drop function ec_cert_unshipped_one_order;
drop function ec_gift_cert_unshipped_amount;
drop table ec_gift_cert_usage_ids;
drop table ec_templates_audit;
drop table ec_categories_audit;
drop table ec_subcategories_audit;
drop view ec_subcategories_augmented ;
drop table ec_subsubcategories_audit;
drop view ec_subsubcategories_augmented;
drop view ec_products_displayable;
drop view ec_products_searchable;
drop table ec_products_audit;
drop table ec_product_purchase_comb;
drop table ec_sale_prices;
drop view ec_sale_prices_current;
drop table ec_sale_prices_audit;
drop table ec_product_series_map;
drop table ec_product_series_map_audit;
drop table ec_user_classes_audit;
drop table ec_product_user_class_prices;
drop table ec_product_u_c_prices_audit;
drop table ec_product_recommendations;
drop table ec_product_recommend_audit;
drop view ec_recommendations_cats_view;
drop table ec_user_class_user_map;
drop table ec_user_class_user_map_audit;
drop table ec_product_links;
drop table ec_product_links_audit;
drop table ec_product_comments;
drop table ec_product_comments_audit;
drop table ec_product_reviews;
drop table ec_product_reviews_audit;
drop table ec_category_product_map;
drop table ec_category_product_map_audit;
drop table ec_subcategory_product_map;
drop table ec_subcat_prod_map_audit;
drop table ec_subsubcategory_product_map;
drop table ec_subsubcat_prod_map_audit;
drop table ec_category_template_map;
drop table ec_custom_product_fields;
drop table ec_custom_product_fields_audit;
drop table ec_custom_product_field_values;
drop table ec_custom_p_field_values_audit;
drop table ec_user_session_info;
drop table ec_user_session_offer_codes;
drop view ec_orders_reportable;
drop view ec_orders_shippable;
drop table ec_shipments_audit;
drop table ec_items;
drop view ec_items_reportable ;
drop view ec_items_refundable;
drop view ec_items_shippable;
drop view ec_items_money_view;
drop table ec_state_change_order_ids;
drop table ec_admin_settings;
drop table ec_admin_settings_audit;
drop table ec_sales_tax_by_state;
drop table ec_sales_tax_by_state_audit;
drop table ec_retailers_audit;
drop table ec_offers;
drop table ec_retailer_locations;
drop table ec_retailer_locations_audit;
drop view ec_offers_current;
drop table ec_offers_audit;
drop view ec_gift_certificates_approved;
drop view ec_gift_certificates_purchased;
drop view ec_gift_certificates_issued;
drop table ec_gift_certificates_audit;
drop table ec_gift_certificate_usage;
drop view ec_customer_service_reps;
drop table ec_cs_issue_type_map;
drop table ec_cs_action_info_used_map;
drop table ec_picklist_items;
drop table ec_picklist_items_audit;
drop table ec_canned_responses;
drop table ec_email_templates_audit;
drop table ec_cat_mailing_lists;
drop table ec_spam_log;
drop view ec_fin_transactions_reportable;
drop table ec_cybercash_log;
drop table ec_problems_log;
drop table ec_automatic_email_log;
begin  
       acs_object_type.drop_type (object_type   => 'ec_product'); 
end;
/
drop table ec_products;
drop table ec_templates;
drop table ec_subsubcategories;
drop table ec_subcategories;
drop table ec_categories;
drop table ec_user_classes;
drop table ec_retailers;
drop table ec_financial_transactions;
drop table ec_refunds;
drop table ec_shipments;
drop table ec_customer_service_actions;
drop table ec_customer_serv_interactions;
drop table ec_customer_service_issues;
drop table ec_email_templates;
drop table ec_user_identification;
drop table ec_gift_certificates;
drop table ec_orders;
drop table ec_creditcards;
drop table ec_addresses;
drop table ec_user_sessions;
drop sequence ec_template_id_sequence;
drop sequence ec_category_id_sequence;
drop sequence ec_subcategory_id_sequence;
drop sequence ec_subsubcategory_id_sequence;
-- drop sequence ec_product_id_sequence;
drop sequence ec_sale_price_id_sequence;
drop sequence ec_address_id_sequence;
drop sequence ec_creditcard_id_sequence;
drop sequence ec_user_class_id_sequence;
drop sequence ec_recommendation_id_sequence;
drop sequence ec_product_comment_id_sequence;
drop sequence ec_product_review_id_sequence;
-- drop sequence ec_user_session_sequence;
drop sequence ec_order_id_sequence;
drop sequence ec_shipment_id_sequence;
drop sequence refund_id_sequence;
drop sequence ec_item_id_sequence;
drop sequence ec_retailer_sequence;
drop sequence ec_retailer_location_sequence;
drop sequence ec_offer_sequence;
drop sequence ec_gift_cert_id_sequence;
drop sequence ec_issue_id_sequence;
drop sequence ec_action_id_sequence;
drop sequence ec_interaction_id_sequence;
drop sequence ec_user_ident_id_sequence;
drop sequence ec_picklist_item_id_sequence;
drop sequence ec_canned_response_id_sequence;
drop sequence ec_email_template_id_sequence;
drop sequence ec_spam_id_sequence;
drop sequence ec_transaction_id_sequence;
drop sequence ec_problem_id_sequence;

@@ pl-sql-utilities-drop.sql

@@ ec-product-package-drop.sql