USP_DATALIST_BATCH2WORKFLOWS

CREATE procedure dbo.USP_DATALIST_BATCH2WORKFLOWS
as
    set nocount on;

    with BATCHWORKFLOWS_CTE as (
        select distinct
            BATCHTEMPLATE.BATCHWORKFLOWID,
            case
                when exists (
                    select null  
                    from
                        dbo.V_INSTALLED_BATCHTYPECATALOG
                    where
                        V_INSTALLED_BATCHTYPECATALOG.ID = BATCHTEMPLATE.BATCHTYPECATALOGID
                    ) then 1
                else 0
            end as INSTALLEDPRODUCT
        from
            dbo.BATCHTEMPLATE
        where
            BATCHTEMPLATE.CUSTOM = 0 
    )
    select 
        BATCHWORKFLOW.ID, 
        BATCHWORKFLOW.NAME
    from 
        dbo.BATCHWORKFLOW
    left join 
        BATCHWORKFLOWS_CTE on BATCHWORKFLOWS_CTE.BATCHWORKFLOWID = BATCHWORKFLOW.ID
    where
        INSTALLEDPRODUCT is null or INSTALLEDPRODUCT = 1
    order by 
        BATCHWORKFLOW.NAME;