The create or replace the view nowquery as
Select the 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
The from
(the 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

The from
(select
T5. The name,
T5 accountcode,
The sum (creditamount) creditamount,
The sum (creditquantity) creditquantity,
The sum (debitamount) debitamount,
The sum (debitquantity) debitquantity,
The sum (globalcreditamount) globalcreditamount,
The sum (globaldebitamount) globaldebitamount,
The sum (groupcreditamount) groupcreditamount,
The sum (groupdebitamount) groupdebitamount,
The sum (localcreditamount) localcreditamount,
The sum (localdebitamount) localdebitamount from
(select t4. * from (
The select t3. The name, gd. * from (select t2. *, t1. *
The from
K_relorg (select t.p, t.p k_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 the name & lt;> 'test unit) t4
Where
To_date (t4) prepareddatev, 'yyyy - mm - dd hh24: mi: ss') & gt;=
To_date (to_char (sysdate, 'yyyy) | |
'- 01-01 00:00:00,
'- dd yyyy - mm hh24: mi: ss')) t5
Group by t5. The 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
;

CodePudding user response:

The last line
Where tx11. Short_name=oosn1. Short_name
The tx11. Short_name quote wrong

CodePudding user response:

That is tx11 no short_name the fields in the object

CodePudding user response:

Check where tx11 short_name is defined,