Index: grails-app/services/com/lemans/ds/vendor/VendorService.groovy
===================================================================
diff -u -r57abd1bb09550de47bebf4c2513688dac4bb59df -r9a32c941ed22f32f8b1200b928339099c5f09f03
--- grails-app/services/com/lemans/ds/vendor/VendorService.groovy	(.../VendorService.groovy)	(revision 57abd1bb09550de47bebf4c2513688dac4bb59df)
+++ grails-app/services/com/lemans/ds/vendor/VendorService.groovy	(.../VendorService.groovy)	(revision 9a32c941ed22f32f8b1200b928339099c5f09f03)
@@ -8,8 +8,7 @@
 
     Map findVendors(Map criteria) {
         List results = sql().rows("""SELECT vendorId AS id, vendorName AS name
-                          FROM vendor WHERE dateDeleted IS null 
-                          AND inactiveDate is null 
+                          FROM vwVendor 
                           ORDER BY vendorId ASC 
                           OFFSET ${criteria.offset ?: 0} ROWS FETCH NEXT ${criteria.pageSize ?: 3} ROWS ONLY""")
         results.each { Map  data ->