黑魂3不死人遗骨换了鸟:急急急！！！救命！

select VTEXT,SDFMC,MAKTX,sum(FPL),sum(KBETR),decode(sum(FPL),0,0,(sum(JE)-sum(KZWI4))/FPL) htj
from
(select X.vtext,A.SDFMC,A.MAKTX,0 FPL,0 KBETR,A.JE,0 KZWI4
FROM
T_SAP_SD_XSPJ A,TSPAT X
WHERE
A.jhrq BETWEEN TO_CHAR(TO_DATE('@qsrq@','YYYY-MM-DD'),'YYYYMMDD') AND TO_CHAR(TO_DATE('@jsrq@','YYYY-MM-DD'),'YYYYMMDD')
AND A.SPART=X.SPART
UNION ALL
select X.vtext,A.SDFMC,A.MAKTX,A.FPL,0 KBETR,0 JE,0 KZWI4
FROM
T_SAP_SD_XSPJ A,TSPAT X
WHERE
A.jhrq BETWEEN TO_CHAR(TO_DATE('@qsrq@','YYYY-MM-DD'),'YYYYMMDD') AND TO_CHAR(TO_DATE('@jsrq@','YYYY-MM-DD'),'YYYYMMDD')
AND A.SPART=X.SPART
UNION ALL
select X.vtext,A.SDFMC,A.MAKTX,0 FPL,C.KBETR,0 JE,0 KZWI4
FROM
T_SAP_SD_XSPJ A,A304 B,KONP C,TSPAT X
WHERE A.MATNR=B.MATNR
AND B.KNUMH=C.KNUMH
AND B.DATBI >= to_char(TO_DATE('@jsrq@', 'YYYY-MM-DD'), 'YYYYMMDD')
AND B.DATAB <= to_char(TO_DATE('@jsrq@', 'YYYY-MM-DD'), 'YYYYMMDD')
AND A.SPART=X.SPART
UNION ALL
select X.vtext,A.SDFMC,A.MAKTX,0 FPL,0 KBETR,0 JE,A.KZWI4
FROM
T_SAP_SD_XSPJ A,TSPAT X
WHERE
A.jhrq BETWEEN TO_CHAR(TO_DATE('@qsrq@','YYYY-MM-DD'),'YYYYMMDD') AND TO_CHAR(TO_DATE('@jsrq@','YYYY-MM-DD'),'YYYYMMDD')
AND A.SPART=X.SPART)
group by MAKTX,SDFMC,VTEXT
order by MAKTX

如何让这个成功？各位大虾救命！