select * from tbl_WRK_userRequestTypes where requestType = 'smuckersMonthlyBusinessReview' insert into tbl_WRK_UserRequestTypes( requestType, handlerTemplatePath, ttlDays, requestTypeName, expireDisposition ) values ( 'smuckersMonthlyBusinessReview', '/mstrcfmod/MFR26/monthlyBusinessReview', 3, 'Monthly Business Review', 'X' ) select ter.ownerId, ter.fsl_tablecode, ter.territoryId, ter.name territoryName, ter.primaryManager, m.fspro_userid, m.firstname, m.lastName, m.email, m.title from tbl_TER_Territories ter inner join tbl_FSpro_members m on m.fspro_userid = ter.primaryManager and m.ownerId = ter.ownerId and m.fsl_tablecode = ter.fsl_tablecode inner join tbl_TER_TerritoryLevels l on l.levelId = ter.levelId and l.ownerId = ter.ownerId and l.fsl_tablecode = ter.fsl_tablecode where l.ownerId = 26 and l.fsl_tablecode = 'MFR' and l.rank = 4 and l.ownerId = and l.fsl_tablecode = and ter.internalSalesId in ( ) order by territoryName select requestId from tbl_WRK_UserRequests where requestAnnotation = and ownerId= and ownerType = and requestSubject = 'Monthy Business Review Ready for Review' and toUserId =

Monthly Business Reviews Generated

Region	RSM	Period	Due Date
#htmleditformat( territoryName )#	#htmleditformat( firstName )# #htmleditformat( lastName )#	#htmleditformat( _reportingPeriod.name )#	#lsdateformat( _responseDueDate, "MM/DD/YYYY" )#
#htmleditformat( territoryName )#	#htmleditformat( firstName )# #htmleditformat( lastName )#	#htmleditformat( _reportingPeriod.name )#	SKIPPED