, sod.quantity - qty_sent quantity
, GREATEST(0, LEAST(qoh.quantity - quantity_before, sod.quantity - qty_sent))
, quantity_before
+ , sod.`priority`
+ , hold_until_date
, required_date
+ , expiry_date
,comment
FROM ".TB_PREF."sales_order_details sod
JOIN ".TB_PREF."sales_orders so ON (so.order_no = sod.order_no