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_ORACLE_USERID

Line 1170: from fnd_oracle_userid

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
1173: AND fot.object_name = dt.table_name
1174: AND fot.object_type = 'TABLE'

Line 1198: from fnd_oracle_userid

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
1201: (SELECT object_name
1202: FROM fnd_object_tablespaces o

Line 1245: from fnd_oracle_userid

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'))
1247: AND dsl.log_owner = dt.owner
1248: AND dsl.log_table = dt.table_name
1249: AND NVL(dt.temporary, 'N') = 'N'

Line 1265: from fnd_oracle_userid

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
1268: AND dt.table_name = ds.table_name
1269: AND NVL(dt.temporary, 'N') = 'N'

Line 1286: from fnd_oracle_userid

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'
1289: AND NVL(dt.iot_name, 'ZZZ') NOT LIKE 'AQ$%'
1290: AND NVL(dt.iot_name, 'ZZZ') NOT LIKE 'DR$%'

Line 1309: from fnd_oracle_userid

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'
1312: AND NVL(dt.iot_name, 'ZZZ') LIKE 'AQ$%'
1313: AND NVL(dt.temporary, 'N') = 'N'

Line 1328: from fnd_oracle_userid

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'
1331: AND (NVL(dt.iot_name, 'ZZZ') LIKE 'DR$%'
1332: OR NVL(dt.iot_name, 'ZZZ') LIKE 'MDRT%$')

Line 1350: from fnd_oracle_userid

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
1353: AND o.object_name = dl.table_name
1354: AND o.object_type = 'TABLE'

Line 1378: from fnd_oracle_userid

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
1381: AND dl.table_name = dt.table_name
1382: AND NOT EXISTS

Line 1427: from fnd_oracle_userid

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

Line 1459: from fnd_oracle_userid

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
1462: AND dl.table_name = dt.table_name
1463: AND EXISTS

Line 1485: from fnd_oracle_userid

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
1488: AND dl.table_name = dt.table_name
1489: AND (EXISTS

Line 1511: from fnd_oracle_userid

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
1514: and dl.table_name = dt.table_name
1515: AND dt.table_name LIKE 'DR$%'

Line 1533: from fnd_oracle_userid

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
1536: AND dt.table_name = dqt.queue_table
1537: AND NVL(dt.temporary, 'N') = 'N'

Line 1553: from fnd_oracle_userid

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$%'
1556: AND dt.iot_type IS NULL
1557: AND NVL(dt.temporary, 'N') = 'N'

Line 1571: from fnd_oracle_userid

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$%'
1574: AND dt.iot_type IS NULL
1575: AND NVL(dt.temporary, 'N') = 'N';

Line 1674: from fnd_oracle_userid

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
1677: AND o.object_name = i.table_name
1678: AND o.object_type = 'TABLE'

Line 1696: from fnd_oracle_userid

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
1699: AND o.object_name = i.table_name
1700: AND o.object_type = 'TABLE'

Line 1719: from fnd_oracle_userid

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
1722: AND i.table_name = dt.table_name
1723: AND NVL(dt.iot_type, 'ZZZ') NOT IN ('IOT', 'IOT_OVERFLOW')

Line 1766: from fnd_oracle_userid

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
1769: AND i.table_name = dt.table_name
1770: AND NVL(dt.iot_type, 'ZZZ') NOT IN ('IOT', 'IOT_OVERFLOW')

Line 1812: from fnd_oracle_userid

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'
1815: AND d.table_name NOT LIKE 'AQ$%'
1816: AND d.table_name NOT LIKE 'DR$%'

Line 1834: from fnd_oracle_userid

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
1837: AND i.table_name = dt.table_name
1838: AND NVL(dt.iot_type, 'ZZZ') IN ('IOT', 'IOT_OVERFLOW')

Line 1866: from fnd_oracle_userid

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
1869: AND i.table_name = dt.table_name
1870: AND NVL(dt.iot_type, 'ZZZ') IN ('IOT', 'IOT_OVERFLOW')

Line 1895: from fnd_oracle_userid

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
1898: (SELECT table_name
1899: FROM dba_snapshots s

Line 1918: from fnd_oracle_userid

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
1921: (SELECT table_name
1922: FROM dba_snapshots s

Line 1942: from fnd_oracle_userid

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
1945: (SELECT table_name
1946: FROM dba_snapshot_logs s

Line 1966: from fnd_oracle_userid

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
1969: (SELECT table_name
1970: FROM dba_snapshot_logs s

Line 1990: from fnd_oracle_userid

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'
1993: AND d.table_name LIKE 'AQ$%'
1994: AND NVL(d.temporary, 'N') = 'N'

Line 2009: from fnd_oracle_userid

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
2012: (SELECT queue_table
2013: FROM dba_queue_tables dqt

Line 2035: from fnd_oracle_userid

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
2038: (SELECT queue_table
2039: FROM dba_queue_tables dqt

Line 2059: from fnd_oracle_userid

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'
2062: AND d.table_name LIKE 'DR$%'
2063: AND NVL(d.temporary, 'N') = 'N'

Line 2078: from fnd_oracle_userid

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$%'
2081: AND di.index_type not in ('DOMAIN','IOT - TOP','CLUSTER','LOB')
2082: AND NVL(di.temporary, 'N') = 'N'

Line 2097: from fnd_oracle_userid

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$%'
2100: AND di.index_type ='LOB'
2101: AND NVL(di.temporary, 'N') = 'N';