V_QUERY_BATCHWORKFLOW

/*
Generated by Blackbaud AppFx Platform
Date:  11/11/2014 4:08:41 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_BATCHWORKFLOW AS



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