APPS.FND_STATS dependencies on DBA_TAB_STATISTICS

Line 965: FROM dba_tab_statistics dts

961: AND de.owner =dt.owner
962: )-- added this to avoid externale tables being selected
963: AND NOT EXISTS
964: ( SELECT NULL
965: FROM dba_tab_statistics dts
966: WHERE dts.stattype_locked IS NOT NULL
967: AND dts.table_name=dt.table_name
968: AND dts.owner =dt.owner
969: ); -- added by saleem to avoid locked objects

Line 1011: FROM dba_tab_statistics dts

1007: AND de.owner =dt.owner
1008: ) -- added this to avoid externale tables being selected
1009: AND NOT EXISTS
1010: ( SELECT NULL
1011: FROM dba_tab_statistics dts
1012: WHERE dts.stattype_locked IS NOT NULL
1013: AND dts.table_name=dt.table_name
1014: AND dts.owner =dt.owner
1015: )

Line 1043: FROM dba_tab_statistics

1039: $ELSE
1040: CURSOR lock_stats_tab(schemaname VARCHAR2)
1041: IS -- cursor added by saleem to display the warning message for tables with locked stats
1042: SELECT table_name
1043: FROM dba_tab_statistics
1044: WHERE stattype_locked IS NOT NULL
1045: AND owner=upper(schemaname); -- added to display the warning for locked stats
1046: $END
1047: BEGIN

Line 1395: FROM dba_tab_statistics dts

1391: AND dt.table_name = fets.table_name
1392: ) -- added by saleem for bug 7479909
1393: AND NOT EXISTS
1394: ( SELECT NULL
1395: FROM dba_tab_statistics dts
1396: WHERE dts.stattype_locked IS NOT NULL
1397: AND dts.table_name=dt.table_name
1398: AND dts.owner =dt.owner
1399: )

Line 1496: FROM dba_tab_statistics dts

1492: > (modpercent*NVL(dt.num_rows,0))/100
1493: )
1494: AND NOT EXISTS
1495: ( SELECT NULL
1496: FROM dba_tab_statistics dts
1497: WHERE dts.stattype_locked IS NOT NULL
1498: AND dts.table_name=dtm.table_name
1499: AND dts.owner =dtm.table_owner
1500: )

Line 1526: FROM dba_tab_statistics dts

1522: > (modpercent*NVL(dtp.num_rows,0))/100
1523: )
1524: AND NOT EXISTS
1525: ( SELECT NULL
1526: FROM dba_tab_statistics dts
1527: WHERE dts.stattype_locked IS NOT NULL
1528: AND dts.table_name=dtm.table_name
1529: AND dts.owner =dtm.table_owner
1530: )

Line 1872: FROM dba_tab_statistics dts

1868: AND de.owner =dt.owner
1869: )-- added this to avoid externale tables being selected
1870: AND NOT EXISTS
1871: ( SELECT NULL
1872: FROM dba_tab_statistics dts
1873: WHERE dts.stattype_locked IS NOT NULL
1874: AND dts.table_name=dt.table_name
1875: AND dts.owner =dt.owner
1876: ); -- added by saleem to avoid locked objects

Line 1918: FROM dba_tab_statistics dts

1914: AND de.owner =dt.owner
1915: ) -- added this to avoid externale tables being selected
1916: AND NOT EXISTS
1917: ( SELECT NULL
1918: FROM dba_tab_statistics dts
1919: WHERE dts.stattype_locked IS NOT NULL
1920: AND dts.table_name=dt.table_name
1921: AND dts.owner =dt.owner
1922: )

Line 1949: FROM dba_tab_statistics

1945: $ELSE
1946: CURSOR lock_stats_tab(schemaname VARCHAR2)
1947: IS -- cursor added by saleem to display the warning message for tables with locked stats
1948: SELECT table_name
1949: FROM dba_tab_statistics
1950: WHERE stattype_locked IS NOT NULL
1951: AND owner=upper(schemaname); -- added to display the warning for locked stats
1952: $END
1953: BEGIN

Line 2280: FROM dba_tab_statistics dts

2276: AND dt.table_name = fets.table_name
2277: )
2278: AND NOT EXISTS
2279: ( SELECT NULL
2280: FROM dba_tab_statistics dts
2281: WHERE dts.stattype_locked IS NOT NULL
2282: AND dts.table_name=dt.table_name
2283: AND dts.owner =dt.owner
2284: )

Line 2381: FROM dba_tab_statistics dts

2377: > (mod_percent*NVL(dt.num_rows,0))/100
2378: )
2379: AND NOT EXISTS
2380: ( SELECT NULL
2381: FROM dba_tab_statistics dts
2382: WHERE dts.stattype_locked IS NOT NULL
2383: AND dts.table_name=dtm.table_name
2384: AND dts.owner =dtm.table_owner
2385: )

Line 2409: FROM dba_tab_statistics dts

2405: > (mod_percent*NVL(dtp.num_rows,0))/100
2406: )
2407: AND NOT EXISTS
2408: ( SELECT NULL
2409: FROM dba_tab_statistics dts
2410: WHERE dts.stattype_locked IS NOT NULL
2411: AND dts.table_name=dtm.table_name
2412: AND dts.owner =dtm.table_owner
2413: )