eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_TS_MIG_UTIL dependencies on DBA_TABLES

Line 48: FROM dba_tablespaces dt,

44: PROCEDURE migrate_tsp_to_local
45: IS
46: CURSOR tsp_csr IS
47: SELECT distinct dt.tablespace_name
48: FROM dba_tablespaces dt,
49: fnd_product_installations fpi
50: WHERE dt.extent_management = 'DICTIONARY'
51: AND (dt.tablespace_name = fpi.tablespace
52: OR dt.tablespace_name = fpi.index_tablespace);

Line 53: l_tablespace_name DBA_TABLESPACES.TABLESPACE_NAME%TYPE;

49: fnd_product_installations fpi
50: WHERE dt.extent_management = 'DICTIONARY'
51: AND (dt.tablespace_name = fpi.tablespace
52: OR dt.tablespace_name = fpi.index_tablespace);
53: l_tablespace_name DBA_TABLESPACES.TABLESPACE_NAME%TYPE;
54: BEGIN
55: OPEN tsp_csr;
56: LOOP
57: FETCH tsp_csr INTO l_tablespace_name;

Line 90: FROM dba_tablespaces

86: IS
87: CURSOR tbs_ues_csr IS
88: SELECT initial_extent,
89: allocation_type
90: FROM dba_tablespaces
91: WHERE tablespace_name = p_tablespace_name;
92: l_ues NUMBER;
93: l_allocation_type DBA_TABLESPACES.ALLOCATION_TYPE%TYPE;
94: BEGIN

Line 93: l_allocation_type DBA_TABLESPACES.ALLOCATION_TYPE%TYPE;

89: allocation_type
90: FROM dba_tablespaces
91: WHERE tablespace_name = p_tablespace_name;
92: l_ues NUMBER;
93: l_allocation_type DBA_TABLESPACES.ALLOCATION_TYPE%TYPE;
94: BEGIN
95: OPEN tbs_ues_csr;
96: FETCH tbs_ues_csr INTO l_ues, l_allocation_type;
97: if tbs_ues_csr%NOTFOUND then

Line 116: from dba_tablespaces)

112: CURSOR tsp_csr IS
113: SELECT tablespace
114: FROM fnd_tablespaces
115: WHERE tablespace NOT IN (select tablespace_name
116: from dba_tablespaces)
117: AND tablespace_type IN ('TRANSACTION_TABLES', 'TRANSACTION_INDEXES', 'REFERENCE', 'ARCHIVE' ,'SUMMARY', 'INTERFACE', 'MEDIA', 'AQ', 'NOLOGGING', 'TOOLS');
118: l_tablespace_name VARCHAR2(30);
119: BEGIN
120: OPEN tsp_csr;

Line 272: FROM dba_tables dt,

268: fot.object_source,
269: fot.tablespace_type,
270: fot.custom_tablespace_type,
271: fot.custom_flag
272: FROM dba_tables dt,
273: fnd_object_tablespaces fot
274: WHERE dt.table_name like l_table_name||'%'
275: AND fot.oracle_username(+) = dt.owner
276: AND fot.object_name(+) = dt.table_name

Line 295: l_owner DBA_TABLES.OWNER%TYPE;

291: AND dt.table_name not like 'AQ$%'
292: AND dt.table_name not like 'DR$'
293: AND dt.table_name NOT LIKE 'RUPD$%'
294: ORDER BY dt.owner;
295: l_owner DBA_TABLES.OWNER%TYPE;
296: l_last_owner DBA_TABLES.OWNER%TYPE;
297: l_table_name DBA_TABLES.TABLE_NAME%TYPE;
298: l_tablespace_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
299: l_custom_tsp_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;

Line 296: l_last_owner DBA_TABLES.OWNER%TYPE;

292: AND dt.table_name not like 'DR$'
293: AND dt.table_name NOT LIKE 'RUPD$%'
294: ORDER BY dt.owner;
295: l_owner DBA_TABLES.OWNER%TYPE;
296: l_last_owner DBA_TABLES.OWNER%TYPE;
297: l_table_name DBA_TABLES.TABLE_NAME%TYPE;
298: l_tablespace_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
299: l_custom_tsp_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
300: l_custom_flag FND_OBJECT_TABLESPACES.CUSTOM_FLAG%TYPE;

Line 297: l_table_name DBA_TABLES.TABLE_NAME%TYPE;

293: AND dt.table_name NOT LIKE 'RUPD$%'
294: ORDER BY dt.owner;
295: l_owner DBA_TABLES.OWNER%TYPE;
296: l_last_owner DBA_TABLES.OWNER%TYPE;
297: l_table_name DBA_TABLES.TABLE_NAME%TYPE;
298: l_tablespace_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
299: l_custom_tsp_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
300: l_custom_flag FND_OBJECT_TABLESPACES.CUSTOM_FLAG%TYPE;
301: l_object_source FND_OBJECT_TABLESPACES.OBJECT_SOURCE%TYPE;

Line 384: l_owner DBA_TABLES.OWNER%TYPE;

380: ORDER BY rule_id;
381: query VARCHAR2(4000);
382: TYPE rules_tab_csr_type IS REF CURSOR;
383: rules_tab_csr rules_tab_csr_type;
384: l_owner DBA_TABLES.OWNER%TYPE;
385: l_last_owner DBA_TABLES.OWNER%TYPE;
386: l_table_name DBA_TABLES.TABLE_NAME%TYPE;
387: l_tablespace_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
388: l_custom_tsp_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;

Line 385: l_last_owner DBA_TABLES.OWNER%TYPE;

381: query VARCHAR2(4000);
382: TYPE rules_tab_csr_type IS REF CURSOR;
383: rules_tab_csr rules_tab_csr_type;
384: l_owner DBA_TABLES.OWNER%TYPE;
385: l_last_owner DBA_TABLES.OWNER%TYPE;
386: l_table_name DBA_TABLES.TABLE_NAME%TYPE;
387: l_tablespace_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
388: l_custom_tsp_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
389: l_custom_flag FND_OBJECT_TABLESPACES.CUSTOM_FLAG%TYPE;

Line 386: l_table_name DBA_TABLES.TABLE_NAME%TYPE;

382: TYPE rules_tab_csr_type IS REF CURSOR;
383: rules_tab_csr rules_tab_csr_type;
384: l_owner DBA_TABLES.OWNER%TYPE;
385: l_last_owner DBA_TABLES.OWNER%TYPE;
386: l_table_name DBA_TABLES.TABLE_NAME%TYPE;
387: l_tablespace_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
388: l_custom_tsp_type FND_OBJECT_TABLESPACES.TABLESPACE_TYPE%TYPE;
389: l_custom_flag FND_OBJECT_TABLESPACES.CUSTOM_FLAG%TYPE;
390: l_object_source FND_OBJECT_TABLESPACES.OBJECT_SOURCE%TYPE;

Line 409: FROM dba_tables dt, fnd_object_tablespaces fot

405: LOOP
406: query := 'SELECT dt.owner, dt.table_name, fot.object_source,
407: fot.tablespace_type, fot.custom_tablespace_type,
408: fot.custom_flag
409: FROM dba_tables dt, fnd_object_tablespaces fot
410: '||rules_rec.rule_query||'
411: AND fot.oracle_username(+) = dt.owner
412: AND fot.object_name(+) = dt.table_name
413: AND NVL(dt.iot_type, ''X'') NOT IN (''IOT'', ''IOT_OVERFLOW'')

Line 511: from dba_tablespaces dt

507: SELECT dtq.tablespace_name
508: FROM dba_ts_quotas dtq
509: WHERE dtq.username = p_username
510: AND EXISTS (select dt.tablespace_name
511: from dba_tablespaces dt
512: where dt.tablespace_name = dtq.tablespace_name)
513: ORDER by dtq.tablespace_name;
514:
515: CURSOR txn_tsp_csr IS