CREATE OR REPLACE FUNCTION sp_ware_view(IN _ware integer)
  RETURNS TABLE(code int, w_type int, w_name varchar, material varchar, size varchar, descr varchar,
                unit varchar, picture varchar, weight numeric, price numeric, type_name varchar,
                amount numeric, ordered numeric, reserved numeric) AS
$BODY$
declare
  v_amnt numeric(15,4);
  v_ord  numeric(15,4) = -1.00;
  v_rsrv numeric(15,4) = -1.00;
  v_sent numeric(15,4);
begin
  Select Sum(a.amount) into v_amnt                    -- Всего на складах
    From w_amnt a Where a.w_code = _ware;

  Select Sum(os.amount) into v_ord                    -- Заказано в недоделанных заявках (в т.ч.
    From ord_spec os                                  -- может быть и отгружено)
    Join orders ord on os.order_id = ord.order_id
   Where os.w_code = _ware
     and ord.fn_date is NULL;

  Select Sum(ws.amount) into v_rsrv                   -- Отложено в неотгруженных накладных
    From wbs_out_spec ws
    Join wbs_out wb on ws.wbs_out_id = wb.wbs_out_id
   Where ws.w_code = _ware
     and wb.check_date is NULL;

  Select Sum(ws.amount) into v_sent                   -- Отгружено по накладным, относящимся
    From wbs_out_spec ws                              -- к недоделанным заявкам
    Join wbs_out wb on ws.wbs_out_id = wb.wbs_out_id
    Join orders ord on wb.order_id = ord.order_id
   Where ws.w_code = _ware
     and wb.check_date is not NULL
     and ord.fn_date is NULL;
  v_ord := Coalesce(v_ord, 0.00) - Coalesce(v_sent, 0.00);

  Return Query
    SELECT w.code, w.w_type, w.w_name, w.material, w.size, w.descr, w.unit, w.picture, w.weight,
           round(w.price, 2) as price, wt.wt_name as type_name, Coalesce(round(v_amnt, 2), 0.00), round(v_ord, 2), Coalesce(round(v_rsrv, 2), 0.00)
      From ware w
      Join w_type wt on w.w_type = wt.wt_id
     Where w.code = _ware;
  Return;
end
$BODY$
  LANGUAGE plpgsql VOLATILE SECURITY DEFINER;

ALTER FUNCTION sp_ware_view(integer)
  OWNER TO postgres;
GRANT EXECUTE ON FUNCTION sp_ware_view(integer) TO stapp;
GRANT EXECUTE ON FUNCTION sp_ware_view(integer) TO postgres;

...
  Return Query
    SELECT ww.w_code, ww.w_type, ww.w_name, ww.material, ww.size, ww.descr, ww.picture,
           ww.wt_name, ww.unit, ww.amount, ww.rsrv, ww.amount - ww.rsrv as for_sale,
           case when ww.ord_all - ww.ord_shp > ww.amount then ww.ord_all - ww.ord_shp - ww.amount else NULL end as deficit,
           ww.weight, ww.price, ww.price, NULL::numeric(15,4) as quant
      From (
             Select w.code as w_code, w.w_type, w.w_name, w.material, w.size, w.descr, w.picture, wt.wt_name,
                    w.unit, Coalesce(round(wa.amnt, 2), 0.00) as amount, Coalesce(round(wr.rsrv, 2), 0.00) as rsrv,
                    Coalesce(round(oa.ord_all, 2), 0.00) as ord_all, Coalesce(round(os.ord_shp, 2), 0) as ord_shp,
                    w.weight, round(w.price, 2) as price
               From ware w
               Join w_type wt on w.w_type = wt.wt_id
               Left Join ( Select Sum(a.amount) as amnt, a.w_code                     -- Всего на складах
                             From w_amnt a Group by a.w_code ) wa on w.code = wa.w_code
               Left Join ( Select Sum(ws.amount) as rsrv, ws.w_code                   -- Отложено в неотгруженных накладных
                             From wbs_out_spec ws
                             Join wbs_out wb on ws.wbs_out_id = wb.wbs_out_id
                            Where wb.check_date is NULL
                            Group by ws.w_code ) wr on w.code = wr.w_code
               Left Join ( Select Sum(os.amount) as ord_all, os.w_code                -- Заказано в недоделанных заявках (в т.ч.
                             From ord_spec os                                         -- может быть и отгружено)
                             Join orders ord on os.order_id = ord.order_id
                            Where ord.fn_date is NULL
                            Group by os.w_code ) oa on w.code = oa.w_code
               Left Join ( Select Sum(ws.amount) as ord_shp, ws.w_code                -- Отгружено по накладным, относящимся
                             From wbs_out_spec ws                                     -- к недоделанным заявкам
                             Join wbs_out wb on ws.wbs_out_id = wb.wbs_out_id
                             Join orders ord on wb.order_id = ord.order_id
                            Where wb.check_date is not NULL
                              and ord.fn_date is NULL
                            Group by ws.w_code ) os on w.code = os.w_code
...