select cc.requestId from tbl_TPM_ClaimContracts cc with (nolock) inner join tbl_TPM_Claims c with (nolock) on c.claimId = cc.claimId and c.ownerId = cc.ownerId and c.ownerType = cc.ownerType where c.partnerId = and c.partnerType = and c.ownerId = and c.ownerType = union select cc.requestId from tbl_TPM_ClaimContracts cc with (nolock) inner join tbl_TPM_Claims c with (nolock) on c.claimId = cc.claimId and c.ownerId = cc.ownerId and c.ownerType = cc.ownerType inner join tbl_TPM_ProofOfDelivery pod with (nolock) on pod.claimId = cc.claimId and pod.contractNbr = cc.contractNbr and pod.ownerId = cc.ownerId and pod.ownerType = cc.ownerType where c.ownerId = and c.ownerType = and pod.cdrRecordId = and pod.operatorId = select * from qmd_approvedContracts where requestId in ( ) select * from qmd_approvedContracts where currencyCode = select *, upper( assignedContractNbr ) searchContractNbr from qmd_approvedContracts where 1 = 1 and startDate <= and endDate >= and ( 1 = 2 or upper( primaryPartnerName ) like ) and upper( assignedContractNbr ) like and claimStatus = and upper( description ) like select distinct requestId from tbl_TPM_RequestProducts r where 1 = 1 and ( 1 = 2 or allowanceAmt = or fixedAmt = or incentivepct = ) and exists ( select * from tbl_PRD_Skus s where s.skuId = r.catalogId and s.sku = ) and catalogType = 'SKU' and r.ownerId = and r.ownerType = select 0 as x, qmd_approvedContracts.#_c# from qmd_approvedContracts, qmd_requests where qmd_approvedContracts.requestId = qmd_requests.requestId select *, upper( primaryPartnerName ) primaryPartnerNameSort from qmd_approvedContracts order by primaryPartnerNameSort

#htmleditformat( assignedContractNbr )# (#rereplace( promoNbr, _rx, "" )#) #htmleditformat( assignedContractNbr )# TBD

#htmleditformat( primaryPartnerName )# #htmleditformat( description )# view

#lsdateformat( startDate, "mm/dd/yy" )#

#lsdateformat( endDate, "mm/dd/yy" )#

#htmleditformat( claimStatus )#

#lsnumberformat( qmd_approvedContracts.recordCount )# matching contracts