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_QUEUE_TABLES

Line 266: FROM dba_queue_tables dqt

262: and l.log_table = d.table_name)
263: AND nvl(d.iot_type,'ZZZ') NOT IN ('IOT', 'IOT_OVERFLOW')
264: AND NOT EXISTS
265: (SELECT queue_table
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

Line 434: FROM dba_queue_tables dqt

430: and l.log_table = d.table_name)
431: and dt.iot_type IS NULL
432: AND NOT EXISTS
433: (SELECT queue_table
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

Line 466: FROM dba_queue_tables dqt

462: and d.table_name = dt.table_name
463: and NVL(dt.iot_type, 'ZZZ') IN ('IOT', 'IOT_OVERFLOW')
464: AND NOT EXISTS
465: (SELECT queue_table
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

Line 521: FROM dba_queue_tables dqt

517: and dt.owner = p_app
518: and d.table_name = dt.table_name
519: AND (EXISTS
520: (SELECT queue_table
521: FROM dba_queue_tables dqt
522: WHERE dqt.owner = p_app
523: and dqt.queue_table = dt.table_name)
524: OR dt.table_name LIKE 'AQ$%')
525: and NVL(dt.temporary, 'N') = 'N'

Line 559: FROM dba_queue_tables dqt,

555: 'TABLE' object_type,
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

Line 763: FROM dba_queue_tables dqt

759: WHERE s.log_owner = p_app
760: and s.log_table = i.table_name)
761: AND NOT EXISTS
762: (SELECT queue_table
763: FROM dba_queue_tables dqt
764: WHERE dqt.owner = p_app
765: and dqt.queue_table = i.table_name)
766: AND i.index_type not in ('DOMAIN', 'IOT - TOP', 'CLUSTER','LOB')
767: AND i.table_name NOT LIKE 'AQ$%'

Line 807: FROM dba_queue_tables dqt

803: WHERE s.log_owner = p_app
804: and s.log_table = i.table_name)
805: AND NOT EXISTS
806: (SELECT queue_table
807: FROM dba_queue_tables dqt
808: WHERE dqt.owner = p_app
809: and dqt.queue_table = i.table_name)
810: AND i.index_type = 'LOB'
811: AND i.table_name NOT LIKE 'AQ$%'

Line 1014: FROM dba_queue_tables dqt

1010: FROM dba_indexes di
1011: WHERE di.table_owner = p_app
1012: AND (EXISTS
1013: (SELECT queue_table
1014: FROM dba_queue_tables dqt
1015: WHERE dqt.owner = p_app
1016: AND dqt.queue_table = di.table_name)
1017: OR di.table_name LIKE 'AQ$%')
1018: AND di.index_type not in ('DOMAIN','IOT - TOP','CLUSTER','LOB')

Line 1037: FROM dba_queue_tables dqt

1033: FROM dba_indexes di
1034: WHERE di.table_owner = p_app
1035: AND (EXISTS
1036: (SELECT queue_table
1037: FROM dba_queue_tables dqt
1038: WHERE dqt.owner = p_app
1039: AND dqt.queue_table = di.table_name)
1040: OR di.table_name LIKE 'AQ$%')
1041: AND di.index_type ='LOB'

Line 1218: FROM dba_queue_tables dqt

1214: AND l.log_table = dt.table_name)
1215: AND NVL(dt.iot_type,'ZZZ') NOT IN ('IOT', 'IOT_OVERFLOW')
1216: AND NOT EXISTS
1217: (SELECT queue_table
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

Line 1400: FROM dba_queue_tables dqt

1396: and l.log_table = dt.table_name)
1397: and dt.iot_type IS NULL
1398: AND NOT EXISTS
1399: (SELECT queue_table
1400: FROM dba_queue_tables dqt
1401: WHERE dqt.owner = dt.owner
1402: and dqt.queue_table = dt.table_name)
1403: AND NOT EXISTS
1404: (select det.table_name

Line 1434: FROM dba_queue_tables dqt

1430: AND dl.table_name = dt.table_name
1431: AND NVL(dt.iot_type, 'ZZZ') IN ('IOT', 'IOT_OVERFLOW')
1432: AND NOT EXISTS
1433: (SELECT queue_table
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

Line 1491: FROM dba_queue_tables dqt

1487: AND dl.owner = dt.owner
1488: AND dl.table_name = dt.table_name
1489: AND (EXISTS
1490: (SELECT queue_table
1491: FROM dba_queue_tables dqt
1492: WHERE dqt.owner = dt.owner
1493: and dqt.queue_table = dt.table_name)
1494: OR dt.table_name LIKE 'AQ$%')
1495: AND NVL(dt.temporary, 'N') = 'N'

Line 1530: FROM dba_queue_tables dqt,

1526: 'TABLE' object_type,
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'))

Line 1742: FROM dba_queue_tables dqt

1738: WHERE s.log_owner = i.table_owner
1739: and s.log_table = i.table_name)
1740: AND NOT EXISTS
1741: (SELECT queue_table
1742: FROM dba_queue_tables dqt
1743: WHERE dqt.owner = i.table_owner
1744: and dqt.queue_table = i.table_name)
1745: AND i.index_type not in ('DOMAIN', 'IOT - TOP', 'CLUSTER','LOB')
1746: AND i.table_name NOT LIKE 'AQ$%'

Line 1789: FROM dba_queue_tables dqt

1785: WHERE s.log_owner = i.table_owner
1786: and s.log_table = i.table_name)
1787: AND NOT EXISTS
1788: (SELECT queue_table
1789: FROM dba_queue_tables dqt
1790: WHERE dqt.owner = i.table_owner
1791: and dqt.queue_table = i.table_name)
1792: AND i.index_type ='LOB'
1793: AND i.table_name NOT LIKE 'AQ$%'

Line 2013: FROM dba_queue_tables dqt

2009: from fnd_oracle_userid
2010: where read_only_flag IN ('E','A','U','K','M'))
2011: AND (EXISTS
2012: (SELECT queue_table
2013: FROM dba_queue_tables dqt
2014: WHERE dqt.owner = di.table_owner
2015: AND dqt.queue_table = di.table_name)
2016: OR di.table_name LIKE 'AQ$%')
2017: AND di.index_type not in ('DOMAIN','IOT - TOP','CLUSTER','LOB')

Line 2039: FROM dba_queue_tables dqt

2035: from fnd_oracle_userid
2036: where read_only_flag IN ('E','A','U','K','M'))
2037: AND (EXISTS
2038: (SELECT queue_table
2039: FROM dba_queue_tables dqt
2040: WHERE dqt.owner = di.table_owner
2041: AND dqt.queue_table = di.table_name)
2042: OR di.table_name LIKE 'AQ$%')
2043: AND di.index_type ='LOB'