create or alter view v_invnt_client_ordered_wares as
select
    d.ware_id as id, -- <<< ::: NB: do NOT change name of this field! :::
--    d.doc_id as doc_list_id,
--    d.id as doc_data_id,
    sum(d.qty) qty_ full ,
    sum(d.acq) qty_ sent , -- d.acq = how many we've already ordered to SUPPLIER (sent to him)
    sum(d.qty - d.acq) qty_ need  -- <<< still need to be ordered to supplier
from doc_data d
join doc_list h on d.doc_id=h.id
where
    h.optype_id = fn_oper_order_by_customer()
    and h.state_id in (fn_doc_open_state(), fn_doc_fix_state())
    and d.qty > d.crq -- not all amount was got and client did not refused from his order
    and d.qty > d.acq -- not all amount was put to supplier order(s)
group by d.ware_id
;