I just tried your select statement and it didn't give me anything (no rows selected).
But then I tried another one thing what I just wanted to try:
Like I don't have any needs to save that user I tried to drop all objects one by one using this statement:
"select 'drop '||object_type||' '|| object_name|| DECODE(OBJECT_TYPE,'TABLE',' CASCADE CONSTRAINTS;',';')
And then accidently I found out that one of the errors showed me that I have to drop table using this procedure DBMS_AQADM.DROP_QUEUE_TABLE(queue_table => 'QTABWSEORIREQUEST' , force => TRUE);
Then I found out the similarities and it was this QT, and then I used this select "select object_name from user_objects where object_name like '%QT%'; " to obtain list of thease **** tables. After that droped all thease tables using:
DBMS_AQADM.DROP_QUEUE_TABLE(queue_table => 'QTABWSEORIREQUEST' , force => TRUE);