APPS.FND_GEN_MIG_CMDS dependencies on DBA_TABLES

Line 290: FROM dba_tables

286: AND table_name = l_table_name;
287:
288: CURSOR iot_csr(l_owner VARCHAR2, l_table_name VARCHAR2) IS
289: SELECT table_name
290: FROM dba_tables
291: WHERE owner = l_owner
292: AND iot_type = 'IOT_OVERFLOW'
293: AND iot_name = l_table_name;
294: l_iot_over_name DBA_TABLES.TABLE_NAME%TYPE;

Line 294: l_iot_over_name DBA_TABLES.TABLE_NAME%TYPE;

290: FROM dba_tables
291: WHERE owner = l_owner
292: AND iot_type = 'IOT_OVERFLOW'
293: AND iot_name = l_table_name;
294: l_iot_over_name DBA_TABLES.TABLE_NAME%TYPE;
295:
296: CURSOR iot_top_csr(l_owner VARCHAR2, l_table_name VARCHAR2) IS
297: SELECT index_name
298: FROM dba_indexes

Line 826: FROM dba_tables dt

822: dt.tablespace_name,
823: dt.partitioned,
824: dt.logging,
825: dt.iot_type
826: FROM dba_tables dt
827: WHERE dt.owner = l_index_owner
828: AND dt.table_name LIKE l_ctx_tabs
829: AND dt.tablespace_name <> l_tablespace_name
830: AND NVL(dt.iot_type, 'N') NOT IN ('IOT', 'IOT_OVERFLOW')

Line 1229: dba_tables dt,

1225: dt.iot_type iot_type,
1226: dt.partitioned partitioned,
1227: dt.logging logging
1228: FROM dba_queue_tables dqt,
1229: dba_tables dt,
1230: fnd_tablespaces ft
1231: WHERE dqt.owner = p_owner
1232: AND dqt.owner = dt.owner
1233: AND dqt.queue_table = dt.table_name

Line 1305: FROM dba_tables

1301: tablespace_name,
1302: iot_type,
1303: partitioned,
1304: logging
1305: FROM dba_tables
1306: WHERE owner = :1
1307: AND NVL(temporary, ''N'') = ''N''
1308: AND table_name like ''AQ$_''||:2||''%''';
1309: OPEN child_aq_csr FOR qry USING aq_rec_tab.owner(i), aq_rec_tab.queue_table(i);

Line 1389: dba_tables dt,

1385: dt.iot_type,
1386: dt.partitioned,
1387: dt.logging
1388: FROM dba_snapshot_logs dsl,
1389: dba_tables dt,
1390: fnd_tablespaces ft
1391: WHERE dsl.log_owner = p_owner
1392: AND dsl.master = p_table_name
1393: AND dsl.log_owner = dt.owner

Line 1480: dba_tables dt,

1476: dt.iot_type,
1477: dt.partitioned,
1478: dt.logging
1479: FROM dba_snapshots ds,
1480: dba_tables dt,
1481: fnd_tablespaces ft
1482: WHERE ds.owner = p_owner
1483: AND ds.owner = dt.owner
1484: AND ds.table_name = dt.table_name

Line 1678: FROM dba_tables dt,

1674: dt.tablespace_name,
1675: dt.iot_type,
1676: dt.partitioned,
1677: dt.logging
1678: FROM dba_tables dt,
1679: fnd_object_tablespaces fot,
1680: fnd_tablespaces ft
1681: WHERE dt.owner = p_owner
1682: AND dt.owner = fot.oracle_username

Line 1703: FROM dba_tables dt,

1699: dt.tablespace_name,
1700: dt.iot_type,
1701: dt.partitioned,
1702: dt.logging
1703: FROM dba_tables dt,
1704: fnd_tablespaces ft
1705: WHERE dt.owner = p_owner
1706: AND ft.tablespace_type = fnd_ts_mig_util.l_unclass_tsp
1707: AND dt.cluster_name IS NULL

Line 1900: FROM dba_tables dt,

1896: dt.tablespace_name,
1897: dt.iot_type,
1898: dt.partitioned,
1899: dt.logging
1900: FROM dba_tables dt,
1901: fnd_object_tablespaces fot,
1902: fnd_tablespaces ft
1903: WHERE dt.owner = p_owner
1904: AND dt.owner = fot.oracle_username

Line 1949: FROM dba_tables dt,

1945: dt.tablespace_name,
1946: dt.iot_type,
1947: dt.partitioned,
1948: dt.logging
1949: FROM dba_tables dt,
1950: fnd_tablespaces ft
1951: WHERE dt.owner = p_owner
1952: AND ft.tablespace_type = fnd_ts_mig_util.l_unclass_tsp
1953: AND NOT EXISTS ( SELECT object_name

Line 2000: FROM dba_tables dt,

1996: di.tablespace_name,
1997: dt.iot_type,
1998: dt.partitioned,
1999: dt.logging
2000: FROM dba_tables dt,
2001: dba_indexes di,
2002: fnd_tablespaces ft
2003: WHERE dt.owner = p_owner
2004: AND ft.tablespace_type = fnd_ts_mig_util.l_def_tab_tsp