请根据报错帮我修改下参数：WITH ACT_QTY AS(SELECT 'MMG' AS PRODUCT_TYPE, T.PRODUCT_ID, M.RECORD_COUNT_M,M.RATIO_M, SUM(CASE WHEN T.PERIOD_DATE = TO_DATE('${date}' || '${shift68}', 'YYYY-MM-DDHH24MISS') THEN T.NRE_OUTPUT_PNL_QTY ELSE 0 END)/M.RECORD_COUNT_M*M.RATIO_M AS OUTPUT_QTY_D, SUM(CASE WHEN T.PERIOD_DATE <= TO_DATE('${date}' || '${shift68}', 'YYYY-MM-DDHH24MISS') THEN T.NRE_OUTPUT_PNL_QTY ELSE 0 END)/M.RECORD_COUNT_M*M.RATIO_M AS OUTPUT_QTY_CUM, SUM(CASE WHEN T.PERIOD_DATE <= TO_DATE('${date}' || '${shift68}', 'YYYY-MM-DDHH24MISS') THEN T.NRE_OUTPUT_PNL_QTY ELSE 0 END)/M.RECORD_COUNT_M*M.RATIO_M AS OUTPUT_QTY_M FROM DWS_OUTPUT_SLOC T, DWD_PRODUCT_M M WHERE (M.FACTORY(+) = T.FACTORY AND M.PRODUCT_ID(+) = T.PRODUCT_ID) AND (T.PERIOD_DATE >= TO_DATE(TO_CHAR(TO_DATE('${date}', 'YYYY-MM-DD'), 'YYYYMM') || '01'||'${shift68}', 'YYYYMMDDHH24MISS') AND T.PERIOD_DATE < ADD_MONTHS(TO_DATE(TO_CHAR(TO_DATE('${date}', 'YYYY-MM-DD'), 'YYYYMM') || '01'||'${shift68}', 'YYYYMMDDHH24MISS'), 1) --全月 AND T.PERIOD = 'D' AND T.STEP_ID IN ('51000') AND T.UNIT_TYPE IN ('MP', 'ZP10', 'RM', 'ZP13') AND T.PRODUCT_ID IN ('D21A', 'D22A', 'D24A', 'D22F', 'D43A', 'D45A', 'D48A', 'D48C', 'D48F', 'D61A', 'D61C', 'D61D', 'D49A', 'D23A', 'D49B', 'D31A', 'D62B', 'D4DA', 'D2AA', 'D48B', 'D32A', 'D4BA', 'D2BA', 'D4EA', 'D2EA', 'D4EA','D31C','D4BA','D2DA','D2DE','D2DF','D2CA','D4BC','D2CG','D2CB','D2CF','D2DH','D2DC','D31J','D2CD','D31L','D2AA','D2LA','D13M','D2KE','D31M','D2KE','D2KF','D2MC','D31P','D33A','D31N')) GROUP BY T.PRODUCT_ID,M.RECORD_COUNT_M,M.RATIO_M), PLAN_QTY AS( SELECT 'MMG' AS PRODUCT_TYPE,T.PRODUCT_ID,M.RECORD_COUNT_M,M.RATIO_M, SUM(CASE WHEN T.DAILY_KEY = TO_CHAR(TO_DATE('${date}', 'YYYY-MM-DD'), 'YYYYMMDD') THEN T.TARGET_OUTPUT_PANEL_QTY ELSE 0 END)/M.RECORD_COUNT_M*M.RATIO_M AS OUTPUT_PLAN_D, SUM(CASE WHEN T.DAILY_KEY <= TO_CHAR(TO_DATE('${date}', 'YYYY-MM-DD'), 'YYYYMMDD') THEN T.TARGET_OUTPUT_PANEL_QTY ELSE 0 END)/M.RECORD_COUNT_M*M.RATIO_M AS OUTPUT_PLAN_CUM, SUM(T.TARGET_OUTPUT_PANEL_QTY)/M.RECORD_COUNT_M*M.RATIO_M AS OUTPUT_PLAN_M FROM DWR_TARGET_OUTPUT T, DWD_PRODUCT_M M WHERE (M.FACTORY(+) = T.SHOP AND M.PRODUCT_ID(+) = T.PRODUCT_ID) AND (T.SHOP = 'SL' AND T.DAILY_KEY >= TO_CHAR(TO_DATE('${date}', 'YYYY-MM-DD'), 'YYYYMM') || '01' AND T.DAILY_KEY < TO_CHAR(ADD_MONTHS(TO_DATE('${date}', 'YYYY-MM-DD'), 1), 'YYYYMM') || '01' AND T.PRODUCT_TYPE IN ('MP', 'ZP10', 'RM', 'ZP13') AND T.PRODUCT_ID IN ('D21A', 'D22A', 'D24A', 'D22F', 'D43A', 'D45A', 'D48A', 'D48C', 'D48F', 'D61A', 'D61C', 'D61D', 'D49A', 'D23A', 'D49B', 'D31A', 'D62B', 'D4DA', 'D2AA', 'D48B', 'D32A', 'D4BA', 'D2BA', 'D4EA', 'D2EA', 'D4EA','D31C','D4BA','D2DA','D2DE','D2DF','D2CA','D4BC','D2CG','D2CB','D2CF','D2DH','D2DC','D31J','D2CD','D31L','D2AA','D2LA','D13M','D2KE','D31M','D2KE','D2KF','D2MC','D31P','D33A','D31N')) GROUP BY T.PRODUCT_ID,M.RECORD_COUNT_M,M.RATIO_M ),TOTAL_ACT AS(SELECT 'MMG' AS PRODUCT_TYPE,SUM(OUTPUT_QTY_D) AS OUTPUT_QTY_D,SUM(OUTPUT_QTY_CUM) AS OUTPUT_QTY_CUM,SUM(OUTPUT_QTY_M) AS OUTPUT_QTY_M FROM ACT_QTY),TOTAL_PLAN AS(SELECT 'MMG' AS PRODUCT_TYPE,SUM(OUTPUT_PLAN_D) AS OUTPUT_PLAN_D,SUM(OUTPUT_PLAN_CUM) AS OUTPUT_PLAN_CUM,SUM(OUTPUT_PLAN_M) AS OUTPUT_PLAN_M FROM PLAN_QTY)SELECT TOTAL_ACT.OUTPUT_QTY_D, TOTAL_ACT.OUTPUT_QTY_CUM, TOTAL_ACT.OUTPUT_QTY_M, TOTAL_PLAN.OUTPUT_PLAN_D, TOTAL_PLAN.OUTPUT_PLAN_CUM, TOTAL_PLAN.OUTPUT_PLAN_M FROM TOTAL_ACT FULL JOIN TOTAL_PLAN ON TOTAL_ACT.PRODUCT_TYPE = TOTAL_PLAN.PRODUCT_TYPE
