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

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
;