Case when pg.Parent is not null then pg.Parent else
(Case when pg.Vendor_group is not null then pg.Vendor_group else coalesce(rtrim(ve.EnglishNm), ve.VendorNm)end )end as [Vendor Parent],
Case when pg.Vendor_group is not null then pg.Vendor_group else coalesce(rtrim(ve.EnglishNm), ve.VendorNm)end as [Vendor Group],
coalesce(rtrim(ve.EnglishNm), ve.VendorNm) [Vendor Name],