UFN_DATAFORMINSTANCE_PRODUCTISDATAFORM

        create function dbo.UFN_DATAFORMINSTANCE_PRODUCTISDATAFORM(@DATAFORMINSTANCEID uniqueidentifier)
        returns bit
        with execute as caller
        as begin
          declare @ISPRODUCT bit = 0;

            with xmlnamespaces ('bb_appfx_commontypes' as common)
            select @ISPRODUCT = dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED(TEMPLATE.TEMPLATESPECXML.query('/*/common:InstalledProductList'))
            from dbo.DATAFORMINSTANCECATALOG as INSTANCE
                inner join dbo.DATAFORMTEMPLATECATALOG as TEMPLATE on INSTANCE.DATAFORMTEMPLATECATALOGID = TEMPLATE.ID
            where INSTANCE.ID = @DATAFORMINSTANCEID;

            return @ISPRODUCT;
        end