USP_DATALIST_BATCHWORKFLOWS

create procedure dbo.USP_DATALIST_BATCHWORKFLOWS
as                
    select [BATCHWORKFLOW].[ID], [BATCHWORKFLOW].[NAME], [BATCHTYPECATALOG].[NAME]
        from dbo.[BATCHWORKFLOW] 
        inner join dbo.[BATCHTYPECATALOG] on [BATCHWORKFLOW].[BATCHTYPECATALOGID] = [BATCHTYPECATALOG].[ID]
        where
        1 = dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED
        (
            BATCHTYPECATALOG.SPECXML.query
                (
                    'declare namespace common="bb_appfx_commontypes";
                    /*/common:InstalledProductList'
                )
        )
        order by [BATCHWORKFLOW].[NAME];