fixed bug with retrieved division name by restoring subquery
spelling
used 'is not true' rather than 'is false'
fixed bug that excluded new orders by converting an implicit inner join to a left join
Merge branch 'master' into calcdue

Conflicts:
	legacy/cv.valmont_open_orders_report.pgsql