APPS.FND_TS_SIZE dependencies on DBA_EXTERNAL_TABLES

Line 229: from dba_external_tables det

225: AND nvl(d.iot_type,'ZZZ') NOT IN ('IOT', 'IOT_OVERFLOW')
226: AND NVL(d.temporary, 'N') = 'N'
227: AND d.table_name NOT LIKE 'BIN$%'
228: AND NOT EXISTS ( select det.table_name
229: from dba_external_tables det
230: where det.owner = d.owner
231: and det.table_name = d.table_name)
232: UNION ALL
233: -- UNCLASSIFIED

Line 270: from dba_external_tables det

266: FROM dba_queue_tables dqt
267: WHERE dqt.owner = p_app
268: and dqt.queue_table = d.table_name)
269: AND NOT EXISTS ( select det.table_name
270: from dba_external_tables det
271: where det.owner = p_app
272: and det.table_name = d.table_name)
273: AND d.table_name NOT LIKE 'AQ$%'
274: AND d.table_name NOT LIKE 'DR$%'

Line 395: from dba_external_tables det

391: and d.table_name = dt.table_name
392: and NVL(dt.temporary, 'N') = 'N'
393: AND dt.table_name NOT LIKE 'BIN$%'
394: AND NOT EXISTS ( select det.table_name
395: from dba_external_tables det
396: where det.owner = dt.owner
397: and det.table_name = dt.table_name)
398: UNION ALL
399: -- LOBS in Unclassified Tables

Line 438: from dba_external_tables det

434: FROM dba_queue_tables dqt
435: WHERE dqt.owner = p_app
436: and dqt.queue_table = dt.table_name)
437: AND NOT EXISTS ( select det.table_name
438: from dba_external_tables det
439: where det.owner = p_app
440: and det.table_name = d.table_name)
441: AND dt.table_name NOT LIKE 'AQ$%'
442: AND dt.table_name NOT LIKE 'DR$%'

Line 470: from dba_external_tables det

466: FROM dba_queue_tables dqt
467: WHERE dqt.owner = p_app
468: and dqt.queue_table = dt.table_name)
469: AND NOT EXISTS ( select det.table_name
470: from dba_external_tables det
471: where det.owner = p_app
472: and det.table_name = d.table_name)
473: AND dt.table_name NOT LIKE 'AQ$%'
474: AND dt.table_name NOT LIKE 'DR$%'

Line 1179: from dba_external_tables det

1175: AND nvl(dt.iot_type,'ZZZ') NOT IN ('IOT', 'IOT_OVERFLOW')
1176: AND NVL(dt.temporary, 'N') = 'N'
1177: AND dt.table_name NOT LIKE 'BIN$%'
1178: AND NOT EXISTS ( select det.table_name
1179: from dba_external_tables det
1180: where det.owner = dt.owner
1181: and det.table_name = dt.table_name)
1182: UNION ALL
1183: -- UNCLASSIFIED

Line 1222: from dba_external_tables det

1218: FROM dba_queue_tables dqt
1219: WHERE dqt.owner = dt.owner
1220: AND dqt.queue_table = dt.table_name)
1221: AND NOT EXISTS ( select det.table_name
1222: from dba_external_tables det
1223: where det.owner = dt.owner
1224: and det.table_name = dt.table_name)
1225: AND dt.table_name NOT LIKE 'AQ$%'
1226: AND dt.table_name NOT LIKE 'DR$%'

Line 1360: from dba_external_tables det

1356: AND dl.table_name = dt.table_name
1357: AND NVL(dt.temporary, 'N') = 'N'
1358: AND dt.table_name NOT LIKE 'BIN$%'
1359: AND NOT EXISTS ( select det.table_name
1360: from dba_external_tables det
1361: where det.owner = dt.owner
1362: and det.table_name = dt.table_name)
1363: UNION ALL
1364: -- LOBS in Unclassified Tables

Line 1405: from dba_external_tables det

1401: WHERE dqt.owner = dt.owner
1402: and dqt.queue_table = dt.table_name)
1403: AND NOT EXISTS
1404: (select det.table_name
1405: from dba_external_tables det
1406: where det.owner = dt.owner
1407: and det.table_name = dt.table_name)
1408: AND dt.table_name NOT LIKE 'AQ$%'
1409: AND dt.table_name NOT LIKE 'DR$%'

Line 1438: from dba_external_tables det

1434: FROM dba_queue_tables dqt
1435: WHERE dqt.owner = dt.owner
1436: and dqt.queue_table = dt.table_name)
1437: AND NOT EXISTS ( select det.table_name
1438: from dba_external_tables det
1439: where det.owner = dt.owner
1440: and det.table_name = dt.table_name)
1441: AND dt.table_name NOT LIKE 'AQ$%'
1442: AND dt.table_name NOT LIKE 'DR$%'