select territoryId from request.qmd_userTerritoryHierarchy where localMarket = 1 and territoryId in ( ) select targetVolume as tyBudget, actualVolume as tyActual, remainingBaselineVolume as lyActual, planVolumeImpact as tyImpact , ytdRunRateVol as ytdRunRate, remainingBudgetVol as remainingBudget, runRateNeededVol as runRateNeeded, weeklyGapVol as weeklyGap, potentialGapVol as potentialGap, remainingGrowthVol as remainingGrowth targetValue as tyBudget, actualValue as tyActual, remainingBaselineValue as lyActual, planValueImpact as tyImpact , ytdRunRateVal as ytdRunRate, remainingBudgetVal as remainingBudget, runRateNeededVal as runRateNeeded, weeklyGapVal as weeklyGap, potentialGapVal as potentialGap, remainingGrowthVal as remainingGrowth from qmd_hierarchyRollup where territoryId = select targetVolume as tyBudget, actualVolume as tyActual, remainingBaselineVolume as lyActual, planVolumeImpact as tyImpact , ytdRunRateVol as ytdRunRate, remainingBudgetVol as remainingBudget, runRateNeededVol as runRateNeeded, weeklyGapVol as weeklyGap, potentialGapVol as potentialGap, remainingGrowthVol as remainingGrowth targetValue as tyBudget, actualValue as tyActual, remainingBaselineValue as lyActual, planValueImpact as tyImpact , ytdRunRateVal as ytdRunRate, remainingBudgetVal as remainingBudget, runRateNeededVal as runRateNeeded, weeklyGapVal as weeklyGap, potentialGapVal as potentialGap, remainingGrowthVal as remainingGrowth from qmd_hierarchyRollup_detail where territoryId = and subjectId = select stageId from qmd_rawStages where stageId in () statusCode in ( ) order by likelihoodPercent select sum( volumeImpactvalueImpact ) tyImpact, count(distinct opportunityId) opportunityCount from qmd_oprOpportunities select sum( volumeImpactvalueImpact ) tyImpact, count(distinct opportunityId) opportunityCount from qmd_cdrOpportunities select #_columnList# from qmd_oprOpportunities union select #_columnList# from qmd_cdrOpportunities union select #_columnList# from qmd_overlapOpportunities select sum( volumeImpactvalueImpact ) tyImpact, count(distinct opportunityId) opportunityCount from qmd_overlapPipeline select sum( volumeImpactvalueImpact ) tyImpact, count(distinct opportunityId) opportunityCount from qmd_oprOpportunities
  #_numericHeading#
Local Market Plan Status A. O. P. TY Actual LY Act. Bal. Opps. TY Plan Bal. TY Est. Tot. TY Est. Var. %
DistributorOperatorCurrent Year Forecast (note)Current Year Forecast (note) #lsnumberFormat(qmd_salesLookup.tyBudget)# #lsnumberformat(qmd_salesLookup.tyActual)# #lsnumberformat(qmd_salesLookup.lyActual)# #lsNumberformat( _opportunityCount )# #lsnumberformat(_planImpact)# #lsnumberformat(_projection)# #lsnumberformat(_planVar)# #numberformat(_planVarPct,"(9.9)")# DistributorOperatorCurrent Year Forecast (note)Current Year Forecast (note) 0 0 0 #lsNumberformat( _opportunityCount )# #lsnumberformat(_planImpact)# 0 0 0
select territoryId from request.qmd_localHierarchy where parentTerritoryId in ( )