--Запрос выгружает в поле alt_iid внутренний штрих код аптеки.

Select st.med_id,med.med_name,v.vendor_name,c.country_name, st.qtty,
       i.vprice,i.sprice,i.nds, i.divisor,i.gtd, i.seria,i.valid_date,
       i.sert_num, i.reg_sert_num as reg_sert_n,i.IID as alt_iid,i.rprice,
       Ean13(coalesce(i.vbarcode,med.vendorbarcode)) as VENDORBARC,
       i.sprice*st.qtty*1e0/i.divisor as SSUM,
       i.sallprice*st.qtty*1e0/i.divisor as SALLSUM

from Stock st
       inner join medicine med on med.med_id=st.med_id
       inner join Vendor v on v.vendor_id=med.vendor_id
       inner join Country c on c.country_id=med.country_id
       inner join Items i on i.iid=st.iid
where st.qtty>0  and st.Dep_id=:Dep_ID
order by 1