未明确定义列

SELECT *
  FROM (SELECT p.amount totalamount, ca.code cacode, p.invoiceTitle, p.amount, 0.00,
                to_char(oi.duedateofbefore, 'yyyyMMdd') || '至' ||
                 to_char(oi.duedateofafter, 'yyyyMMdd'), p.externalTradeSn,
                c.code ccode, p.Actualhappendate
           FROM payments p, customeraccounts ca, customers c,
                customerorders co, customerorderitems oi
          WHERE p.customeraccountid = ca.id
            AND p.customerorderid = co.id
            AND co.id = oi.customerorderid
            AND p.classtype = 'BankPayment'
            AND p.paymentbankid =
                (SELECT ID FROM paymentbanks WHERE code = '608')
            AND p.actualhappendate >= to_date('20100110', 'yyyyMMdd')
            AND p.actualhappendate <=
                ADD_MONTHS(to_date('20100110', 'yyyyMMdd'), 1))
WHERE rownum <= 200;



没有取别名,外层select去掉前缀后无法识别