select t.territoryId, t.name territoryName from tbl_TER_Territories t where t.ownerId = and t.fsl_tablecode = and exists ( select * from tbl_BRO_PrincipalTErritoryResources ptr where ptr.resourceId = t.territoryId and ptr.resourceType = 'TER' ) order by territoryName select salesChannelId, channelName from tbl_PRD_SalesChannels where ownerId = and ownerType = order by sortRank, channelName
Territories Channels Template
Page #_p# of #ArrayLen( _pages )#
#_item# &##160;