APPS.FND_GEN_MIG_CMDS dependencies on FND_TABLESPACES

Line 138: FROM fnd_tablespaces

134: RETURN VARCHAR2
135: IS
136: CURSOR idx_tbs_csr IS
137: SELECT tablespace
138: FROM fnd_tablespaces
139: WHERE tablespace_type = fnd_ts_mig_util.l_def_ind_tsp;
140: l_tablespace_name VARCHAR2(30);
141: BEGIN
142: OPEN idx_tbs_csr;

Line 145: raise_application_error(-20001, 'FND_TABLESPACES table does not have any entry for the Transaction index tablespace');

141: BEGIN
142: OPEN idx_tbs_csr;
143: FETCH idx_tbs_csr INTO l_tablespace_name;
144: if idx_tbs_csr%NOTFOUND then
145: raise_application_error(-20001, 'FND_TABLESPACES table does not have any entry for the Transaction index tablespace');
146: end if;
147: CLOSE idx_tbs_csr;
148: RETURN l_tablespace_name;
149: END get_txn_idx_tablespace;

Line 883: l_tablespace_name FND_TABLESPACES.TABLESPACE%TYPE;

879: l_execution_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE := nvl(p_execution_mode, 'P');
880: -- l_parent_exec_mode FND_TS_MIG_CMDS.EXECUTION_MODE%TYPE := p_execution_mode;
881: l_parent_lineno NUMBER := p_parent_lineno;
882: l_def_tablespace_name DBA_PART_INDEXES.DEF_TABLESPACE_NAME%TYPE;
883: l_tablespace_name FND_TABLESPACES.TABLESPACE%TYPE;
884: l_part NUMBER;
885: l_logging VARCHAR2(30) := 'YES';
886:
887: BEGIN

Line 1230: fnd_tablespaces ft

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
1234: AND ft.tablespace_type = fnd_ts_mig_util.l_aq_tab_tsp

Line 1390: fnd_tablespaces ft

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
1394: AND dsl.log_table = dt.table_name

Line 1481: fnd_tablespaces ft

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
1485: AND dt.cluster_name IS NULL

Line 1680: fnd_tablespaces ft

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
1683: AND dt.table_name = fot.object_name
1684: AND NVL(fot.custom_tablespace_type, fot.tablespace_type) = ft.tablespace_type

Line 1704: fnd_tablespaces ft

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
1708: AND dt.table_name NOT LIKE 'BIN$%'

Line 1902: fnd_tablespaces ft

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
1905: AND dt.table_name = fot.object_name
1906: AND NVL(fot.custom_tablespace_type, fot.tablespace_type) = ft.tablespace_type

Line 1950: fnd_tablespaces ft

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
1954: FROM fnd_object_tablespaces fot

Line 2002: fnd_tablespaces ft

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
2006: AND dt.table_name = di.table_name