Demantra 7.3.1.- How does table engine_branch_list gets populated?
In Demantra 7.3.1, How does table Engine_branch_list gets populated.
I checked the procedure insert_unit and dyn_insert_unit_branch_id
Its using following query
SELECT s.item_id item_id,
s.location_id location_id,
MAX(sales_date) sales_date,
MIN(m.is_fictive) is_fictive ,
SUM(CASE WHEN (s.sales_date > '06-06-2011 00:00:00' AND s.sales_date <= '06-06-2011 00:00:00') THEN 1
ELSE 0 END) sales_in_old_fore,
SUM(CASE WHEN (s.sales_date > '06-06-2011 00:00:00' AND s.sales_date <= '06-18-2012 00:00:00') THEN 1
ELSE 0 END) sales_in_new_fore
FROM sales_data s, mdp_matrix m, engine_branch_list e
I checked the procedure insert_unit and dyn_insert_unit_branch_id
Its using following query
SELECT s.item_id item_id,
s.location_id location_id,
MAX(sales_date) sales_date,
MIN(m.is_fictive) is_fictive ,
SUM(CASE WHEN (s.sales_date > '06-06-2011 00:00:00' AND s.sales_date <= '06-06-2011 00:00:00') THEN 1
ELSE 0 END) sales_in_old_fore,
SUM(CASE WHEN (s.sales_date > '06-06-2011 00:00:00' AND s.sales_date <= '06-18-2012 00:00:00') THEN 1
ELSE 0 END) sales_in_new_fore
FROM sales_data s, mdp_matrix m, engine_branch_list e
0