SET QUOTED_IDENTIFIER OFF
GO
create view [dbo].[al_vw_link_normalization]
AS
select distinct comp.company_uuid,
comp.company_name as Authoratative,
pcr.manufacturer as Subordinate
from pg_content_rule pcr
join pg_product_def ppd
    on pcr.content_uuid = ppd.product_uuid
join pg_product_family ppf
    on ppd.family_uuid = ppf.family_uuid
join ca_company comp
    on ppf.manufacturer_uuid = comp.company_uuid
where pcr.drcs_content_type_id = 3
GO