select distinct cdrRecordId from qmd_proofOfDelivery where cdrRecordId > 0 select distinct contentId from tbl_TPM_proofOfDelivery with (nolock) where claimId = and contractNbr = and ownerId = and ownerType = #chr(10)##chr(10)##chr(10)##chr(10)#=== EDIT ABOVE THIS LINE ===#chr(10)##trim( qmd_task.taskNotes )# #trim( qmd_task.taskNotes )#

select taskTypeId, taskTypeName, taskTypeDescription from tbl_WRK_TaskTypes where ownerType = and ownerID = select taskTypeName, taskTypeDescription from tbl_WRK_TaskTypes where ownerType = and ownerID = and taskTypeId =

Claimant:	#htmleditformat( qmd_claimPartner.partnerName )# #htmleditformat( qmd_claimPartner.city )#, #htmleditformat( qmd_claimPartner.state )#
Contract:	#htmleditformat( qmd_tpmRequest.primaryPartnerName )# #htmleditformat( qmd_tpmRequest.assignedContractNbr )# - #htmleditformat( qmd_tpmRequest.description )# Assigned To: #htmleditformat( qmd_contractChain.firstName )# #htmleditformat( qmd_contractChain.lastName )# Unassigned Account na
Assign To:	select distinct m.firstName, m.lastName, m.email, m.fspro_userid from tbl_Fspro_members m inner join tbl_SEC_MemGrpLink mgl on mgl.fspro_userId = m.fspro_userid inner join tbl_SEC_Groups g on g.groupId = mgl.groupId and g.ownerId = m.ownerId and g.fsl_tablecode = m.fsl_tablecode where m.ownerId = and m.fsl_tablecode = and nullif( m.email, '' ) is not null and m.loginEnabled = 1 and g.internalNotes like '%universalTradeSupportUsers%' order by m.firstName, m.lastName
Task Type:
Respond By:	&##160;&##160; Claim Critical
Task:	#htmleditformat( _taskDescription )# #2000 - Len( _taskDescription )# remaining
Acknowledge:
Response:	#htmleditformat( _taskNotes2 )#
Response:	#htmleditformat( _taskNotes2 )#
&##160;	Include: Contract (pdf) #htmleditformat( _docTitle )# (view #lcase( listlast( fileName, "." ))#) #htmleditformat( _docTitle )# (view #lcase( listlast( fileName, "." ))#) checked="checked" />Full Claim (pdf) checked="checked" />Critical Variances (pdf) #htmleditformat( qmd_tpmRequest.primaryPartnerName )# Files #htmleditformat( _docTitle )# (view #lcase( listlast( fileName, "." ))#) #htmleditformat( qmd_claim.partnerName )# Files #htmleditformat( _docTitle )# (view #lcase( listlast( fileName, "." ))#)
Notify:	#rereplace( _selectHTML, "selected=""selected""", "", "ALL" )# #rereplace( _selectHTML, "selected=""selected""", "", "ALL" )# multiple email addresses separated by commas