If i ran the above query in all environment SQL Devlopers ,it showing the same error like below ORA-00942: table or view does not exist

I could see the below error in the log file The logical query block failed to hit or seed the cache in subrequest level due to [[ only one subrequest

Query has ran but the data is not displaying in the database. for more details ,below the query log session [2018-10-16T10:29:17.583+05:30] [OBIS] [TRACE:7] [] [] [ecid: c22acb8d-6565-400e-a38e-7f9b747e1b80-00045b4b,0:1:49:3] [sik: ssi] [tid: 6a] [messageid: USER-0] [requestid: 1116001d] [sessionid: 11160000] [username:…