APPS.FND_GEN_MIG_CMDS dependencies on DBA_INDEXES

Line 298: FROM dba_indexes

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
299: WHERE owner = l_owner
300: AND table_name = l_table_name
301: AND index_type = 'IOT - TOP';
302: l_iot_top_name DBA_INDEXES.INDEX_NAME%TYPE;

Line 302: l_iot_top_name DBA_INDEXES.INDEX_NAME%TYPE;

298: FROM dba_indexes
299: WHERE owner = l_owner
300: AND table_name = l_table_name
301: AND index_type = 'IOT - TOP';
302: l_iot_top_name DBA_INDEXES.INDEX_NAME%TYPE;
303:
304: CURSOR part_csr(l_owner VARCHAR2, l_table_name VARCHAR2) IS
305: SELECT partitioning_type,
306: subpartitioning_type,

Line 792: FROM dba_indexes

788: domidx_opstatus,
789: domidx_status,
790: ltrim(rtrim(degree)) degree,
791: ltrim(rtrim(logging)) logging
792: FROM dba_indexes
793: WHERE table_owner = l_owner
794: AND table_name = l_table_name
795: AND NVL(temporary, 'N') = 'N'
796: AND index_type NOT IN ('IOT - TOP', 'LOB', 'CLUSTER')

Line 839: FROM dba_indexes di

835: di.tablespace_name,
836: di.partitioned,
837: di.logging,
838: 'IOT' iot_type
839: FROM dba_indexes di
840: WHERE di.owner = l_index_owner
841: AND di.table_name LIKE l_ctx_tabs
842: AND di.tablespace_name <> l_tablespace_name
843: AND di.index_type = 'IOT _ TOP'

Line 1192: FROM dba_indexes

1188: p_iot_name IN VARCHAR2)
1189: RETURN VARCHAR2 IS
1190: CURSOR iot_ind_csr IS
1191: SELECT tablespace_name
1192: FROM dba_indexes
1193: WHERE table_owner = p_owner
1194: AND table_name = p_iot_name
1195: AND index_type = 'IOT - TOP';
1196: l_tablespace_name VARCHAR2(30);

Line 2001: dba_indexes di,

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
2005: AND dt.owner = di.table_owner