APPS.FND_GEN_MIG_CMDS dependencies on FND_OBJECT_TABLESPACES

Line 1679: fnd_object_tablespaces fot,

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
1683: AND dt.table_name = fot.object_name

Line 1715: FROM fnd_object_tablespaces fot

1711: where dtc.owner = p_owner
1712: and dtc.table_name = dt.table_name
1713: and dtc.data_type in ('LONG', 'LONG RAW'))
1714: AND NOT EXISTS ( SELECT object_name
1715: FROM fnd_object_tablespaces fot
1716: WHERE fot.oracle_username = p_owner
1717: AND fot.object_type = 'TABLE'
1718: AND fot.object_name = dt.table_name);
1719:

Line 1901: fnd_object_tablespaces fot,

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
1905: AND dt.table_name = fot.object_name

Line 1954: FROM fnd_object_tablespaces fot

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
1955: WHERE fot.oracle_username = p_owner
1956: AND fot.object_type = 'TABLE'
1957: AND fot.object_name = dt.table_name)
1958: AND NVL(dt.temporary, 'N') = 'N'