+ JOIN ".TB_PREF."denorm_qoh qoh ON (stock_id = stk_code AND loc_code = '$location')
+ JOIN ".TB_PREF."denorm_order_details_queue d ON (d.id = sod.id)
+ WHERE sod.quantity > qty_sent
+ ";
+
+ return $sql;
+}
+
+function get_order_summary() {
+ $sql = "SELECT debtor_no, debtor_ref, branch_ref
+ , min(delivery_date)
+ , sum(quantity - qty_sent) as quantity
+ , sum((quantity - qty_sent)*unit_price*(1-discount_percent/100)) as amount
+ , min(required_date)
+ , group_concat(distinct comments separator ';') as order_comment
+ , group_concat(distinct comment separator ';') as detail_comment
+ FROM ".TB_PREF."sales_order_details sod
+ JOIN ".TB_PREF."sales_orders so ON (so.order_no = sod.order_no
+ AND so.trans_type = sod.trans_type
+ AND so.trans_type = ".ST_SALESORDER."
+ )
+ NATURAL JOIN ".TB_PREF."debtors_master
+ NATURAL JOIN ".TB_PREF."cust_branch
+ WHERE quantity > qty_sent AND ".ST_SALESORDER."
+ GROUP BY debtor_no, branch_code