APPS.FND_GEN_MIG_CMDS dependencies on DBA_TAB_COLUMNS

Line 239: FROM dba_tab_columns

235: SELECT owner,
236: table_name,
237: column_name,
238: data_type
239: FROM dba_tab_columns
240: WHERE owner = l_owner
241: AND table_name = l_table_name
242: AND data_type IN ('CLOB', 'BLOB', 'NCLOB');
243: -- ORDER by column_id;

Line 261: from dba_tab_columns c

257: FROM dba_lobs d
258: WHERE owner = l_owner
259: AND table_name = l_table_name
260: AND NOT EXISTS (select column_name
261: from dba_tab_columns c
262: where c.data_type in ('CLOB','BLOB','NCLOB')
263: and c.owner = l_owner
264: and c.table_name = l_table_name
265: and c.column_name = d.column_name)

Line 268: dba_tab_columns tc

264: and c.table_name = l_table_name
265: and c.column_name = d.column_name)
266: AND EXISTS (select attr_name
267: from dba_type_attrs ta,
268: dba_tab_columns tc
269: where tc.owner = l_owner
270: and tc.table_name = l_table_name
271: and tc.column_name = SUBSTR(d.column_name, 2, INSTR(d.column_name, '.', 1) - 3)
272: and tc.data_type_owner = ta.owner

Line 1611: FROM dba_tab_columns

1607: IS
1608: CURSOR long_col_csr IS
1609: SELECT column_name,
1610: data_type
1611: FROM dba_tab_columns
1612: WHERE owner = p_owner
1613: AND table_name = p_table_name
1614: AND data_type IN ('LONG', 'LONG RAW');
1615: BEGIN

Line 1689: from dba_tab_columns dtc

1685: AND fot.object_type = 'TABLE'
1686: AND dt.cluster_name IS NULL
1687: AND dt.table_name NOT LIKE 'BIN$%'
1688: AND EXISTS ( select dtc.table_name
1689: from dba_tab_columns dtc
1690: where dtc.owner = p_owner
1691: and dtc.table_name = dt.table_name
1692: and dtc.data_type in ('LONG', 'LONG RAW'))
1693: UNION ALL

Line 1710: from dba_tab_columns dtc

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$%'
1709: AND EXISTS ( select dtc.table_name
1710: from dba_tab_columns dtc
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

Line 1911: from dba_tab_columns dtc

1907: AND fot.object_type = 'TABLE'
1908: AND NVL(dt.temporary, 'N') = 'N'
1909: AND dt.cluster_name IS NULL
1910: AND NOT EXISTS ( select dtc.table_name
1911: from dba_tab_columns dtc
1912: where dtc.owner = p_owner
1913: and dtc.table_name = dt.table_name
1914: and dtc.data_type in ('LONG', 'LONG RAW'))
1915: AND NOT EXISTS ( select ds.table_name

Line 1962: from dba_tab_columns dtc

1958: AND NVL(dt.temporary, 'N') = 'N'
1959: AND NVL(dt.iot_type, 'X') NOT IN ('IOT', 'IOT_OVERFLOW')
1960: AND dt.cluster_name IS NULL
1961: AND NOT EXISTS ( select dtc.table_name
1962: from dba_tab_columns dtc
1963: where dtc.owner = p_owner
1964: and dtc.table_name = dt.table_name
1965: and dtc.data_type in ('LONG', 'LONG RAW'))
1966: AND NOT EXISTS ( select ds.table_name