Not support for this MFR

 select r.ownerId, c.ownerType, c.reconciledDate, c.claimId, c.claimStatus, c.partnerId claimantPartnerId, cc.claimContractId, c.claimPeriodStart, c.claimPeriodEnd, c.partnerType claimantPartnerType, rt.requestModel, r.requestId, r.payableTO, r.assignedContractNbr, ct.partnerId beneficiaryPartnerId, ct.partnerType beneficiaryPartnerType, r.termStart, r.termEnd, ct.contractId from tbl_TPM_Claims c with (nolock) inner join tbl_TPM_ClaimContracts cc with (nolock) on cc.claimId = c.claimId and cc.ownerId = c.ownerId and cc.ownerType = cc.ownerType inner join tbL_TPM_Requests r with (nolock) on r.requestId =cc.requestId and r.ownerType = cc.ownerType and r.ownerId = cc.ownerId inner join tbl_TPM_Contracts ct with (nolock) on ct.ownerId = r.ownerId and ct.ownerType = r.ownerType and ct.contractId = r.contractId inner join tbl_TPM_RequestTypes rt with (nolock) on rt.requestTypeId = r.requestTypeId and rt.ownerId = r.ownerId and rt.ownerType = r.ownerType and rt.requestModel != 'SPENDING' where r.payableTo != c.partnerType and c.ownerId = and c.ownerType = 'MFR' and c.readyToAudit = 'Y' -- and c.claimId = 174950 order by c.claimId select distinct ownerId, ownerType, claimId, claimStatus from qmd_wrongAgreementByPayableTo update tbl_TPM_Claims set reconciledAmount = null, reconciledDate = null, readyToClear = 'N', readyToClearMessage = null ,claimStatus = 'OPEN', readyToAudit = 'N' where ownerId = and ownerType = and claimId = update tbl_TPM_ClaimContracts set reconciled = 'N', reconciledByUserId = null, reconciledDate = null where ownerId = and ownerType = and claimId = delete tbl_TPM_ReconciliationHistory where ownerId = and ownerType = and claimId = update tbl_TPM_ClaimContracts set status = 'OPEN' where ownerId = and ownerType = and claimId = and claimContractId = select readyToClear, readyToClearMessage from tbl_TPM_Claims where ownerId = and ownerType = and claimId = and readyToClear = 'N' select distinct ownerId, ownerType, contractId from qmd_wrongAgreementByPayableTo update tbl_TPM_Contracts set flaggedForRecalc = 'Y', flaggedForRecalcTime = getDate() where ownerId = and ownerType = and contractId = and r.payableTo = and ct.partnerType = and ct.partnerId = select r.requestId, rt.requestModel, r.startDate, r.endDate from tbl_TPM_Contracts ct with (nolock) inner join tbl_TPM_Requests r with (nolock) on r.contractId = ct.contractId and r.ownerId = ct.ownerId and r.ownerType = ct.ownerType inner join tbl_TPM_RequestTypes rt with (nolock) on rt.requestTypeId = r.requestTypeId and rt.ownerId = r.ownerId and rt.ownerType = r.ownerType where ct.ownerId = and ct.ownerType = and r.payableTo = and ct.partnerType = and ct.partnerId = and not ( < r.startDate or > r.endDate ) order by r.requestId desc --->