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_SIZE dependencies on DBA_TABLES

Line 219: DBA_TABLES d

215: 'TABLE' subobject_type,
216: 'YES' classified,
217: nvl(d.partitioned,'NO') partitioned
218: FROM fnd_object_tablespaces o,
219: DBA_TABLES d
220: WHERE d.owner = o.oracle_username
221: AND o.oracle_username = p_app
222: AND d.owner = p_app
223: AND o.object_name = d.table_name

Line 246: FROM dba_tables d

242: 'TABLE' object_type,
243: 'TABLE' subobject_type,
244: 'NO' classified,
245: nvl(d.partitioned,'NO') partitioned
246: FROM dba_tables d
247: WHERE d.owner = p_app
248: AND NOT EXISTS
249: (SELECT object_name
250: FROM fnd_object_tablespaces o

Line 288: FROM dba_tables dt,

284: 'TABLE' object_type,
285: 'MV_LOG' subobject_type,
286: 'NO' classified,
287: nvl(dt.partitioned,'NO') partitioned
288: FROM dba_tables dt,
289: dba_snapshot_logs dsl
290: WHERE dsl.log_owner = p_app
291: AND dsl.log_owner = dt.owner
292: AND dt.owner = p_app

Line 308: dba_tables dt

304: 'MVIEW' subobject_type,
305: 'NO' classified,
306: nvl(dt.partitioned,'NO') partitioned
307: FROM dba_snapshots d,
308: dba_tables dt
309: WHERE d.owner = p_app
310: AND d.owner = dt.owner
311: AND dt.owner = p_app
312: AND dt.table_name = d.table_name

Line 328: FROM dba_tables dt

324: 'TABLE' object_type,
325: 'IOT' subobject_type,
326: 'NO' classified,
327: nvl(dt.partitioned,'NO') partitioned
328: FROM dba_tables dt
329: WHERE dt.owner = p_app
330: AND NVL(dt.iot_type, 'ZZZ') = 'IOT_OVERFLOW'
331: AND NVL(dt.iot_name, 'ZZZ') NOT LIKE 'AQ$%'
332: AND NVL(dt.iot_name, 'ZZZ') NOT LIKE 'DR$%'

Line 347: FROM dba_tables dt

343: 'TABLE' object_type,
344: 'AQ' subobject_type,
345: 'NO' classified,
346: nvl(dt.partitioned,'NO') partitioned
347: FROM dba_tables dt
348: WHERE dt.owner = p_app
349: AND NVL(dt.iot_type, 'ZZZ') = 'IOT_OVERFLOW'
350: AND NVL(dt.iot_name, 'ZZZ') LIKE 'AQ$%'
351: AND NVL(dt.temporary, 'N') = 'N'

Line 364: FROM dba_tables dt

360: 'TABLE' object_type,
361: 'DOMAIN' subobject_type,
362: 'NO' classified,
363: nvl(dt.partitioned,'NO') partitioned
364: FROM dba_tables dt
365: WHERE dt.owner = p_app
366: AND NVL(dt.iot_type, 'ZZZ') = 'IOT_OVERFLOW'
367: AND NVL(dt.iot_name, 'ZZZ') LIKE 'DR$%'
368: AND NVL(dt.temporary, 'N') = 'N'

Line 383: dba_tables dt

379: 'YES' classified,
380: nvl(dt.partitioned,'NO') partitioned
381: from fnd_object_tablespaces o,
382: dba_lobs d,
383: dba_tables dt
384: where dt.owner = p_app
385: and dt.owner = o.oracle_username
386: and o.oracle_username = p_app
387: and o.object_name = d.table_name

Line 411: dba_tables dt

407: 'TABLE' subobject_type,
408: 'NO' classified,
409: nvl(dt.partitioned,'NO') partitioned
410: from dba_lobs d,
411: dba_tables dt
412: where d.owner = p_app
413: and d.owner = dt.owner
414: and dt.owner = p_app
415: and d.table_name = dt.table_name

Line 458: dba_tables dt

454: 'IOT' subobject_type,
455: 'NO' classified,
456: nvl(dt.partitioned,'NO') partitioned
457: from dba_lobs d,
458: dba_tables dt
459: where d.owner = p_app
460: and d.owner = dt.owner
461: and dt.owner = p_app
462: and d.table_name = dt.table_name

Line 489: dba_tables dt

485: 'MVIEW' subobject_type,
486: 'NO' classified,
487: nvl(dt.partitioned,'NO') partitioned
488: from dba_lobs d,
489: dba_tables dt
490: where d.owner = p_app
491: and d.owner = dt.owner
492: and dt.owner = p_app
493: and d.table_name = dt.table_name

Line 514: dba_tables dt

510: 'AQ' subobject_type,
511: 'NO' classified,
512: nvl(dt.partitioned,'NO') partitioned
513: from dba_lobs d,
514: dba_tables dt
515: where d.owner = p_app
516: and d.owner = dt.owner
517: and dt.owner = p_app
518: and d.table_name = dt.table_name

Line 539: dba_tables dt

535: 'DOMAIN' subobject_type,
536: 'NO' classified,
537: nvl(dt.partitioned,'NO') partitioned
538: from dba_lobs d,
539: dba_tables dt
540: where d.owner = p_app
541: and d.owner = dt.owner
542: and dt.owner = p_app
543: and d.table_name = dt.table_name

Line 560: dba_tables dt

556: 'AQ' subobject_type,
557: 'NO' classified,
558: nvl(dt.partitioned,'NO') partitioned
559: FROM dba_queue_tables dqt,
560: dba_tables dt
561: WHERE dt.owner = p_app
562: AND dt.owner = dqt.owner
563: AND dqt.owner = p_app
564: AND dt.table_name = dqt.queue_table

Line 579: FROM dba_tables dt

575: 'TABLE' object_type,
576: 'AQ' subobject_type,
577: 'NO' classified,
578: nvl(dt.partitioned,'NO') partitioned
579: FROM dba_tables dt
580: WHERE dt.owner = p_app
581: AND dt.table_name LIKE 'AQ$%'
582: AND dt.iot_type IS NULL
583: AND NVL(dt.temporary, 'N') = 'N'

Line 596: FROM dba_tables dt

592: 'TABLE' object_type,
593: 'DOMAIN' subobject_type,
594: 'NO' classified,
595: nvl(dt.partitioned,'NO') partitioned
596: FROM dba_tables dt
597: WHERE dt.owner = p_app
598: AND dt.table_name LIKE 'DR$%'
599: AND dt.iot_type IS NULL
600: AND dt.table_name NOT LIKE 'BIN$%'

Line 740: dba_tables dt

736: 'INDEX' subobject_type,
737: 'NO' classified,
738: nvl(i.partitioned,'NO') partitioned
739: FROM dba_indexes i,
740: dba_tables dt
741: WHERE i.table_owner = p_app
742: AND i.table_owner = dt.owner
743: AND i.table_name = dt.table_name
744: AND NVL(dt.iot_type, 'ZZZ') NOT IN ('IOT', 'IOT_OVERFLOW')

Line 784: dba_tables dt

780: 'INDEX' subobject_type,
781: 'NO' classified,
782: nvl(i.partitioned,'NO') partitioned
783: FROM dba_indexes i,
784: dba_tables dt
785: WHERE i.table_owner = p_app
786: AND i.table_owner = dt.owner
787: AND i.table_name = dt.table_name
788: AND NVL(dt.iot_type, 'ZZZ') NOT IN ('IOT', 'IOT_OVERFLOW')

Line 850: dba_tables dt

846: 'IOT' subobject_type,
847: 'NO' classified,
848: nvl(i.partitioned,'NO') partitioned
849: FROM dba_indexes i,
850: dba_tables dt
851: WHERE i.table_owner = p_app
852: AND dt.owner = i.table_owner
853: AND dt.table_name = i.table_name
854: AND NVL(dt.iot_type, 'ZZZ') IN ('IOT', 'IOT_OVERFLOW')

Line 879: dba_tables dt

875: 'IOT' subobject_type,
876: 'NO' classified,
877: nvl(i.partitioned,'NO') partitioned
878: FROM dba_indexes i,
879: dba_tables dt
880: WHERE i.table_owner = p_app
881: AND dt.owner = i.table_owner
882: AND dt.table_name = i.table_name
883: AND NVL(dt.iot_type, 'ZZZ') IN ('IOT', 'IOT_OVERFLOW')

Line 1168: dba_tables dt

1164: 'TABLE' subobject_type,
1165: 'YES' classified,
1166: NVL(dt.partitioned,'NO') partitioned
1167: FROM fnd_object_tablespaces fot,
1168: dba_tables dt
1169: WHERE dt.owner IN (select oracle_username
1170: from fnd_oracle_userid
1171: where read_only_flag IN ('E','A','U','K','M'))
1172: AND dt.owner = fot.oracle_username

Line 1196: FROM dba_tables dt

1192: 'TABLE' object_type,
1193: 'TABLE' subobject_type,
1194: 'NO' classified,
1195: NVL(dt.partitioned,'NO') partitioned
1196: FROM dba_tables dt
1197: WHERE dt.owner IN (select oracle_username
1198: from fnd_oracle_userid
1199: where read_only_flag IN ('E','A','U','K','M'))
1200: AND NOT EXISTS

Line 1242: FROM dba_tables dt,

1238: 'TABLE' object_type,
1239: 'MV_LOG' subobject_type,
1240: 'NO' classified,
1241: NVL(dt.partitioned,'NO') partitioned
1242: FROM dba_tables dt,
1243: dba_snapshot_logs dsl
1244: WHERE dsl.log_owner IN (select oracle_username
1245: from fnd_oracle_userid
1246: where read_only_flag IN ('E','A','U','K','M'))

Line 1263: dba_tables dt

1259: 'MVIEW' subobject_type,
1260: 'NO' classified,
1261: NVL(dt.partitioned,'NO') partitioned
1262: FROM dba_snapshots ds,
1263: dba_tables dt
1264: WHERE ds.owner IN (select oracle_username
1265: from fnd_oracle_userid
1266: where read_only_flag IN ('E','A','U','K','M'))
1267: AND ds.owner = dt.owner

Line 1284: FROM dba_tables dt

1280: 'TABLE' object_type,
1281: 'IOT' subobject_type,
1282: 'NO' classified,
1283: NVL(dt.partitioned,'NO') partitioned
1284: FROM dba_tables dt
1285: WHERE dt.owner IN (select oracle_username
1286: from fnd_oracle_userid
1287: where read_only_flag IN ('E','A','U','K','M'))
1288: AND NVL(dt.iot_type, 'ZZZ') = 'IOT_OVERFLOW'

Line 1307: FROM dba_tables dt

1303: 'TABLE' object_type,
1304: 'AQ' subobject_type,
1305: 'NO' classified,
1306: nvl(dt.partitioned,'NO') partitioned
1307: FROM dba_tables dt
1308: WHERE dt.owner IN (select oracle_username
1309: from fnd_oracle_userid
1310: where read_only_flag IN ('E','A','U','K','M'))
1311: AND NVL(dt.iot_type, 'ZZZ') = 'IOT_OVERFLOW'

Line 1326: FROM dba_tables dt

1322: 'TABLE' object_type,
1323: 'DOMAIN' subobject_type,
1324: 'NO' classified,
1325: nvl(dt.partitioned,'NO') partitioned
1326: FROM dba_tables dt
1327: WHERE dt.owner IN (select oracle_username
1328: from fnd_oracle_userid
1329: where read_only_flag IN ('E','A','U','K','M'))
1330: AND NVL(dt.iot_type, 'ZZZ') = 'IOT_OVERFLOW'

Line 1348: dba_tables dt

1344: 'YES' classified,
1345: nvl(dt.partitioned,'NO') partitioned
1346: FROM fnd_object_tablespaces o,
1347: dba_lobs dl,
1348: dba_tables dt
1349: WHERE dt.owner IN (select oracle_username
1350: from fnd_oracle_userid
1351: where read_only_flag IN ('E','A','U','K','M'))
1352: AND dt.owner = o.oracle_username

Line 1376: dba_tables dt

1372: 'TABLE' subobject_type,
1373: 'NO' classified,
1374: nvl(dt.partitioned,'NO') partitioned
1375: FROM dba_lobs dl,
1376: dba_tables dt
1377: WHERE dt.owner IN (select oracle_username
1378: from fnd_oracle_userid
1379: where read_only_flag IN ('E','A','U','K','M'))
1380: AND dl.owner = dt.owner

Line 1425: dba_tables dt

1421: 'IOT' subobject_type,
1422: 'NO' classified,
1423: nvl(dt.partitioned,'NO') partitioned
1424: FROM dba_lobs dl,
1425: dba_tables dt
1426: WHERE dt.owner IN (select oracle_username
1427: from fnd_oracle_userid
1428: where read_only_flag IN ('E','A','U','K','M'))
1429: AND dl.owner = dt.owner

Line 1457: dba_tables dt

1453: 'MVIEW' subobject_type,
1454: 'NO' classified,
1455: nvl(dt.partitioned,'NO') partitioned
1456: FROM dba_lobs dl,
1457: dba_tables dt
1458: WHERE dt.owner IN (select oracle_username
1459: from fnd_oracle_userid
1460: where read_only_flag IN ('E','A','U','K','M'))
1461: AND dl.owner = dt.owner

Line 1483: dba_tables dt

1479: 'AQ' subobject_type,
1480: 'NO' classified,
1481: nvl(dt.partitioned,'NO') partitioned
1482: FROM dba_lobs dl,
1483: dba_tables dt
1484: WHERE dt.owner IN (select oracle_username
1485: from fnd_oracle_userid
1486: where read_only_flag IN ('E','A','U','K','M'))
1487: AND dl.owner = dt.owner

Line 1509: dba_tables dt

1505: 'DOMAIN' subobject_type,
1506: 'NO' classified,
1507: nvl(dt.partitioned,'NO') partitioned
1508: from dba_lobs dl,
1509: dba_tables dt
1510: WHERE dt.owner IN (select oracle_username
1511: from fnd_oracle_userid
1512: where read_only_flag IN ('E','A','U','K','M'))
1513: and dl.owner = dt.owner

Line 1531: dba_tables dt

1527: 'AQ' subobject_type,
1528: 'NO' classified,
1529: NVL(dt.partitioned,'NO') partitioned
1530: FROM dba_queue_tables dqt,
1531: dba_tables dt
1532: WHERE dt.owner IN (select oracle_username
1533: from fnd_oracle_userid
1534: where read_only_flag IN ('E','A','U','K','M'))
1535: AND dt.owner = dqt.owner

Line 1551: FROM dba_tables dt

1547: 'TABLE' object_type,
1548: 'AQ' subobject_type,
1549: 'NO' classified,
1550: NVL(dt.partitioned,'NO') partitioned
1551: FROM dba_tables dt
1552: WHERE dt.owner IN (select oracle_username
1553: from fnd_oracle_userid
1554: where read_only_flag IN ('E','A','U','K','M'))
1555: AND dt.table_name LIKE 'AQ$%'

Line 1569: FROM dba_tables dt

1565: 'TABLE' object_type,
1566: 'DOMAIN' subobject_type,
1567: 'NO' classified,
1568: nvl(dt.partitioned,'NO') partitioned
1569: FROM dba_tables dt
1570: WHERE dt.owner IN (select oracle_username
1571: from fnd_oracle_userid
1572: where read_only_flag IN ('E','A','U','K','M'))
1573: AND dt.table_name LIKE 'DR$%'

Line 1717: dba_tables dt

1713: 'INDEX' subobject_type,
1714: 'NO' classified,
1715: nvl(i.partitioned,'NO') partitioned
1716: FROM dba_indexes i,
1717: dba_tables dt
1718: WHERE i.table_owner IN (select oracle_username
1719: from fnd_oracle_userid
1720: where read_only_flag IN ('E','A','U','K','M'))
1721: AND i.table_owner = dt.owner

Line 1764: dba_tables dt

1760: 'INDEX' subobject_type,
1761: 'NO' classified,
1762: nvl(i.partitioned,'NO') partitioned
1763: FROM dba_indexes i,
1764: dba_tables dt
1765: WHERE i.table_owner IN (select oracle_username
1766: from fnd_oracle_userid
1767: where read_only_flag IN ('E','A','U','K','M'))
1768: AND i.table_owner = dt.owner

Line 1832: dba_tables dt

1828: 'IOT' subobject_type,
1829: 'NO' classified,
1830: nvl(i.partitioned,'NO') partitioned
1831: FROM dba_indexes i,
1832: dba_tables dt
1833: WHERE i.table_owner IN (select oracle_username
1834: from fnd_oracle_userid
1835: where read_only_flag IN ('E','A','U','K','M'))
1836: AND i.table_owner = dt.owner

Line 1864: dba_tables dt

1860: 'IOT' subobject_type,
1861: 'NO' classified,
1862: nvl(i.partitioned,'NO') partitioned
1863: FROM dba_indexes i,
1864: dba_tables dt
1865: WHERE i.table_owner IN (select oracle_username
1866: from fnd_oracle_userid
1867: where read_only_flag IN ('E','A','U','K','M'))
1868: AND i.table_owner = dt.owner