SELECT * FROM CM_GOODS WHERE GD_CODE ='DG.I.N.OE.0003.2021'
SELECT * FROM PL_TRADEDETAIL WHERE GOODS_ID ='GOO000000251691' AND PLAN_ID 
IN (SELECT PLAN_ID FROM PL_MASTER WHERE DEPT_ID IN (SELECT DEP_ID  FROM CM_DEPARTMENT WHERE DEP_CODE ='8990000') AND YEAR =2021)