select territoryId from request.qmd_userTerritoryHierarchy where parentTerritoryId = select name territoryName, territoryId from tbl_TER_Territories where ownerId = and fsl_tablecode = and territoryId =

			#htmleditformat( _currentParentName )# &##160; &##160;	#htmleditformat( _currentParentName )# &##160; &##160;
Manufacturer	P	Active Markets	#htmleditformat( ucase( internalSalesId ))# #htmleditformat( ucase( territoryName ))# #htmleditformat( _territoryDisplay )#
			All Active Pending Inactive
#htmleditformat( mfrName )#	#listFind( "*,A,B,C,D", mfrPriority)#A+#mfrPriority#	#activeMarkets#