TITLE: Microsoft Visual Studio
------------------------------

Item has already been added. Key in dictionary: 
'<View><dataSourceID>Wh</dataSourceID><schema>OE</schema><object>ACCOUNT_MANAGERS</object></View>'  
Key being added: '
<View><dataSourceID>Wh</dataSourceID><schema>OE</schema><object>ACCOUNT_MANAGERS</object></View>'

------------------------------
BUTTONS:

OK
------------------------------

SELECT
   * 
FROM
   (
      SELECT
         NULL TABLE_CATALOG,
         DECODE (OWNER, 'PUBLIC', NULL, OWNER) TABLE_SCHEMA,
         object_name TABLE_NAME,
         DECODE(OWNER, 'SYS', 
         DECODE(object_type, 'TABLE', 'SYSTEM TABLE', 'VIEW', 'SYSTEM VIEW', object_type), 'SYSTEM', 
         DECODE(object_type, 'TABLE', 'SYSTEM TABLE', 'VIEW', 'SYSTEM VIEW', object_type), 'DMSYS', 
         DECODE(object_type, 'TABLE', 'SYSTEM TABLE', 'VIEW', 'SYSTEM VIEW', object_type), 'ORDSYS', 
         DECODE(object_type, 'TABLE', 'SYSTEM TABLE', 'VIEW', 'SYSTEM VIEW', object_type), 'EXFSYS', 
         DECODE(object_type, 'TABLE', 'SYSTEM TABLE', 'VIEW', 'SYSTEM VIEW', object_type), 'WMSYS', 
         DECODE(object_type, 'TABLE', 'SYSTEM TABLE', 'VIEW', 'SYSTEM VIEW', object_type), 'MDSYS', 
         DECODE(object_type, 'TABLE', 'SYSTEM TABLE', 'VIEW', 'SYSTEM VIEW', object_type), 'CTXSYS', 
         DECODE(object_type, 'TABLE', 'SYSTEM TABLE', 'VIEW', 'SYSTEM VIEW', object_type), 'OLAPSYS', 
         DECODE(object_type, 'TABLE', 'SYSTEM TABLE', 'VIEW', 'SYSTEM VIEW', object_type), 'WKSYS', 
         DECODE(object_type, 'TABLE', 'SYSTEM TABLE', 'VIEW', 'SYSTEM VIEW', object_type), object_type)TABLE_TYPE,
         NULL TABLE_GUID,
         NULL DESCRIPTION,
         NULL TABLE_PROPID,
         created DATE_CREATED,
         last_ddl_time DATE_MODIFIED 
      FROM
         all_objects 
      WHERE
         object_type IN 
         (
            'TABLE',
            'VIEW'
         )
      UNION
      SELECT
         NULL table_catalog,
         DECODE (o2.owner, 'PUBLIC', NULL, o2.owner) table_schema,
         o2.object_name TABLE_NAME,
         o2.object_type table_type,
         NULL table_guid,
         NULL description,
         NULL table_propid,
         o2.created DATE_CREATED,
         o2.last_ddl_time DATE_MODIFIED 
      FROM
         all_objects o2,
         all_objects o3,
         all_synonyms s 
      WHERE
         o2.object_type = 'SYNONYM' 
         AND 
         (
            o3.object_type = 'TABLE' 
            OR o3.object_type = 'VIEW'
         )
         AND o2.owner = s.owner 
         AND o2.object_name = s.synonym_name 
         AND s.table_owner = o3.owner 
         AND s.table_name = o3.object_name 
   )
   DBSCHEMA_TABLESORDER BY 4 DESC,
   3 ASC,
   2 ASC