marcus-e
1/26/2018 - 6:00 PM
Commodity Codes for Bid List
This is one query which will be utilized in a Bid List generation report. Needed while bug persists with sometimes generating them automatically off of Solicitation Manager.
SELECT distinct m.solicitnum, s.solicittitle, l.categorydesc, n.commoditydesc
FROM solicitation s, solicitcomm m, newcommcodelookup n, newcommcatlookup l
WHERE m.solicitnum = '72149' AND
m.commcode = n.commcode AND
n.categorycode = l.categorycode AND
s.solicitnum = m.solicitnum
ORDER BY l.categorydesc, n.commoditydesc;