if object_id('dbo.Viw_IM_RTN_List') is not null
drop 

create view Viw_IM_RTN_List
as
select 
distinct
a.Dn_no as Dn_Number,
b.single_no as RTN_No,
b.Lotno,
a.Pono as Order_Number,
a.Itemno as HPN,
c.Description,
c.MPN,
a.Rej_Qty,
a.Unit as UoM,
a.cause as Rej_Reason,
b.rej_date as Rej_dt,
b.iscust as Consignement_flag,
b.vdr_no as Vendor_id,
a.Remark as Remark1,
b.Remark as Remark2,
a.fir_date as Creation_dt,
a.Fir_oper as Created_by,
a.che as Confirmed,
a.cher as Confirmed_by,
a.che_date as Confirmed_dt
 from mrpii..Dpt_Pur_Rejectc a,Mrpii..Dpt_Pur_Reject b,mrpii..bas_item c where a.single_id = b.single_id and a.itemno = c.itemno