SELECT F.MATERIAL_CLASS_L1_NAME,

       F.MATERIAL_CODE      PRODUCT_DETAIL_CODE,

       F.MATERIAL_NAME      PRODUCT_DETAIL_NAME,

       --F.ATTRUBITE07            SUBINVENTORY_NAME,

       F.OM_CLASS_L3_NAME   PRODUCT_CLASS_NAME,

       SUM(F.STD_INV_NM)    AS STD_INV_NM,

       SUM(F.CVT_INV_NM)    AS CVT_INV_NM,

       F.PRODUCE_AGING_DESC INV_AGE,

       F.PRODUCE_AGING_NUM  INV_AGE_ORD

FROM ADS_EBS_INV_HQTY_DETAIL F

WHERE 1 = 1

      --AND F.MATERIAL_CLASS_L1_NAME = '${PRODUCT_CLASS_NAME}'

      AND F.YM_ID = '${P_S_DATE}'

      AND (F.OU_ID = 102 OR F.OU_ID = 127)

      AND F.INV_CLASS_01_NAME = '成品库'

      ${if(len(PRODUCT_CLASS_NAME)==0,"","and F.MATERIAL_CLASS_L1_NAME in(  '"+PRODUCT_CLASS_NAME+"'  )")}

GROUP BY F.MATERIAL_CLASS_L1_NAME,

         F.MATERIAL_CODE,

         F.MATERIAL_NAME,

-- F.ATTRUBITE07,

         F.OM_CLASS_L3_NAME,

         F.PRODUCE_AGING_DESC,

         F.PRODUCE_AGING_NUM

ORDER BY INV_AGE_ORD

复选框选两个的时候为什么会出现SQL未结束呀