select requestId from qmd_requests where endDate < and startDate <= and endDate >= and status = 'APPROVED' select requestId from qmd_requests where status = 'DRAFT' select claimId from qmd_claims where claimStatus = 'OPEN' and claimType = 'D' select claimId from qmd_claims where claimStatus = 'OPEN' and claimType in ( 'B', 'R' )

Open Deductions:	#lsnumberformat( qmd_openDeductions.recordCount )#
Open Claims:	#lsnumberformat( qmd_openClaims.recordCount )#
Contract Approvals:	#lsnumberformat( qmd_drafts.recordCount )#
Expiring < #_days# Days:	#lsnumberformat( qmd_expiringDeals.recordCount )#

Trade Promotion Management Requests

--->