From 8706d6948d9a922d8e5adce27f49790ad4ac1d71 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周一, 10 3月 2025 16:38:59 +0800
Subject: [PATCH] 【缓存岛齐包管理】的缺包列表中明细，没有显示出 缺包的数据

---
 DBScript/01_DDL/03_DDL_VIEW.sql |    1 +
 1 files changed, 1 insertions(+), 0 deletions(-)

diff --git a/DBScript/01_DDL/03_DDL_VIEW.sql b/DBScript/01_DDL/03_DDL_VIEW.sql
index 629ae81..b646689 100644
--- a/DBScript/01_DDL/03_DDL_VIEW.sql
+++ b/DBScript/01_DDL/03_DDL_VIEW.sql
@@ -22,6 +22,7 @@
 LEFT JOIN dbo.wms_stock_quan as svs ON station.placeCode=svs.placeCode
 WHERE  station.IsDisabled=0  AND station.IsDelete=0
 AND station.PlaceStatus=1  -- 1琛ㄧず 姝ｅ父
+AND station.PlaceCode <> '040310'  -- 040310 璁稿伐璇磋繖涓伐浣嶆満鍣ㄤ汉杈句笉鍒帮紝寮鸿閿佸畾 銆怑ditby shaocx,2024-12-23銆�
 AND svs.Id IS NULL 
 
 GO

--
Gitblit v1.9.3