select distinct 'N' focusAccount, cdr.cdr_recordId, cdr.cdr_dstaddress1, cdr.cdr_dstaddress1, cdr.cdr_dstcity, cdr.cdr_dststate, cdr.cdr_dstzip, '' MFRCUSTNBR, ppl.principalId, 0 principalTerritoryId, 0 cdrContactId from tbl_CDR_Orders o inner join tblManufacturers m on m.mfr_Id = o.mfrId inner join tbl_CDR_Distributors cdr on cdr.cdr_recordId = o.distributorId inner join tbl_BRO_Principals ppl on ppl.mfrId = m.mfr_id and ppl.ownerId = cdr.ownerId and ppl.ownerType = cdr.fsl_tablecode where o.DistributorId = select focusAccount, cdr_recordId, cdr_dstaddress1, cdr_dstaddress1, cdr_dstcity, cdr_dststate, cdr_dstzip, MFRCUSTNBR, principalId, principalTerritoryId, cdrContactId from qmd_principalResources union select focusAccount, cdr_recordId, cdr_dstaddress1, cdr_dstaddress1, cdr_dstcity, cdr_dststate, cdr_dstzip, MFRCUSTNBR, principalId, principalTerritoryId, cdrContactId from qmd_mfrsWithOrders where not principalId in ( ) select m.mfr_name pplName, ppl.sortRank pplRank, ppl.principalId pplId, coalesce( cls.sortRank, 0 ) clsRank from tblManufacturers m inner join tbl_BRO_principals ppl on ppl.mfrId = m.mfr_id left outer join tbl_BPL_Classifications cls on cls.classificationId = ppl.classificationId where ppl.ownerId = and ppl.ownerType = and ppl.principalId in ( ) select focusAccount, cdr_recordId, cdr_dstaddress1, cdr_dstaddress1, cdr_dstcity, cdr_dststate, cdr_dstzip, MFRCUSTNBR, principalId, principalTerritoryId, cdrContactId from qmd_principalResources, qmd_principalRanking where qmd_principalRanking.pplId = qmd_principalResources.principalId order by clsRank desc, pplRank desc, pplName select * from qmd_stages where stateCode = 'O'

The Internal ID is unknown for "#htmleditformat( qmd_distributorDetails.cdr_dstName )#", as such Order and Stocking data are not available.

select count(*) as opportunityCount from qmd_opportunities_CDR where mfrid = select count(*) as opportunityCount from qmd_opportunities_OPR where mfrid = select o.orderno, o.orderdate, COUNT( distinct s.skuId ) orderSkuCount, SUM( o.qtySold ) orderQuantity, SUM( o.price ) orderTotal FROM tbl_CDR_Orders O INNER JOIN tbl_PRD_SKUs S ON S.OwnerId = O.OwnerId AND S.FSL_TableCode = O.OwnerType AND S.sku = O.MfrSku WHERE O.OwnerId = AND O.OwnerType = 'BRO' AND O.MfrId = AND O.distributorId = and o.orderDate = ( SELECT Max( o.orderDate ) FROM tbl_CDR_Orders O INNER JOIN tbl_PRD_SKUs S ON S.OwnerId = O.OwnerId AND S.FSL_TableCode = O.OwnerType AND S.sku = O.MfrSku WHERE O.OwnerId = AND O.OwnerType = 'BRO' AND O.Stocked = 'Y' AND O.MfrId = AND O.distributorId = ) group by o.orderno, o.orderdate SELECT count( distinct s.skuId ) skuCount FROM tbl_CDR_Orders O INNER JOIN tbl_PRD_SKUs S ON S.OwnerId = O.OwnerId AND S.FSL_TableCode = O.OwnerType AND S.sku = O.MfrSku WHERE O.OwnerId = AND O.OwnerType = 'BRO' AND O.Stocked = 'Y' AND O.MfrId = AND O.distributorId =

Manufacturer Name	MFR Cust. Num.	Opps.	Dist. Contact	Last Order Date	Last Order Amount	Stocked SKUs	Action
#htmleditformat( qmd_principal.mfrName )#	#htmleditformat( qmd_principalResources.mfrCustNbr )#	#lsNumberFormat( _principalOpps )#	--- select --- #htmleditformat( _name )# select * from qmd_distributorContacts where contactId = #_name# #_name# n/a	#lsdateformat( qmd_lastOrder.orderDate, "MM/DD/YYYY" )#	#lscurrencyformat( qmd_lastOrder.orderTotal )#	&##160;	$0.00	#lsnumberformat(qmd_checkStockingStatus.skuCount)#0	View Summary View Stocking #actionHTML#