SELECT COALESCE(mfr_BSR_ID,0) AS mfr_BSR_ID, COALESCE(cdr_territoryID,0) AS cdr_territoryID FROM tbl_CDR_Distributors WHERE cdr_recordId =

Assigned Rep: #salesContact.FIRSTNAME# #salesContact.LASTNAME# Title: #salesContact.CONTACTTITLE# Company: #salesContact.COMPANYNAME# Office: #salesContact.city#, #salesContact.state# Phone: #salesContact.phone#

#_htmlContentForPortlet#