USP_BATCHTEMPLATE_TEMPLATESTOPROCESS

CREATE procedure dbo.USP_BATCHTEMPLATE_TEMPLATESTOPROCESS(@BATCHTYPECATALOGID uniqueidentifier)
as
set nocount on;

select BATCHTEMPLATE.ID, BATCHTEMPLATE.NAME, BATCHTEMPLATE.DESCRIPTION, BATCHTEMPLATE.ADDROWDATAFORMINSTANCEID,   
    BATCHTEMPLATE.EDITROWDATAFORMINSTANCEID, BATCHTEMPLATE.COMMITROWADDDATAFORMINSTANCEID, BATCHTEMPLATE.COMMITROWEDITDATAFORMINSTANCEID,  
    BATCHTEMPLATE.COMMITROWEDITDATAFORMIDFIELD, BATCHTEMPLATE.ROWRECORDOPERATIONID, BATCHTEMPLATE.ROWCONTEXTVIEWDATAFORMINSTANCEID, 
    BATCHTEMPLATE.ROWCONTEXTEDITDATAFORMINSTANCEID, BATCHTEMPLATE.FORMDEFINITIONXML, BATCHTEMPLATE.BATCHWORKFLOWID, BATCHTEMPLATE.CUSTOM, 
    BATCHTEMPLATE.SITEID  
from dbo.BATCHTEMPLATE  
where BATCHTEMPLATE.BATCHTYPECATALOGID = @BATCHTYPECATALOGID
and BATCHTEMPLATE.ACTIVE = 1
and (BATCHTEMPLATE.CUSTOM = 0 or exists (select ID from dbo.BATCH where BATCH.BATCHTEMPLATEID = BATCHTEMPLATE.ID and BATCH.STATUSCODE in (0, 3)))
order by BATCHTEMPLATE.NAME;