有没有大佬知道这个数据集获取上一年当前月份的日期要怎么修改呀，使用上面的公式会导致切换参数的时候时间参数传不过来

SELECT  

  F.MONTH_ID AS MONTH,

  SUM(F.STD_INV_AM)/10000 STD_INV_AM,

  CASE WHEN F.MATERIAL_CLASS_L1_NAME='1' THEN SUM(F.CVT_INV_NM)/1000 ELSE SUM(F.CVT_INV_NM)/10000 END AS CVT_INV_NM

FROM ADS_EBS_INV_HQTY_DETAIL F

WHERE 1=1

    AND F.INV_CLASS_01_NAME ='成品库' 

    AND F.MATERIAL_CLASS_L1_NAME='${ty}'

    AND F.YM_ID = TO_CHAR(TO_NUMBER(SUBSTR('${P_S_DATE}',1,4))-1)||'-'||SUBSTR('${P_S_DATE}',6,7)

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

GROUP BY F.MONTH_ID ,F.MATERIAL_CLASS_L1_NAME

ORDER BY F.MONTH_ID