select claimId, contractNbr from tbl_TPM_ClaimContracts with (nolock) where ownerId = and ownerType = and claimId = and contractNbr != '$MISCELLANEOUS'

Resetting Claim

update tbl_TPM_ClaimContracts set status = null, statusComment = null where ownerId = and ownerType = and contractNbr = and claimId = update tbl_TPM_ProofOfDelivery set qualifiedAmount = null, qualifiedRate = null, status = null, statusComment = null, modifyDate = , flagged = 'N', perContractVariance = null where ownerId = and ownerType = and contractNbr = and claimId =

Changes Rolled Back