diff --git a/erpnext/controllers/queries.py b/erpnext/controllers/queries.py
index a71a08e..dd95026 100644
--- a/erpnext/controllers/queries.py
+++ b/erpnext/controllers/queries.py
@@ -418,6 +418,6 @@
 			'where (`tabBatch`.expiry_date >= CURDATE() or `tabBatch`.expiry_date IS NULL)'
 
 	if filters and filters.get('item_code'):
-		query += 'where item = %(item_code)s' % filters
+		query += 'and item = %(item_code)s'
 
-	return frappe.db.sql(query)
+	return frappe.db.sql(query, filters)
diff --git a/erpnext/public/js/utils/serial_no_batch_selector.js b/erpnext/public/js/utils/serial_no_batch_selector.js
index e21caad..a974b99 100644
--- a/erpnext/public/js/utils/serial_no_batch_selector.js
+++ b/erpnext/public/js/utils/serial_no_batch_selector.js
@@ -215,7 +215,7 @@
 						in_list_view:1,
 						get_query: function() {
 							return {
-							    filters: {item: me.item_code },
+							    filters: {item_code: me.item_code },
 							    query: 'erpnext.controllers.queries.get_batch_numbers'
 					        };
 						},
@@ -357,4 +357,4 @@
 			}
 		];
 	}
-});
\ No newline at end of file
+});