为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:
【操作系统】：
【CPU】:
【问题描述】*：

CREATE VIEW "EKP_SQLSERVER"."V_EKP_AGREEMENT_FORM_HZL_COPY1" AS 
  SELECT t1.fd_parent_id,
         t1."乙方",
         t1."信用代码",
         t1."法人",
         t1."角色",
         SUM ( CASE WHEN t1."收付款状态" = '00' THEN ( t1.收款金额 ) WHEN t1."收付款状态" = '01' THEN ( t1."经开支付" + t1."费用支付" + t1."项目支付" + t1."运营支付" + t1."资源支付" ) END ) AS 收付款金额,
         SUM ( t1."经开支付" + t1."费用支付" + t1."项目支付" + t1."运营支付" + t1."资源支付" ) AS 支付金额,
         SUM ( t1.收款金额 ) AS 收款登记金额
    FROM ( SELECT a.fd_parent_id,
                    T1.fd_settype AS 收付款状态, ( SELECT SUM ( T0.fd_amount ) 
                       FROM "EKP_SQLSERVER"."KM_SETTLEMENT_COLLECTION" T0 
                      WHERE T0."FD_CONTRACT_ID" = a.fd_parent_id ) AS "收款金额", ( SELECT SUM ( T1069."FD_MONEYX" ) 
                       FROM "EKP_SQLSERVER"."KM_JYKFPAY_MAIN" T1069 
                      WHERE T1069."FD_AGREEMENT_ID" = a.fd_parent_id ) AS 经开支付, ( SELECT SUM ( T1060.fd_moneyx ) 
                       FROM "EKP_SQLSERVER"."KM_CORPAY_MAIN" T1060 
                      WHERE T1060."FD_AGREEMENT_ID" = a.fd_parent_id ) AS 费用支付, ( SELECT SUM ( T1068."FD_SJ_MONEY" ) 
                       FROM "EKP_SQLSERVER"."KM_XMPAY_MAIN" T1068 
                      WHERE T1068."FD_AGREEMENT_ID" = a.fd_parent_id ) AS 项目支付, ( SELECT SUM ( T1052."FD_MONEYX" ) 
                       FROM "EKP_SQLSERVER"."KM_YYSYPAY_MAIN" T1052 
                      WHERE T1052."FD_AGREEMENT_ID" = a.fd_parent_id ) AS 运营支付, ( SELECT SUM ( T49152."FD_MONEYX" ) 
                       FROM "EKP_SQLSERVER"."KM_ZYGSPAY_MAIN" T49152 
                      WHERE T49152."FD_AGREEMENT_ID" = a.fd_parent_id ) AS 资源支付,
                    乙方 = ( stuff( ( SELECT ',' + CAST ( b.fd_relative_name_display AS VARCHAR )
                       FROM ekp_agreement_form_detail b
                      WHERE 1 = 1 AND a.fd_parent_id= b.fd_parent_id FOR xml path ( '' ) ), 1, 1, '' ) ),
                    法人 = ( stuff( ( SELECT ',' + CAST ( b.fd_legal_representative AS VARCHAR )
                       FROM ekp_agreement_form_detail b
                      WHERE 1 = 1 AND a.fd_parent_id= b.fd_parent_id FOR xml path ( '' ) ), 1, 1, '' ) ),
                    信用代码 = ( stuff( ( SELECT ',' + CAST ( b.fd_credit_code AS VARCHAR )
                       FROM ekp_agreement_form_detail b
                      WHERE 1 = 1 AND a.fd_parent_id= b.fd_parent_id FOR xml path ( '' ) ), 1, 1, '' ) ),
                    角色 = ( stuff( ( SELECT ',' + CAST ( b.fd_dominant_role AS VARCHAR )
                       FROM ekp_agreement_form_detail b
                      WHERE 1 = 1 AND a.fd_parent_id= b.fd_parent_id FOR xml path ( '' ) ), 1, 1, '' ) )
               FROM ekp_agreement_form_detail a
         INNER JOIN km_agreement_apply T1 
                 ON T1.fd_id = a.fd_parent_id
              WHERE 1 = 1
           GROUP BY a.fd_parent_id,
                    T1.fd_settype ) t1
GROUP BY t1.fd_parent_id,
         t1."乙方",
         t1."信用代码",
         t1."法人",
         t1."角色",
         t1."收付款状态"

这块改怎么改呢？