SELECT DISTINCT ManufacturerCode, ManufacturerId, ManufacturerName FROM qcf_orderDetail ORDER BY ManufacturerName select objectid as mfrid from tbl_import_aliases where ownerid = and ownertype = and objecttype = 'mfrid' and alias in () 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, ppl.mfrId from tbl_CDR_Distributors cdr Left join tbl_BRO_Principals ppl on ppl.mfrId IN () and ppl.ownerId = cdr.ownerId and ppl.ownerType = cdr.fsl_tablecode where cdr.cdr_recordId = select focusAccount, cdr_recordId, cdr_dstaddress1, cdr_dstaddress1, cdr_dstcity, cdr_dststate, cdr_dstzip, MFRCUSTNBR, principalId, principalTerritoryId, cdrContactId, 0 mfrid, hirestatus from qmd_principalResources union select focusAccount, cdr_recordId, cdr_dstaddress1, cdr_dstaddress1, cdr_dstcity, cdr_dststate, cdr_dstzip, MFRCUSTNBR, principalId, principalTerritoryId, cdrContactId, mfrid, 'P' hirestatus from qmd_mfrsWithOrders where not principalId in ( ) SELECT * FROM qmd_principalResources WHERE principalTerritoryId > 0 AND NOT hirestatus = 'I' select DISTINCT m.mfr_name pplName, ppl.sortRank pplRank, ppl.principalId pplId, coalesce( cls.sortRank, 0 ) clsRank, ppl.priority, m.mfr_id mfrid, (SELECT TOP 1 alias FROM tbl_IMPORT_Aliases ala WHERE ala.ownerid = ppl.ownerid AND ala.ownerType = ppl.ownerType AND ala.objectId = m.mfr_id AND ala.objectType = 'MFRID' ) as mfrCode 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, qmd_principalRanking.mfrid, upper( qmd_principalRanking.pplName ) nameSort, qmd_principalRanking.priority, qmd_principalRanking.priorityRank, qmd_principalranking.mfrCode from qmd_principalResources, qmd_principalRanking where qmd_principalRanking.pplId = qmd_principalResources.principalId order by qmd_principalRanking.priorityRank, qmd_principalRanking.pplRank, nameSort SELECT FSPro_UserID contactID, FirstName, LastName, Title, Email, caJobFunction FROM qmd_distributorContacts ORDER BY LastName, FirstName 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 SUM(CASE WHEN O.StockingStatus = 'Y' THEN 1 ELSE 0 END) as OpenCnt , SUM(CASE WHEN O.StockingStatus = 'N' THEN 1 ELSE 0 END) as ClosedCnt, SUM(CASE WHEN O.StockingStatus = 'S' THEN 1 ELSE 0 END) as SpecialCnt FROM tbl_CDR_Stocking O INNER JOIN dbo.tbl_PRD_SKUs S ON S.Skuid = O.SkuId WHERE O.OwnerId = AND O.OwnerType = 'BRO' AND O.cdr_recordId = AND O.StockingStatus IN ('Y','N','S') AND S.OwnerId = AND S.FSL_TableCode = 'BRO' AND S.mfrId = #qmd_principal.mfrName# (A+#qmd_principal.priority#) View Summary View Stocking #actionHTML#   --->

Manufacturer Name (Priority)	MFR Cust #	Primary Buyer	Plan Opps	Last Order Date	Last Order Amount	Open SKUs	Closed SKUs	Sp. Ord SKUs	Action
#htmleditformat(_mfrDisplayName )#	#htmleditformat( qmd_principalResources.mfrCustNbr )##htmleditformat( qmd_principalResources.mfrCustNbr )#&##160;	--- select --- #htmleditformat( _name )# select * from qmd_distributorContacts where contactId = #_name# #_name# n/a	#lsNumberFormat( _principalOpps )#	#lsnumberformat(qmd_checkStockingStatus.OpenCnt)#	#lsnumberformat(qmd_checkStockingStatus.ClosedCnt)#	#lsnumberformat(qmd_checkStockingStatus.SpecialCnt)#