USP_SIMPLEDATALIST_BATCH2WORKFLOW

CREATE procedure dbo.USP_SIMPLEDATALIST_BATCH2WORKFLOW
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 value, 
        BATCHWORKFLOW.NAME label 
    from 
        dbo.BATCHWORKFLOW
    join 
        dbo.BATCHWORKFLOWSTATE on BATCHWORKFLOW.ID = BATCHWORKFLOWSTATE.BATCHWORKFLOWID        
    left join 
        BATCHWORKFLOWS_CTE on BATCHWORKFLOWS_CTE.BATCHWORKFLOWID = BATCHWORKFLOW.ID        
    where 
        (BATCHWORKFLOWS_CTE.INSTALLEDPRODUCT is null or BATCHWORKFLOWS_CTE.INSTALLEDPRODUCT = 1) and
        BATCHWORKFLOWSTATE.ISINITIALSTATE = 1
    order by 
        label;