select oo.obj_num,oo.schema_obj.owner_name,oo.schema_obj.name,
oo.impc_flags, oo.tag
from ku$_option_objnum_view oo
where oo.tgt_type=4 /* type is 'view' */
View Text - HTML Formatted
SELECT OO.OBJ_NUM , OO.SCHEMA_OBJ.OWNER_NAME , OO.SCHEMA_OBJ.NAME ,
OO.IMPC_FLAGS , OO.TAG
FROM KU$_OPTION_OBJNUM_VIEW OO
WHERE OO.TGT_TYPE=4 /* TYPE IS 'VIEW' */