Contracts by Fund Type report in CAMM DB. Modified to get Measure M only, and without CO-OPs.
--Contracts by Fund Type using CAMM database. For Meena who wants non-coops only.
SELECT DISTINCT(c.CONTRACTNUM), c.CONTRACTCOMMENT, v.vendorname, c.CONTRACTAMT, c.EFFDATE, C.EXPDATE, pauser.paname, c.FUNDTYPEDESC, c.FUNDINGSOURCE1, c.FUNDINGSOURCE2
FROM CONTRACT c, VENDOR v, PAUSER
WHERE c.vendornum = v.vendornum and
c.panum = pauser.panum AND
(c.FUNDINGSOURCE1 = 'MEASURE M-0010' OR c.FUNDINGSOURCE2 = 'MEASURE M-0010' OR c.fundtypedesc = 'MEASURE M(0010)') AND
UPPER(c.CONTRACTCOMMENT) NOT LIKE '%COOP%' AND
UPPER(c.CONTRACTCOMMENT) NOT LIKE '%CO-OP%' AND
UPPER(v.VENDORNAME) NOT LIKE '%CITY OF%' AND
UPPER(v.VENDORNAME) NOT LIKE '%COUNTY OF%'
ORDER BY c.contractnum;