Step 3: #_end-_start# ms
Step 4: #_end-_start# ms select fsp.ownerid, fsp.fsl_tablecode ownertype, bro.BrokerAbbrevName from tbl_fspro_members fsp with (nolock) left outer join tblbrokers bro with (nolock) on bro.broker_id = fsp.ownerid and fsp.fsl_tablecode = 'bro' where fspro_userid =
Step 5: #_end-_start# ms select case when opp.partnertype = 'opr' then opr.address else cdr.cdr_dstaddress1 end as address, case when opp.partnertype = 'opr' then opr.city + ' ' + opr.state + ', ' + opr.zipcode else cdr.cdr_dstcity + ' ' + cdr.cdr_dststate + ', ' + cdr.cdr_dstzip end as citystatezip from tbl_spl_opportunities opp with (nolock) left outer join tbl_opr_clientoperators opr with (nolock) on opr.OperatorID = opp.partnerid and opp.partnertype = 'opr' left outer join tbl_cdr_distributors cdr with (nolock) on cdr.cdr_recordid = opp.partnerid and opp.partnertype = 'cdr' where opp.ownerid = and opp.ownertype = and opp.opportunityid =
Step 6: #_end-_start# ms select brokerWorkflowRequestList, internalWorkflowRequestList from tbl_WRK_Territories with (nolock) where ownerid = and ownertype = and territoryid =
select * from qryActionItemsOpen union select * from qryActionItemsComplete order by sortGroup, sortDate
Account #qmd_opportunities.companyname# #qmd_opportunities.companyname#
#qryAccountInfo.address#
#qryAccountInfo.citystatezip#
#qmd_opportunities.mfrname#
#qmd_opportunities.companyname# #qmd_opportunities.companyname#
#qryAccountInfo.address#
#qryAccountInfo.citystatezip#
Opportunity #htmleditformat(_oppName)#
Opp. Type #qmd_opportunities.typeName#
Item #qmd_opportunityDetails.sku# - #htmleditformat(_skuDesc)#
Sales Rep #qmd_opportunities.salespersonfirstname# #qmd_opportunities.salespersonlastname# #qmd_opportunities.salespersonfirstname# #qmd_opportunities.salespersonlastname#
#qryRepInfo.BrokerAbbrevName#

Request Update
Est Volume
LTO #qmd_opportunities.durationamt# wks
#numberformat(qmd_opportunities.caseamt,"9,999")# cs
#numberformat(qmd_opportunities.weightamt,"9,999")# lbs
#numberformat(qmd_opportunities.incomeamt,"9,999")# dollars
Order Date #dateformat(qmd_opportunities.availabledate,"mm/dd/yyyy")#
#daysAgoDisplay#
Status #qmd_opportunities.stagename# #(val(qmd_opportunities.likelihoodpercent))*100#%
Distributor #qmd_opportunities.cdr_dstname#
Actionable Next Steps
#_disposition#: #taskdescription# by #dateformat(duedate,"mm/dd/yy")# R
Note: #tasknotes#