if object_id('dbo.viw_Order_Parts') is not null
drop view dbo.viw_Order_Parts
go

create view viw_Order_Parts
as
select HPN,
Sum(Quantity) as Qty,
sum(received_Qty) as Rcv_Qty,
sum(Balance_Qty) as Outstd_Qty,
Max(deli_day) as Delivery_dt
from ord_item
group by hpn
go