MFR Client is not configured to run this process (apps.distributorSalesData.enabled).

select distinct s.cdr_recordId, s.skuId, s.stockingStatus /* s.stockingId, s.cdr_recordId, s.skuId, s.stockingStatus, s.lastUpdated, s.lastUpdatedBy, s.sourceId, s.sourceType, s.volumetime, s.volumeqty, s.createDate, s.lastUpdateSource */ from tbl_CDR_Stocking s with (nolock) where ownerType = and ownerId = and exists( select skuid from tbl_OFS_BrokerSkus bs with (nolock) where bs.skuid = s.skuid and bs.ownerid = s.ownerid and bs.ownerType = s.ownerType) /* and s.skuid = 2918715 */ /* and s.skuid = 8276 sysco eastern */ /* and s.skuid = 8275 */ select ownerId, ownerType, parameterName, parameterValue from fsenablers..tbl_APP_Configurations with (nolock) where applicationCode = 'MOBILE' and parameterName = 'apps.opr.mfrSalesDataSyndication.enabled' and parameterValue = 'true' and ownerType = 'BRO' and ownerId > 0 select broker_name from tblBrokers b with (nolock) where b.broker_id = select cdr.fsl_dstId, cdr.cdr_territoryId, cdr.cdr_dstName from tbl_CDR_Distributors cdr with (nolock) where cdr.fsl_TableCode = and cdr.ownerId = and cdr.cdr_recordId = select s.skuid, s.sku, s.skudesc from tbl_PRD_Skus s with (nolock) where s.fsl_TableCode = and s.ownerId = and s.skuid = select s.skuid from tbl_PRD_Skus s with (nolock) where s.fsl_TableCode = and s.ownerId = and s.mfrSkuid = select cdr.cdr_recordId, cdr.fsl_dstId, cdr.cdr_territoryId, cdr.cdr_dstName from tbl_CDR_Distributors cdr with (nolock) where cdr.fsl_TableCode = and cdr.ownerId = and cdr.fsl_dstId = order by fsl_masterLinkYN desc /* and cdr.crmActive = 'Y' */ select ter.ownerId, ter.fsl_tablecode, ter.name, ter.internalSalesId, bter.ownerId, bter.fsl_tablecode, bter.name b_name, bter.internalSalesId from tbl_TER_TErritories ter inner join tbl_SMA_BrokerOfficeLink bol with (nolock) on bol.mfr_id = ter.ownerId and bol.territoryId = ter.territoryId and bol.primaryOffice = 'Y' inner join tblBrokerOffices bo with (nolock) on bo.broker_office_id = bol.brokerOfficeId inner join tbl_BRO_Principals p on p.ownerId = bo.broker_id and p.mfrId = ter.ownerId and p.ownerType = 'BRO' inner join tbl_BRO_PrincipalTerritories pt with (nolock) on pt.ownerId = p.ownerId and pt.ownerType = p.ownerType and pt.principalId = p.principalId and pt.mfrTerritoryNbr = ter.internalSalesId inner join tbl_BRO_PrincipalTerritoryResources ptr with (nolock) on ptr.ownerId = pt.ownerId and ptr.ownerType =pt.ownerType and ptr.principalTerritoryId =pt.principalTerritoryId and ptr.resourceType = 'TER' inner join tbl_TER_Territories bter with (nolock) on bter.ownerId = ptr.ownerId and bter.fsl_tablecode = ptr.ownerType and bter.territoryId = ptr.resourceId where ter.ownerId = and ter.fsl_tablecode= and ter.territoryId = and bo.broker_id = and bter.territoryId = and exists ( select cdr.cdr_recordId from tbl_CDR_Distributors cdr with (nolock) where cdr.fsl_TableCode = 'BRO' and cdr.ownerId = bo.broker_id and cdr.fsl_dstId = and cdr.cdr_territoryId = bter.territoryId) update tbl_CDR_Stocking set stockingStatus = , lastUpdateSource = , lastUpdated = , lastUpdatedBy = 0 where ownerType = and ownerId = and skuid = and cdr_recordId = insert into tbl_CDR_Stocking(ownerid, ownerType, cdr_recordId, skuid, stockingStatus, lastUpdated, lastUpdatedBy, createDate, lastUpdateSource) values( , , , , , , 0, , ) select * from _resultsQuery order by sku, m_territory, m_distributor, broker, b_territory, b_distributor select mfr_name from tblManufacturers where mfr_id = ^{* - inherited from primary distributor}