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_SNAPSHOTS

Line 255: FROM DBA_SNAPSHOTS s

251: WHERE o.oracle_username = p_app
252: and o.object_name = d.table_name)
253: AND NOT EXISTS
254: (SELECT table_name
255: FROM DBA_SNAPSHOTS s
256: where s.owner = p_app
257: and s.table_name = d.table_name)
258: AND NOT EXISTS
259: (SELECT log_table

Line 307: FROM dba_snapshots d,

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

Line 423: FROM dba_snapshots s

419: WHERE o.oracle_username = p_app
420: and o.object_name = dt.table_name)
421: AND NOT EXISTS
422: (SELECT table_name
423: FROM dba_snapshots s
424: WHERE s.owner = p_app
425: and s.table_name = dt.table_name)
426: AND NOT EXISTS
427: (SELECT log_table

Line 496: FROM dba_snapshots s

492: and dt.owner = p_app
493: and d.table_name = dt.table_name
494: AND EXISTS
495: (SELECT table_name
496: FROM dba_snapshots s
497: WHERE s.owner = p_app
498: and s.table_name = d.table_name)
499: and NVL(dt.temporary, 'N') = 'N'
500: AND dt.table_name NOT LIKE 'BIN$%'

Line 753: FROM dba_snapshots s

749: WHERE o.oracle_username = p_app
750: and o.object_name = i.table_name)
751: AND NOT EXISTS
752: (SELECT table_name
753: FROM dba_snapshots s
754: WHERE s.owner = p_app
755: and s.table_name = i.table_name)
756: AND NOT EXISTS
757: (SELECT log_table

Line 797: FROM dba_snapshots s

793: WHERE o.oracle_username = p_app
794: and o.object_name = i.table_name)
795: AND NOT EXISTS
796: (SELECT table_name
797: FROM dba_snapshots s
798: WHERE s.owner = p_app
799: and s.table_name = i.table_name)
800: AND NOT EXISTS
801: (SELECT log_table

Line 858: FROM dba_snapshots s

854: AND NVL(dt.iot_type, 'ZZZ') IN ('IOT', 'IOT_OVERFLOW')
855: AND NVL(dt.temporary, 'N') = 'N'
856: AND NOT EXISTS
857: (SELECT table_name
858: FROM dba_snapshots s
859: WHERE s.owner = p_app
860: AND s.table_name = i.table_name)
861: AND i.table_name NOT LIKE 'AQ$%'
862: AND i.table_name NOT LIKE 'DR$%'

Line 887: FROM dba_snapshots s

883: AND NVL(dt.iot_type, 'ZZZ') IN ('IOT', 'IOT_OVERFLOW')
884: AND NVL(dt.temporary, 'N') = 'N'
885: AND NOT EXISTS
886: (SELECT table_name
887: FROM dba_snapshots s
888: WHERE s.owner = p_app
889: AND s.table_name = i.table_name)
890: AND i.table_name NOT LIKE 'AQ$%'
891: AND i.table_name NOT LIKE 'DR$%'

Line 910: FROM dba_snapshots s

906: from dba_indexes i
907: where i.table_owner = p_app
908: AND EXISTS
909: (SELECT table_name
910: FROM dba_snapshots s
911: WHERE s.owner = p_app
912: and s.table_name = i.table_name)
913: AND i.index_type not in ('DOMAIN','IOT - TOP','CLUSTER','LOB')
914: AND NVL(i.temporary, 'N') = 'N'

Line 931: FROM dba_snapshots s

927: from dba_indexes i
928: where i.table_owner = p_app
929: AND EXISTS
930: (SELECT table_name
931: FROM dba_snapshots s
932: WHERE s.owner = p_app
933: and s.table_name = i.table_name)
934: AND i.index_type ='LOB'
935: AND NVL(i.temporary, 'N') = 'N'

Line 1207: FROM dba_snapshots s

1203: WHERE o.oracle_username = dt.owner
1204: AND o.object_name = dt.table_name)
1205: AND NOT EXISTS
1206: (SELECT table_name
1207: FROM dba_snapshots s
1208: WHERE s.owner = dt.owner
1209: AND s.table_name = dt.table_name)
1210: AND NOT EXISTS
1211: (SELECT log_table

Line 1262: FROM dba_snapshots ds,

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

Line 1389: FROM dba_snapshots s

1385: WHERE o.oracle_username = dt.owner
1386: and o.object_name = dt.table_name)
1387: AND NOT EXISTS
1388: (SELECT table_name
1389: FROM dba_snapshots s
1390: WHERE s.owner = dt.owner
1391: and s.table_name = dt.table_name)
1392: AND NOT EXISTS
1393: (SELECT log_table

Line 1465: FROM dba_snapshots s

1461: AND dl.owner = dt.owner
1462: AND dl.table_name = dt.table_name
1463: AND EXISTS
1464: (SELECT table_name
1465: FROM dba_snapshots s
1466: WHERE s.owner = dt.owner
1467: and s.table_name = dt.table_name)
1468: AND NVL(dt.temporary, 'N') = 'N'
1469: AND dt.table_name NOT LIKE 'BIN$%'

Line 1732: FROM dba_snapshots s

1728: WHERE o.oracle_username = i.table_owner
1729: and o.object_name = i.table_name)
1730: AND NOT EXISTS
1731: (SELECT table_name
1732: FROM dba_snapshots s
1733: WHERE s.owner = i.table_owner
1734: and s.table_name = i.table_name)
1735: AND NOT EXISTS
1736: (SELECT log_table

Line 1779: FROM dba_snapshots s

1775: WHERE o.oracle_username = i.table_owner
1776: and o.object_name = i.table_name)
1777: AND NOT EXISTS
1778: (SELECT table_name
1779: FROM dba_snapshots s
1780: WHERE s.owner = i.table_owner
1781: and s.table_name = i.table_name)
1782: AND NOT EXISTS
1783: (SELECT log_table

Line 1842: FROM dba_snapshots s

1838: AND NVL(dt.iot_type, 'ZZZ') IN ('IOT', 'IOT_OVERFLOW')
1839: AND NVL(dt.temporary, 'N') = 'N'
1840: AND NOT EXISTS
1841: (SELECT table_name
1842: FROM dba_snapshots s
1843: WHERE s.owner = i.table_owner
1844: and s.table_name = i.table_name)
1845: AND i.table_name NOT LIKE 'AQ$%'
1846: AND i.table_name NOT LIKE 'DR$%'

Line 1874: FROM dba_snapshots s

1870: AND NVL(dt.iot_type, 'ZZZ') IN ('IOT', 'IOT_OVERFLOW')
1871: AND NVL(dt.temporary, 'N') = 'N'
1872: AND NOT EXISTS
1873: (SELECT table_name
1874: FROM dba_snapshots s
1875: WHERE s.owner = i.table_owner
1876: and s.table_name = i.table_name)
1877: AND i.table_name NOT LIKE 'AQ$%'
1878: AND i.table_name NOT LIKE 'DR$%'

Line 1899: FROM dba_snapshots s

1895: from fnd_oracle_userid
1896: where read_only_flag IN ('E','A','U','K','M'))
1897: AND EXISTS
1898: (SELECT table_name
1899: FROM dba_snapshots s
1900: WHERE s.owner = i.table_owner
1901: and s.table_name = i.table_name)
1902: AND i.index_type not in ('DOMAIN','IOT - TOP','CLUSTER','LOB')
1903: AND NVL(i.temporary, 'N') = 'N'

Line 1922: FROM dba_snapshots s

1918: from fnd_oracle_userid
1919: where read_only_flag IN ('E','A','U','K','M'))
1920: AND EXISTS
1921: (SELECT table_name
1922: FROM dba_snapshots s
1923: WHERE s.owner = i.table_owner
1924: and s.table_name = i.table_name)
1925: AND i.index_type = 'LOB'
1926: AND NVL(i.temporary, 'N') = 'N'