USP_SIMPLEDATALIST_SEARCHLISTS

CREATE procedure dbo.USP_SIMPLEDATALIST_SEARCHLISTS
(
    @RECORDTYPE nvarchar(100) = '',
    @REQUIRELOOKUPVIEW bit = 0
) 
as                
    set nocount on;

    select 
        V_INSTALLED_SEARCHLISTCATALOG.ID as VALUE, 
        V_INSTALLED_SEARCHLISTCATALOG.UINAME as LABEL 
    from 
        dbo.V_INSTALLED_SEARCHLISTCATALOG
        inner join dbo.RECORDTYPE on RECORDTYPE.ID = V_INSTALLED_SEARCHLISTCATALOG.RECORDTYPEID
    where 
        (
            RECORDTYPE.NAME = @RECORDTYPE or @RECORDTYPE = ''
        )
        and
        (
            @REQUIRELOOKUPVIEW = 0
            or
            1 = V_INSTALLED_SEARCHLISTCATALOG.SEARCHLISTSPEC.exist
                (
                    'declare namespace bb="bb_appfx_searchlist";
                    /bb:SearchListSpec/bb:LookupView'
                )
        )
    order by 
        V_INSTALLED_SEARCHLISTCATALOG.UINAME;