CREATE VIEW "IMCYC"."B1_WTaxSumsPerWhtTypeView" ( "SrcObjType", "SrcObjAbs", "SrcArrType", "SrcLineNum", "SrcGrpNum", "BaseObjTyp", "BaseAbs", "BaseArrTyp", "BaseLinNum", "BaseGrpNum", "WhtType", "WTaxSum", "WTaxSumSc", "WTaxSumFc" ) AS SELECT T0."SrcObjType", T0."SrcObjAbs", T1."SrcArrType", T1."SrcLineNum", T1."SrcGrpNum", T1."BaseObjTyp", T1."BaseAbs", T1."BaseArrTyp", T1."BaseLinNum", T1."BaseGrpNum", T1."WhtType", SUM(T1."WTaxSum") AS "WTaxSum", SUM(T1."WTaxSumSc") AS "WTaxSumSc", SUM(T1."WTaxSumFc") AS "WTaxSumFc" FROM  "IMCYC"."OWTX" T0  INNER  JOIN "IMCYC"."WTX1" T1  ON  T1."AbsEntry" = T0."AbsEntry"   WHERE T0."Cancelled" = ('N' )   GROUP BY T0."SrcObjType", T0."SrcObjAbs", T1."SrcArrType", T1."SrcLineNum", T1."SrcGrpNum", T1."BaseObjTyp", T1."BaseAbs", T1."BaseArrTyp", T1."BaseLinNum", T1."BaseGrpNum", T1."WhtType" WITH READ ONLY