想要做成的效果是搜索C_TYPE出第一个图，搜索EQPID出第二个图表

目前第一个图已经做出来了，如图

别人发给我的SQL让我做图，我放到帆软里改成这样了，但是报错，不知道怎么改

select to_char(to_date(A.DAY,'yyyymmdd'),'yy-mm-dd') day,
                           nvl(oee,0) OEE,
                           least(round(actual_wph/peak_wph,3),2.0 + round(actual_wph/peak_wph,1)/100) wph_ratio,
                           (select to_number(b.oee) from pc.RPT_EQP_TYPE b ) oee_target,
                           (select to_number(b.WPH_ratio) from pc.RPT_EQP_TYPE b ) WPH_Ratio_target
                      from pc.rpt_tool_perf_sx a
                     where 1=1
                       and a.day > to_char(sysdate-32,'yyyymmdd')
                   ${if(len(eqpid) == 0,"","and a.eqpid = '" +eqpid+ "' ")}   
                  order by a.day

原始别人给我的sql

select to_char(to_date(A.DAY,'yyyymmdd'),'yy-mm-dd') day,

                           nvl(oee,0) OEE,

                           least(round(actual_wph/peak_wph,3),2.0 + round(actual_wph/peak_wph,1)/100) wph_ratio,

                           (select to_number(b.oee) from RPT_EQP_TYPE b where b.eqpid = :p42_eqpid) oee_target,

                           (select to_number(b.WPH_ratio) from RPT_EQP_TYPE b where b.eqpid = :p42_eqpid) WPH_Ratio_target

                      from rpt_tool_perf_sx a

                     where A.EQPid = :p42_eqpid

                       and a.day > to_char(sysdate-32,'yyyymmdd')

                  order by a.day