if object_id('dbo.View_MIS_GR_List') is not null
drop view dbo.View_MIS_GR_List
go
create view View_MIS_GR_List
as
select 
distinct
b.lotno ,
b.single_no as GR_DocNo,
a.pono as Order_Number,
b.vdr_no as Vendor_ID,
b.dnno as DN_Number,
a.Itemno as HPN,
b.Model,
a.Unit as UoM,
b.Invoice_no as Invoice_No,
a.Recdepot as Warehouse,
a.Rec_qty as Rcv_Qty,
a.Real_Qty as Actual_Qty,
a.Scrap_Qty as Scrap_Qty,
a.short_Qty as Short_Qty,
a.Rej_Qty as Return_Qty,
b.rec_date as gr_dt,
b.Fir_oper as Created_by,
b.Fir_date as Creation_dt
from dpt_gtrc a,dpt_gtr b where a.single_id = b.single_id  and che=1

go