UFN_MKTCOMMON_PRODUCTISALTRU

create function dbo.[UFN_MKTCOMMON_PRODUCTISALTRU]()
returns bit
as
  begin
    declare @ALTRU bit;

    set @ALTRU = case when dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('bb1c17bc-9e0b-4683-b490-ee40d511fa05') = 1 and -- basic program

                           dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('0e85c527-e6e9-4c5f-a8e8-105fd0e18fe7') = 1 and -- basic GL

                           dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('42c15648-749e-4859-a56d-3a6474814cc7') = 1 and -- basic development

                           (dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('5e696818-62ee-4c90-8c28-b1f52d77176e') = 1 or -- membership

                            dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('cdde0301-817a-4118-9c4e-ea4640fb0b1c') = 1) and -- basic membership

                           dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('3117d2c8-7f46-42f2-abeb-b654f2f63046') = 0 -- not enterprise

                      then 1 else 0 end;

    return @ALTRU;
  end;