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_INDEXES

Line 701: dba_indexes i

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
705: and i.index_type not in ('DOMAIN','IOT - TOP','CLUSTER','LOB')

Line 720: dba_indexes i

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
724: and i.index_type ='LOB'

Line 739: FROM dba_indexes i,

735: 'INDEX' object_type,
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

Line 783: FROM dba_indexes i,

779: 'INDEX' object_type,
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

Line 830: FROM dba_indexes d

826: 'INDEX' object_type,
827: 'IOT' subobject_type,
828: 'NO' classified,
829: nvl(d.partitioned,'NO') partitioned
830: FROM dba_indexes d
831: WHERE d.table_owner = p_app
832: AND d.index_type = 'IOT - TOP'
833: AND d.table_name NOT LIKE 'AQ$%'
834: AND d.table_name NOT LIKE 'DR$%'

Line 849: FROM dba_indexes i,

845: 'INDEX' object_type,
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

Line 878: FROM dba_indexes i,

874: 'INDEX' object_type,
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

Line 906: from dba_indexes i

902: 'INDEX' object_type,
903: 'MVIEW' subobject_type,
904: 'NO' classified,
905: nvl(i.partitioned,'NO') partitioned
906: from dba_indexes i
907: where i.table_owner = p_app
908: AND EXISTS
909: (SELECT table_name
910: FROM dba_snapshots s

Line 927: from dba_indexes i

923: 'INDEX' object_type,
924: 'MVIEW' subobject_type,
925: 'NO' classified,
926: nvl(i.partitioned,'NO') partitioned
927: from dba_indexes i
928: where i.table_owner = p_app
929: AND EXISTS
930: (SELECT table_name
931: FROM dba_snapshots s

Line 949: from dba_indexes i

945: 'INDEX' object_type,
946: 'MV_LOG' subobject_type,
947: 'NO' classified,
948: nvl(i.partitioned,'NO') partitioned
949: from dba_indexes i
950: where i.table_owner = p_app
951: AND EXISTS
952: (SELECT table_name
953: FROM dba_snapshot_logs s

Line 970: from dba_indexes i

966: 'INDEX' object_type,
967: 'MV_LOG' subobject_type,
968: 'NO' classified,
969: nvl(i.partitioned,'NO') partitioned
970: from dba_indexes i
971: where i.table_owner = p_app
972: AND EXISTS
973: (SELECT table_name
974: FROM dba_snapshot_logs s

Line 992: FROM dba_indexes d

988: 'INDEX' object_type,
989: 'AQ' subobject_type,
990: 'NO' classified,
991: nvl(d.partitioned,'NO') partitioned
992: FROM dba_indexes d
993: WHERE d.table_owner = p_app
994: AND d.index_type = 'IOT - TOP'
995: AND d.table_name LIKE 'AQ$%'
996: AND NVL(d.temporary, 'N') = 'N'

Line 1010: FROM dba_indexes di

1006: 'INDEX' object_type,
1007: 'AQ' subobject_type,
1008: 'NO' classified,
1009: nvl(di.partitioned,'NO') partitioned
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

Line 1033: FROM dba_indexes di

1029: 'INDEX' object_type,
1030: 'AQ' subobject_type,
1031: 'NO' classified,
1032: nvl(di.partitioned,'NO') partitioned
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

Line 1056: FROM dba_indexes d

1052: 'INDEX' object_type,
1053: 'DOMAIN' subobject_type,
1054: 'NO' classified,
1055: nvl(d.partitioned,'NO') partitioned
1056: FROM dba_indexes d
1057: WHERE d.table_owner = p_app
1058: AND d.index_type = 'IOT - TOP'
1059: AND d.table_name LIKE 'DR$%'
1060: AND NVL(d.temporary, 'N') = 'N'

Line 1073: FROM dba_indexes di

1069: 'INDEX' object_type,
1070: 'DOMAIN' subobject_type,
1071: 'NO' classified,
1072: nvl(di.partitioned,'NO') partitioned
1073: FROM dba_indexes di
1074: WHERE di.table_owner = p_app
1075: AND di.table_name LIKE 'DR$%'
1076: AND di.index_type not in ('DOMAIN','IOT - TOP','CLUSTER','LOB')
1077: AND NVL(di.temporary, 'N') = 'N'

Line 1091: FROM dba_indexes di

1087: 'INDEX' object_type,
1088: 'DOMAIN' subobject_type,
1089: 'NO' classified,
1090: nvl(di.partitioned,'NO') partitioned
1091: FROM dba_indexes di
1092: WHERE di.table_owner = p_app
1093: AND di.table_name LIKE 'DR$%'
1094: AND di.index_type ='LOB'
1095: AND di.index_name NOT LIKE 'BIN$%'

Line 1672: dba_indexes i

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'))
1676: AND o.oracle_username = i.table_owner

Line 1694: dba_indexes i

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'))
1698: AND o.oracle_username = i.table_owner

Line 1716: FROM dba_indexes i,

1712: 'INDEX' object_type,
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'))

Line 1763: FROM dba_indexes i,

1759: 'INDEX' object_type,
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'))

Line 1810: FROM dba_indexes d

1806: 'INDEX' object_type,
1807: 'IOT' subobject_type,
1808: 'NO' classified,
1809: nvl(d.partitioned,'NO') partitioned
1810: FROM dba_indexes d
1811: WHERE d.table_owner IN (select oracle_username
1812: from fnd_oracle_userid
1813: where read_only_flag IN ('E','A','U','K','M'))
1814: AND d.index_type = 'IOT - TOP'

Line 1831: FROM dba_indexes i,

1827: 'INDEX' object_type,
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'))

Line 1863: FROM dba_indexes i,

1859: 'INDEX' object_type,
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'))

Line 1893: from dba_indexes i

1889: 'INDEX' object_type,
1890: 'MVIEW' subobject_type,
1891: 'NO' classified,
1892: nvl(i.partitioned,'NO') partitioned
1893: from dba_indexes i
1894: WHERE i.table_owner IN (select oracle_username
1895: from fnd_oracle_userid
1896: where read_only_flag IN ('E','A','U','K','M'))
1897: AND EXISTS

Line 1916: from dba_indexes i

1912: 'INDEX' object_type,
1913: 'MVIEW' subobject_type,
1914: 'NO' classified,
1915: nvl(i.partitioned,'NO') partitioned
1916: from dba_indexes i
1917: WHERE i.table_owner IN (select oracle_username
1918: from fnd_oracle_userid
1919: where read_only_flag IN ('E','A','U','K','M'))
1920: AND EXISTS

Line 1940: from dba_indexes i

1936: 'INDEX' object_type,
1937: 'MV_LOG' subobject_type,
1938: 'NO' classified,
1939: nvl(i.partitioned,'NO') partitioned
1940: from dba_indexes i
1941: WHERE i.table_owner IN (select oracle_username
1942: from fnd_oracle_userid
1943: where read_only_flag IN ('E','A','U','K','M'))
1944: AND EXISTS

Line 1964: from dba_indexes i

1960: 'INDEX' object_type,
1961: 'MV_LOG' subobject_type,
1962: 'NO' classified,
1963: nvl(i.partitioned,'NO') partitioned
1964: from dba_indexes i
1965: WHERE i.table_owner IN (select oracle_username
1966: from fnd_oracle_userid
1967: where read_only_flag IN ('E','A','U','K','M'))
1968: AND EXISTS

Line 1988: FROM dba_indexes d

1984: 'INDEX' object_type,
1985: 'AQ' subobject_type,
1986: 'NO' classified,
1987: nvl(d.partitioned,'NO') partitioned
1988: FROM dba_indexes d
1989: WHERE d.table_owner IN (select oracle_username
1990: from fnd_oracle_userid
1991: where read_only_flag IN ('E','A','U','K','M'))
1992: AND d.index_type = 'IOT - TOP'

Line 2007: FROM dba_indexes di

2003: 'INDEX' object_type,
2004: 'AQ' subobject_type,
2005: 'NO' classified,
2006: nvl(di.partitioned,'NO') partitioned
2007: FROM dba_indexes di
2008: WHERE di.table_owner IN (select oracle_username
2009: from fnd_oracle_userid
2010: where read_only_flag IN ('E','A','U','K','M'))
2011: AND (EXISTS

Line 2033: FROM dba_indexes di

2029: 'INDEX' object_type,
2030: 'AQ' subobject_type,
2031: 'NO' classified,
2032: nvl(di.partitioned,'NO') partitioned
2033: FROM dba_indexes di
2034: WHERE di.table_owner IN (select oracle_username
2035: from fnd_oracle_userid
2036: where read_only_flag IN ('E','A','U','K','M'))
2037: AND (EXISTS

Line 2057: FROM dba_indexes d

2053: 'INDEX' object_type,
2054: 'DOMAIN' subobject_type,
2055: 'NO' classified,
2056: nvl(d.partitioned,'NO') partitioned
2057: FROM dba_indexes d
2058: WHERE d.table_owner IN (select oracle_username
2059: from fnd_oracle_userid
2060: where read_only_flag IN ('E','A','U','K','M'))
2061: AND d.index_type = 'IOT - TOP'

Line 2076: FROM dba_indexes di

2072: 'INDEX' object_type,
2073: 'DOMAIN' subobject_type,
2074: 'NO' classified,
2075: nvl(di.partitioned,'NO') partitioned
2076: FROM dba_indexes di
2077: WHERE di.table_owner IN (select oracle_username
2078: from fnd_oracle_userid
2079: where read_only_flag IN ('E','A','U','K','M'))
2080: AND di.table_name LIKE 'DR$%'

Line 2095: FROM dba_indexes di

2091: 'INDEX' object_type,
2092: 'DOMAIN' subobject_type,
2093: 'NO' classified,
2094: nvl(di.partitioned,'NO') partitioned
2095: FROM dba_indexes di
2096: WHERE di.table_owner IN (select oracle_username
2097: from fnd_oracle_userid
2098: where read_only_flag IN ('E','A','U','K','M'))
2099: AND di.table_name LIKE 'DR$%'