fix: Patch to set status in old serial no data (#21720)

* fix: Patch to set status in old serial no data

* fix: Avoid get_doc in patch

* fix: fetch all values and check status in one query
diff --git a/erpnext/patches.txt b/erpnext/patches.txt
index ebbcccc..4ae591b 100644
--- a/erpnext/patches.txt
+++ b/erpnext/patches.txt
@@ -684,3 +684,4 @@
 execute:frappe.rename_doc("Desk Page", "Getting Started", "Home", force=True)
 erpnext.patches.v12_0.unset_customer_supplier_based_on_type_of_item_price
 erpnext.patches.v12_0.set_valid_till_date_in_supplier_quotation
+erpnext.patches.v12_0.set_serial_no_status