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 FND_OBJECT_TABLESPACES

Line 218: FROM fnd_object_tablespaces o,

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

Line 250: FROM fnd_object_tablespaces o

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
251: WHERE o.oracle_username = p_app
252: and o.object_name = d.table_name)
253: AND NOT EXISTS
254: (SELECT table_name

Line 381: from fnd_object_tablespaces o,

377: 'LOB' object_type,
378: 'TABLE' subobject_type,
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

Line 418: FROM fnd_object_tablespaces o

414: and dt.owner = p_app
415: and d.table_name = dt.table_name
416: AND NOT EXISTS
417: (SELECT object_name
418: FROM fnd_object_tablespaces o
419: WHERE o.oracle_username = p_app
420: and o.object_name = dt.table_name)
421: AND NOT EXISTS
422: (SELECT table_name

Line 700: from fnd_object_tablespaces o,

696: 'INDEX' object_type,
697: 'INDEX' subobject_type,
698: 'YES' classified,
699: nvl(i.partitioned,'NO') partitioned
700: from fnd_object_tablespaces o,
701: dba_indexes i
702: where i.table_owner = p_app
703: and o.oracle_username = i.table_owner
704: and o.object_name = i.table_name

Line 719: from fnd_object_tablespaces o,

715: 'INDEX' object_type,
716: 'INDEX' subobject_type,
717: 'YES' classified,
718: nvl(i.partitioned,'NO') partitioned
719: from fnd_object_tablespaces o,
720: dba_indexes i
721: where i.table_owner = p_app
722: and o.oracle_username = i.table_owner
723: and o.object_name = i.table_name

Line 748: FROM fnd_object_tablespaces o

744: AND NVL(dt.iot_type, 'ZZZ') NOT IN ('IOT', 'IOT_OVERFLOW')
745: AND NVL(dt.temporary, 'N') = 'N'
746: AND NOT EXISTS
747: (SELECT object_name
748: FROM fnd_object_tablespaces o
749: WHERE o.oracle_username = p_app
750: and o.object_name = i.table_name)
751: AND NOT EXISTS
752: (SELECT table_name

Line 792: FROM fnd_object_tablespaces o

788: AND NVL(dt.iot_type, 'ZZZ') NOT IN ('IOT', 'IOT_OVERFLOW')
789: AND NVL(dt.temporary, 'N') = 'N'
790: AND NOT EXISTS
791: (SELECT object_name
792: FROM fnd_object_tablespaces o
793: WHERE o.oracle_username = p_app
794: and o.object_name = i.table_name)
795: AND NOT EXISTS
796: (SELECT table_name

Line 1167: FROM fnd_object_tablespaces fot,

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

Line 1202: FROM fnd_object_tablespaces o

1198: from fnd_oracle_userid
1199: where read_only_flag IN ('E','A','U','K','M'))
1200: AND NOT EXISTS
1201: (SELECT object_name
1202: FROM fnd_object_tablespaces o
1203: WHERE o.oracle_username = dt.owner
1204: AND o.object_name = dt.table_name)
1205: AND NOT EXISTS
1206: (SELECT table_name

Line 1346: FROM fnd_object_tablespaces o,

1342: 'LOB' object_type,
1343: 'TABLE' subobject_type,
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

Line 1384: FROM fnd_object_tablespaces o

1380: AND dl.owner = dt.owner
1381: AND dl.table_name = dt.table_name
1382: AND NOT EXISTS
1383: (SELECT object_name
1384: FROM fnd_object_tablespaces o
1385: WHERE o.oracle_username = dt.owner
1386: and o.object_name = dt.table_name)
1387: AND NOT EXISTS
1388: (SELECT table_name

Line 1671: FROM fnd_object_tablespaces o,

1667: 'INDEX' object_type,
1668: 'INDEX' subobject_type,
1669: 'YES' classified,
1670: nvl(i.partitioned,'NO') partitioned
1671: FROM fnd_object_tablespaces o,
1672: dba_indexes i
1673: WHERE i.table_owner IN (select oracle_username
1674: from fnd_oracle_userid
1675: where read_only_flag IN ('E','A','U','K','M'))

Line 1693: FROM fnd_object_tablespaces o,

1689: 'INDEX' object_type,
1690: 'INDEX' subobject_type,
1691: 'YES' classified,
1692: nvl(i.partitioned,'NO') partitioned
1693: FROM fnd_object_tablespaces o,
1694: dba_indexes i
1695: WHERE i.table_owner IN (select oracle_username
1696: from fnd_oracle_userid
1697: where read_only_flag IN ('E','A','U','K','M'))

Line 1727: FROM fnd_object_tablespaces o

1723: AND NVL(dt.iot_type, 'ZZZ') NOT IN ('IOT', 'IOT_OVERFLOW')
1724: AND NVL(dt.temporary, 'N') = 'N'
1725: AND NOT EXISTS
1726: (SELECT object_name
1727: FROM fnd_object_tablespaces o
1728: WHERE o.oracle_username = i.table_owner
1729: and o.object_name = i.table_name)
1730: AND NOT EXISTS
1731: (SELECT table_name

Line 1774: FROM fnd_object_tablespaces o

1770: AND NVL(dt.iot_type, 'ZZZ') NOT IN ('IOT', 'IOT_OVERFLOW')
1771: AND NVL(dt.temporary, 'N') = 'N'
1772: AND NOT EXISTS
1773: (SELECT object_name
1774: FROM fnd_object_tablespaces o
1775: WHERE o.oracle_username = i.table_owner
1776: and o.object_name = i.table_name)
1777: AND NOT EXISTS
1778: (SELECT table_name