select mfr_id, mfr_name from tblManufacturers where mfr_id in ( select ownerId from tbl_TPM_Settings where dataharvesting = 'Y' and ownerType = 'MFR' ) and mfr_id =

#htmleditformat( mfr_name )#

select operatorId from tbl_OPR_ClientOperators where fsltablecode ='MFR' and fsl_choId = 251 and ownerId = select claimId from tbl_TPM_Claims where partnerId = and partnerType = 'OPR' and ownerId = select pod.operatorName, pod.operatorAffiliateNbr, max( c.claimPeriodEnd ) activityDate from tbl_TPM_ProofOFdelivery pod inner join tbl_TPM_Claims c on c.claimId= pod.claimId and c.ownerId = pod.ownerId and c.ownerType = pod.ownerType where pod.claimId in ( ) and pod.ownerId = and pod.ownerType ='MFR' and pod.operatorId is null and pod.operatorName is not null and nullif( pod.operatorAffiliateNbr, '' ) is not null and exists ( select * from tbl_OPR_CLientOperators m where m.ownerId = 251 and m.fsltablecode ='CHO' and m.mfrCustNum = pod.operatorAffiliateNbr and ( nullif( m.address, '' ) is not null or m.fsl_choId > 0 )) group by pod.operatorName, pod.operatorAffiliateNbr order by pod.operatorName, pod.operatorAffiliateNbr, activityDate update tbl_TPM_ProofOfDelivery set operatorId = where ownerId = and ownerType = 'MFR' and operatorName = and operatorAffiliateNbr = and operatorId is null and claimId in ( ) update tbl_TPM_ProofOfDelivery set flagged = 'N', flagComment = null where ownerId = and ownerType = 'MFR' and operatorId = and flagged = 'Y' and flagComment = 'Insufficient Operator Data' and claimId in ( )

Updated #_podRecordsUpdated# POD records

 update tbl_TPM_Contracts set flaggedForRecalc = 'Y', flaggedForRecalcTime = getDate() where ownerId = and partnerType = 'OPR' and partnerId =

Flagged #_r.recordCount# Agreements for recalc