UFN_SELECTION_GETGROUPNAMES

CREATE function dbo.UFN_SELECTION_GETGROUPNAMES
(
    @RECORDTYPEID uniqueidentifier
)
returns @T table
(
    NAME nvarchar(50)
)
as
begin
    insert into @T
    select distinct 
        GROUPNAME
    from
        dbo.IDSETREGISTER        
        left join dbo.SQLFUNCTIONCATALOG on SQLFUNCTIONCATALOG.FUNCTIONNAME = IDSETREGISTER.DBOBJECTNAME -- Filter by installed products

    where
        RECORDTYPEID = @RECORDTYPEID and 
        GROUPNAME is not null and 
        GROUPNAME <> '' and
        ACTIVE = 1 and
        (
            (SQLFUNCTIONCATALOG.ID is null)
            or dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED (
                SQLFUNCTIONCATALOG.SQLFUNCTIONSPECXML.query (
                    'declare namespace common="bb_appfx_commontypes";
                    /*/common:InstalledProductList'
                )
            ) = 1
        );

    return;
end