verif_erp_tables_and_view.sql

SELECT 1 FROM cataloginventory_stock_assignment;

SELECT 1 FROM backgroundtask;
SELECT 1 FROM backgroundtask_group;

SELECT 1 FROM order_to_prepare;
SELECT 1 FROM order_to_prepare_item;
SELECT 1 FROM order_to_prepare_pending;
SELECT 1 FROM order_preparation_carrier_template;
SELECT 1 FROM order_preparation_carrier_template_fields;

SELECT 1 FROM organizer_task;
SELECT 1 FROM organizer_task_category;
SELECT 1 FROM organizer_task_origin;

SELECT 1 FROM product_availability;

SELECT 1 FROM stock_errors;
SELECT 1 FROM stock_movement;
SELECT 1 FROM supply_needs;

SELECT 1 FROM purchase_contact;
SELECT 1 FROM purchase_manufacturer;
SELECT 1 FROM purchase_manufacturer_supplier;
SELECT 1 FROM purchase_order;
SELECT 1 FROM purchase_order_product;
SELECT 1 FROM purchase_packaging;
SELECT 1 FROM purchase_product_barcodes;
SELECT 1 FROM purchase_product_manufacturer;
SELECT 1 FROM purchase_product_serial;
SELECT 1 FROM purchase_product_supplier;
SELECT 1 FROM purchase_sales_order_planning;
SELECT 1 FROM purchase_shipping_delay;
SELECT 1 FROM purchase_supplier;
SELECT 1 FROM purchase_tva_rates;

SELECT 1 FROM erp_sales_history;
SELECT 1 FROM erp_stock_transfer_products;
SELECT 1 FROM erp_stock_transfer;
SELECT 1 FROM erp_sales_flat_order_item;

SELECT 1 FROM erp_view_supplyneeds_base;
SELECT 1 FROM erp_view_supplyneeds_global;
SELECT 1 FROM erp_view_supplyneeds_warehouse;