VIEW: MDSYS.ALL_SDO_TIN_PC_SYSDATA

Source

View Text - Preformatted

SELECT SDO_OWNER                 OWNER,
       TABLE_NAME,
       COLUMN_NAME,
       DEP_TABLE_SCHEMA,
       DEP_TABLE_NAME
FROM SDO_TIN_PC_SYSDATA_TABLE a
WHERE
(
    exists
    (
     select table_name from all_tables
     where table_name=a.table_name
     and owner = sdo_owner
     union all
     select table_name from all_object_tables
     where table_name=a.table_name
     and owner = sdo_owner
     union all
     select view_name table_name from all_views
     where  view_name=a.table_name
     and owner = sdo_owner
     )
)

View Text - HTML Formatted

SELECT SDO_OWNER OWNER
, TABLE_NAME
, COLUMN_NAME
, DEP_TABLE_SCHEMA
, DEP_TABLE_NAME FROM SDO_TIN_PC_SYSDATA_TABLE A WHERE ( EXISTS ( SELECT TABLE_NAME
FROM ALL_TABLES
WHERE TABLE_NAME=A.TABLE_NAME
AND OWNER = SDO_OWNER UNION ALL SELECT TABLE_NAME
FROM ALL_OBJECT_TABLES
WHERE TABLE_NAME=A.TABLE_NAME
AND OWNER = SDO_OWNER UNION ALL SELECT VIEW_NAME TABLE_NAME
FROM ALL_VIEWS
WHERE VIEW_NAME=A.TABLE_NAME
AND OWNER = SDO_OWNER ) )