-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             11.2.0.6213
-- --------------------------------------------------------


-- Dumping structure for view hgagent.ptl_bal_qty_view
-- Creating temporary table to overcome VIEW dependency errors
ALTER VIEW `ptl_bal_qty_view` as ALTER VIEW `ptl_bal_qty_view` as select `ptlp`.`id` AS `id`,`ptlp`.`name` AS `product_name`,`ptlp`.`promoter_task_list_id` AS `promoter_task_list_id`,`ptlp`.`product_id` AS `product_id`,`ptlp`.`t_qty` AS `t_qty`,`ptlp`.`o_qty` AS `o_qty`,`ptlp`.`l_qty` AS `l_qty`,`ptlp`.`remark` AS `remark` from `hgagent`.`promoter_task_list_products` `ptlp`;

