select ownerid from tbl_tpm_requests with (nolock) where requestid = select operatorID as id, companyName as companyname, address as address1, address2 as address2, city as city, state as state, zipcode as zipcode from tbl_opr_clientoperators with (nolock) where operatorID = and ownerid = and fsltablecode = select cdr_recordid as id, cdr_dstname as companyname, cdr_dstaddress1 as address1, cdr_dstaddress2 as address2, cdr_dstcity as city, cdr_dststate as state, cdr_dstzip as zipcode from tbl_CDR_Distributors with (nolock) where cdr_recordid = and ownerid = and fsl_tablecode = select firstname, lastname, email from tbl_tpm_requestpartners tp with (nolock) inner join tbl_fspro_members fsp with (nolock) on fsp.fspro_userid = tp.contactid and fsp.ownerid = tp.ownerid and fsp.fsl_tablecode = tp.ownertype where tp.ownerid = and tp.ownertype = and tp.requestid = select mfr_name from tblmanufacturers with (nolock) where mfr_id = select sku.skuid, sku.sku, sku.skuDesc, sku.packSizeDesc, rp.allowanceAmt, rp.estAnnualVolume from tbl_tpm_requestproducts rp with (nolock) inner join tbl_prd_skus sku with (nolock) on sku.skuid = rp.catalogid and sku.ownerid = rp.ownerid and sku.fsl_tablecode = rp.ownertype where rp.ownerid = and rp.ownertype = and rp.requestid = and rp.catalogtype = 'sku' order by sku.sku

Account

#qryRequest.primaryPartnerName#
#qryaccount.address1#
#qryaccount.address#
#qryaccount.city# #qryaccount.state#, #qryaccount.zipcode#

Contact

#qryContact.firstname# #qryContact.lastname#

Description

#qryRequest.description#

#qryMfrName.mfr_name#

Distributor

#qmd_secondaryPartners.partnername#

Details

Status	#lcase(qryRequest.status)#
Type	#qryRequest.requestType#
Start	#dateformat(qryRequest.startdate,"mm/dd/yyyy")#
End	#dateformat(qryRequest.enddate,"mm/dd/yyyy")#
#qryRequest.comments#

Items


#qryProducts.sku# - #qryProducts.skuDesc# #qryProducts.packSizeDesc#
Rate: #numberformat(qryProducts.allowanceAmt,"9.99")#	Cs Yr: #numberformat(qryProducts.estAnnualVolume,"9,999")#