
create Procedure SP_YazarKasaFisYazdirUrunListesi(@FisNo Integer)
as
select A.StokKodu as Id,A.Miktar as Quantity,A.BirimFiyat as Price,
Kart.DepartmanKodu as DeptId,Kart.StokAdi as Name,0 As Status,
A.Birim
from STOKHAR as A
inner join STOKKARTI as Kart on Kart.Kodu=A.StokKodu 
where A.IslemNo=@FisNo




