oracle报错标识符无效，红色地方报错

[qq_40351312]

create or replace view nowquery as
select decode(oosn1.all_short_nmae,null,oosn1.short_name,
oosn1.all_short_nmae

) short_name,

tx11.accountcode,
tx11.creditamount,
tx11.creditquantity,
tx11.debitamount,
tx11.debitquantity,
tx11.globalcreditamount,
tx11.globaldebitamount,
tx11.groupcreditamount,
tx11.groupdebitamount,
tx11.localcreditamount,
tx11.localdebitamount
from
(select oosn.short_name,t6.accountcode,
t6.creditamount,
t6.creditquantity,
t6.debitamount,
t6.debitquantity,
t6.globalcreditamount,
t6.globaldebitamount,
t6.groupcreditamount,
t6.groupdebitamount,
t6.localcreditamount,
t6.localdebitamount

from
( select
t5.name,
t5.accountcode,
sum(creditamount) creditamount,
sum(creditquantity) creditquantity,
sum(debitamount) debitamount,
sum(debitquantity) debitquantity,
sum(globalcreditamount) globalcreditamount,
sum(globaldebitamount) globaldebitamount,
sum(groupcreditamount) groupcreditamount,
sum(groupdebitamount) groupdebitamount,
sum(localcreditamount) localcreditamount,
sum(localdebitamount) localdebitamount from
(select t4.* from (
select t3.name,gd.* from (select t2.*,t1.*
from
( select t.pk_relorg,t.pk_accountingbook from org_accountingbook t )t2 left join
org_orgs t1 on t2.pk_relorg =t1.pk_org) t3 ,gl_detail gd
where t3.pk_accountingbook=gd.pk_accountingbook

and name <> '测试单位') t4
where
to_date(t4.prepareddatev, 'yyyy-mm-dd hh24:mi:ss') >=
to_date(to_char(sysdate, 'yyyy') ||
'-01-01 00:00:00',
'yyyy-mm-dd hh24:mi:ss') ) t5
group by t5.name,
t5.accountcode
) t6,org_orgs_short_name oosn
where t6.name=oosn.name) tx11,
org_orgs_short_name oosn1
where tx11.short_name = oosn1.short_name
;

[qq_40351312]

最后一行
where tx11.short_name = oosn1.short_name
中的 tx11.short_name报的错

[qiankunbobo]

那就是tx11这个对象中没有short_name这个字段

[jdsnhan]

检查tx11中short_name是在哪定义的。