From c397f976175a24957e7f4db4bd7e694c294ca532 Mon Sep 17 00:00:00 2001 From: luxiaotao1123 <t1341870251@63.com> Date: 星期二, 12 七月 2022 15:48:58 +0800 Subject: [PATCH] # --- src/main/resources/mapper/LocDetlMapper.xml | 2 ++ 1 files changed, 2 insertions(+), 0 deletions(-) diff --git a/src/main/resources/mapper/LocDetlMapper.xml b/src/main/resources/mapper/LocDetlMapper.xml index 78a0115..6c081b5 100644 --- a/src/main/resources/mapper/LocDetlMapper.xml +++ b/src/main/resources/mapper/LocDetlMapper.xml @@ -196,8 +196,10 @@ select a.* from asr_loc_detl a left join asr_loc_mast b on a.loc_no = b.loc_no + left join asr_bas_crnp c on b.crn_no = c.crn_no where 1=1 and b.loc_sts = 'F' + and c.out_enable = 'Y' and a.matnr = #{matnr} <!-- <choose>--> <!-- <when test="batch != null and batch != ''">--> -- Gitblit v1.9.1