select distinct mfr.mfr_name, mfr.mfr_id, ter.territoryId, ter.name territoryName from tbl_TER_Territories ter inner join tbl_TER_BusinessPlans tbp on tbp.territoryId = ter.territoryId and tbp.ownerId = ter.ownerId and tbp.ownerType = ter.fsl_tablecode inner join tblManufacturers mfr on mfr.mfr_id = ter.ownerId where ter.fsl_tablecode = 'MFR' order by mfr.mfr_name, territoryName
Territory:
Recalcuate Baselines:
Recalcuate Budgets:
Recalcuate Actuals:
Recalcuate Pipeline:
Fiscal Year: