PRODUCTION

DEVELOPMENT

select b.broker_id as pkId, b.broker_name as companyName from tblBrokers b where exists ( select * from tbl_LIB_Companies where companyPKeyId = broker_id and companyPType = 'BRO' ) and b.broker_id <> 1665 order by broker_name select c.cho_id as pkId, c.cho_name as companyName from tbl_CHO_Operators c where exists ( select * from tbl_LIB_Companies where companyPKeyId = cho_id and companyPType = 'CHO' ) order by cho_name select d.dstId as pkId, d.dstName as companyName from tbl_DST_Distributors d where exists ( select * from tbl_LIB_Companies where companyPKeyId = dstId and companyPType = 'DST' ) order by dstName select m.mfr_id as pkId, m.mfr_name as companyName from tblManufacturers m where exists ( select * from tbl_LIB_Companies where companyPKeyId = mfr_id and companyPType = 'MFR ' ) and m.mfr_id <> 1984 order by mfr_name #htmleditformat( _l )#

select dst.dstid, dst.dstname, dst.dstaddr1, dst.dstaddr2, dst.dstcity, dst.dststate, dst.dstzip, dst.dstcountryid, dst.dstcompanyType, cdr.cdr_recordId, cdr.cdr_dstName, cdr.cdr_dstAddress1, cdr.cdr_dstAddress2, cdr.cdr_dstCity, cdr.cdr_dstState, cdr.cdr_dstZip, cdr.cdr_dstCountryId, cdr.cdr_dstCompanyType from tbl_DST_Distributors dst left outer join tbl_CDR_Distributors cdr on cdr.fsl_dstId = dst.dstid and cdr.ownerId = and cdr.fsl_tablecode = where 1 = 2 or dst.dstCompanyType = 'P' or dst.dstCompanyType = 'B' union select byg.uniqueId dstId, byg.name dstName, '' dstaddr1, '' dstaddr2, '' dstcity, '' dststate, '' dstzip, 0 dstcountryid, 'G' dstcompanyType, cdr.cdr_recordId, cdr.cdr_dstName, cdr.cdr_dstAddress1, cdr.cdr_dstAddress2, cdr.cdr_dstCity, cdr.cdr_dstState, cdr.cdr_dstZip, cdr.cdr_dstCountryId, cdr.cdr_dstCompanyType from tbl_BYG_BuyingGroups byg left outer join tbl_CDR_Distributors cdr on cdr.fslbuyingGroupId = byg.uniqueId and cdr.ownerId = and cdr.fsl_tablecode = where 1 = 2 or 1 = 1 order by dstName select broker_name as companyName from tblbrokers where broker_id = select cho_name as companyName from tbl_CHO_Operators where cho_id = select dstName as companyName from tbl_DST_Distributors where dstId = select mfr_name as companyName from tblManufacturers where mfr_id =

Invalid #_ownerType#

	Distributor HQ	#htmleditformat( qmd_company.companyName )# Distributor
	#htmleditformat( dstName )# Buying GroupOther(#dstCompanyType#) #htmleditformat( dstAddr1 )# #htmleditformat( dstAddr2 )# #htmleditformat( dstCity )#, #htmleditformat( dstState )# #htmleditformat( dstZip )# INTERNATIONAL	#htmleditformat( cdr_dstName )# #cdr_recordId# #htmleditformat( cdr_dstAddress1 )# #htmleditformat( cdr_dstAddress2 )# #htmleditformat( cdr_dstCity )#, #htmleditformat( cdr_dstState )# #htmleditformat( cdr_dstZip )# INTERNATIONAL &##160;