From 30443483e37c7d323dca9c20d8407c3614acf542 Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周三, 25 12月 2024 11:53:26 +0800 Subject: [PATCH] 22 --- 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琛ㄧず 姝e父 +AND station.PlaceCode <> '040310' -- 040310 璁稿伐璇磋繖涓伐浣嶆満鍣ㄤ汉杈句笉鍒帮紝寮鸿閿佸畾 銆怑ditby shaocx,2024-12-23銆� AND svs.Id IS NULL GO -- Gitblit v1.9.3