SYSTEM.AD_APPS_PRIVATE dependencies on DBA_TABLES

Line 1570: from dba_tables

1566: -- bug1301043.
1567: --
1568: cursor grants_cursor is
1569: (select table_name object_name, 'TABLE ' object_type
1570: from dba_tables
1571: where owner= upper(base_schema)
1572: and iot_name is null
1573: and table_name not like '%$%'
1574: minus

Line 1587: from dba_tables dt

1583: and sequence_name not like '%$%';
1584:
1585: cursor synonyms_cursor is
1586: (select table_name object_name, 'TABLE ' object_type
1587: from dba_tables dt
1588: where owner= upper(base_schema)
1589: and iot_name is null
1590: and table_name not like '%$%'
1591: minus

Line 2154: ' dba_tables dt '||

2150: if create_mls_views then
2151: -- work on tables that are multilingual
2152: statement := 'select distinct upper(atc.table_name) '||
2153: 'from '||aol_schema||'.ak_translated_columns atc,'||
2154: ' dba_tables dt '||
2155: 'where dt.table_name = upper(atc.table_name) '||
2156: 'and nvl(atc.enabled_flag,''Y'') = ''Y'' '||
2157: 'and dt.owner = :table_schema ';
2158: else