select mfr_id, mfr_name from tblManufacturers where exists ( select * from tbl_OPR_ClientOperators where ownerId = mfr_id and fsltablecode = 'MFR' ) or exists ( select * from tbl_CDR_Distributors where ownerId = mfr_id and fsl_tablecode = 'MFR') order by mfr_name

Development Environment

Production Environment

DEMO Environment

Unsuporrted database select mfr_name, fseManagedAccess from tblManufacturers where mfr_id =

#htmleditformat( qmd_mfrProfile.mfr_name )#

Managed Access Level #val( qmd_mfrProfile.fseManagedAccess )#

select mfr_bsr_id, territoryId, operatorId, 0 opportunityId, 0 interactionId from tbl_OPR_ClientOperators where ownerId = and fsltablecode = 'MFR' and mfr_bsr_id > 0 and territoryId > 0 select salesPersonUserId mfr_bsr_id, territoryId, 0 operatorId, opportunityId, 0 interactionId from tbl_OPR_ClientOperators opr inner join tbl_SPL_Opportunities spl on spl.partnerId = opr.operatorId and spl.partnerType = 'OPR' and spl.ownerId = opr.ownerId and spl.ownerType = opr.fsltablecode where opr.ownerId = and opr.fsltablecode = 'MFR' and spl.salesPersonUserId > 0 and territoryId > 0 select dispositionUserId mfr_bsr_id, territoryId, 0 operatorId, 0 opportunityId, interactionId from tbl_OPR_ClientOperators opr inner join tbl_CRM_interactions i on i.partnerId = opr.operatorId and i.partnerType = 'OPR' and i.ownerId = opr.ownerId and i.ownerType = opr.fsltablecode where opr.ownerId = and opr.fsltablecode = 'MFR' and i.dispositionUserId > 0 and i.disposition = '?' and territoryId > 0 select mfr_bsr_id, territoryId, operatorId, opportunityId, interactionId from qmd_operators union select mfr_bsr_id, territoryId, operatorId, opportunityId, interactionId from qmd_opportunities union select mfr_bsr_id, territoryId, operatorId, opportunityId, interactionId from qmd_interactions order by territoryId, mfr_bsr_id select t.name, t.internalSalesId, b.broker_name from tbl_TER_Territories t left outer join tbl_SMA_BrokerOfficeLink bol on bol.territoryId = t.territoryId and bol.mfr_id = t.ownerId and bol.primaryOffice = 'Y' left outer join tblBrokers b on b.broker_id = bol.brokerId where t.territoryId = select bo.broker_office_name, bol.primaryOffice from tbl_SMA_BrokerOfficeLink bol inner join tblBrokerOffices bo on bo.broker_id = bol.brokerId and bo.broker_office_id = bol.brokerofficeid where bol.territoryId = and bol.mfr_id = order by primaryOffice desc, broker_office_name #_detailsHTML#

Company	Current Assignment	Operators	Opps.	Calls	Company	Correct Assignment
#htmleditformat( qmd_salesPerson.companyName )# #htmleditformat( qmd_salesPerson.companyName )#	#htmleditformat( qmd_salesPerson.firstName )# #htmleditformat( qmd_salesPerson.lastName )# <#htmleditformat( qmd_salesPerson.email )#> no email address select broker_office_name, broker_office_id from tblBrokerOffices where broker_office_id in ( ) Offices: #htmleditformat( valueList( qmd_offices.broker_office_name ))# select groupTypeCd, groupName from tbl_SEC_Groups where groupId in ( ) and groupTypeCd in ( 'MRR', 'MPR' ) order by groupTypeCd, groupName Roles: #htmleditformat( valueList( qmd_groups.groupName ))#	Unknown UserId: #htmleditformat( mfr_bsr_Id )# - Probably Deleted	#lsnumberformat( _badOperators )#	#lsnumberformat( _badOpportunities )#	#lsnumberformat( _badInteractions )#	Skipping (but questionable)	#htmleditformat( qmd_customerManager.companyName )#	#htmleditformat( qmd_customerManager.firstName )# #htmleditformat( qmd_customerManager.lastName )# <#htmleditformat( qmd_customerManager.email )#>	Unset
Territory: #htmleditformat( qmd_territory.name )# (#htmleditformat( qmd_territory.internalSalesId )#) - #htmleditformat( qmd_territory.broker_name )# - Offices: None #htmleditformat( valueList( qmd_brokerOffices.broker_office_name ))#