select processId from tbl_WRK_ProcessDefinitions where processCode = 'ERF' and ownerId = and ownerType = select fspro_userid from tbl_FSPRO_members where ownerID = and fsl_tablecode = and email = 'smuckercanada.service@jmsmucker.com' select i.processId, i.processInstanceId, i.status, i.statusComment, i.statusDetail, i.partnerId, i.partnerType, i.referenceNbr, i.userId, i.startTime, opr.companyName customerName, opr.address address, opr.address2 address2, opr.city city, opr.state state, opr.zipcode zipCode, case when opr.mdmType = 'CBS' then opr.mdmId else '' end CBSCID , rep.FileId from tbl_WRK_ProcessInstances i inner join tbl_OPR_ClientOperators opr on opr.operatorId = i.partnerId and opr.ownerId = i.ownerId and opr.fsltablecode = i.ownerType left outer join tbl_WRK_Repository rep on rep.ownerID = AND rep.ownerType = AND rep.containerID = i.processInstanceId AND rep.containerType = 'WPI' AND rep.hiddenFile = 'N' AND rep.internalOnly = 'N' where i.ownerId = and i.ownerType = and i.processId = and i.archive = 'N' and i.partnerType = 'OPR' and i.status <> 'CANCELLED' and opr.countryid = 5 and i.startTime > dateadd(day, -59, getdate()) order by #_sortColumn# select i.processId, i.processInstanceId, i.status, i.statusComment, i.statusDetail, i.partnerId, i.partnerType, i.referenceNbr, i.userId, i.startTime, opr.companyName customerName, opr.address address, opr.address2 address2, opr.city city, opr.state state, opr.zipcode zipCode, case when opr.mdmType = 'CBS' then opr.mdmId else '' end CBSCID , rep.FileId from tbl_WRK_ProcessInstances i inner join tbl_OPR_ClientOperators opr on opr.operatorId = i.partnerId and opr.ownerId = i.ownerId and opr.fsltablecode = i.ownerType left outer join tbl_WRK_Repository rep on rep.ownerID = AND rep.ownerType = AND rep.containerID = i.processInstanceId AND rep.containerType = 'WPI' AND rep.hiddenFile = 'N' AND rep.internalOnly = 'N' where i.ownerId = and i.ownerType = and i.processId = and i.archive = 'N' and i.partnerType = 'OPR' and i.status <> 'CANCELLED' and opr.territoryId in ( ) and i.startTime > dateadd(day, -59, getdate()) order by #_sortColumn# select distinct userId from qmd_erfStatus where userId > 0 select fspro_userId, firstName, lastName from tbl_FSpro_members where fspro_userId in ( ) order by lastName, firstName select * from qmd_erfStatus where userId = order by starttime desc select top 1 fileName from tbl_EAI_inboundBatches where fileFormat = 'JMS_ERF_STATUS_XLSX' and status = 'OK' and ownerid = and ownerType = order by batchId desc

#htmleditformat( _sourceFileTitle )# #htmleditformat( _sourceFileTitle )# not available Requestor:

--->

Status	Sub Status/Comment	Customer/Address/CBSC ID	Start Date	Action
RejectedNewActive#status#	#htmleditformat( _statusDetail2.messages[_mx] )# Ready for Submission Not Ready #htmleditformat( _statusDetail2.messages[_mx] )# #htmleditformat( _statusDetail2.messages[_mx] )#	#htmleditformat( customerName)# #htmleditformat( address)# , #htmleditformat( address2)# #htmleditformat( city)#, #htmleditformat( state)# #htmleditformat( zipCode)# #htmleditformat( cbscid )#	#LSDateFormat( startTime, "m/d/yyyy")#	#_initiateHTML#&##160;
ClosedCancelledField Support Update	Closed - Install Complete Dispatched - Install Scheduled #lsdateformat( dateadd( 'D', 0, _statusDetail.appointment_date ), "MM/DD/YYYY" )#tbd Pending - Request Received Open - #htmleditformat( _statusDetail.reasonCode )# Hold - Awaiting Customer Response #htmleditformat( _statusDetail.hold_reason )# Cancelled - Request Cancelled #htmleditformat( _statusDetail.order_status )# #htmleditformat( _statusDetail.order_status )#	#htmleditformat( customerName )# #htmleditformat( address)# , #htmleditformat( address2)# #htmleditformat( city)#, #htmleditformat( state)# #htmleditformat( zipCode)# #htmleditformat( cbscid )#	#LSDateFormat( startTime, "m/d/yyyy")#	#_initiateHTML#&##160;