ORA-00923: 未找到要求的 FROM 关键字

页面报500的错

下面是错误信息：

2015-9-23 22:07:47 org.apache.catalina.core.StandardWrapperValve invoke

严重: Servlet.service() for servlet app-website threw exception

java.sql.SQLSyntaxErrorException: ORA-00923: 未找到要求的 FROM 关键字

select fundTrace,balanceDate,pay,revenue,payerAccount,payeeAccount,payeeFee,payerFee,payNo,dealCode from (
SELECT ROWNUM rn,fundTrace,balanceDate,pay,revenue,payerAccount,payeeAccount,payeeFee,payerFee,payNo,dealCode FROM (
SELECT tbd.deal_type fundTrace,
tbd.create_date balanceDate,
decode(tbd.payer_full_mem_acctcode,#acctCode#,tbd.amount) pay,
decode(tbd.payee_full_mem_acctcode,#acctCode#,tbd.amount) revenue,
tbd.payer_full_mem_acctcode payerAccount,
tbd.payee_full_mem_acctcode payeeAccount,
tbd.payee_fee payeeFee,
tbd.payer_fee payerFee,
<!-- 交易流水号 -->
tbd.order_id payNo,
tbd.deal_code dealCode
FROM t_balance_deal tbd
WHERE
tbd.amount > 0
AND (tbd.payer_full_mem_acctcode = #acctCode# OR tbd.payee_full_mem_acctcode = #acctCode#)

错误点：红色已标注