APPS.FND_STATS dependencies on FND_EXCLUDE_TABLE_STATS

Line 885: FROM fnd_exclude_table_stats fets,

881: AND table_name not like 'DR#%' -- added for Bug 8452962
882: -- leave alone if excluded table
883: AND NOT EXISTS
884: (SELECT NULL
885: FROM fnd_exclude_table_stats fets,
886: fnd_oracle_userid fou ,
887: fnd_product_installations fpi
888: WHERE fou.oracle_username=upper(schemaname)
889: AND fou.oracle_id =fpi.oracle_id

Line 995: FROM fnd_exclude_table_stats fets,

991: AND table_name not like 'DR#%' -- added for Bug 8452962
992: -- leave alone if excluded table
993: AND NOT EXISTS
994: (SELECT NULL
995: FROM fnd_exclude_table_stats fets,
996: fnd_oracle_userid fou ,
997: fnd_product_installations fpi
998: WHERE fou.oracle_username=upper(schemaname)
999: AND fou.oracle_id =fpi.oracle_id

Line 1112: FROM fnd_exclude_table_stats fets,

1108: AND LAST_GATHER_END_TIME IS NOT NULL
1109: )
1110: AND NOT EXISTS
1111: (SELECT NULL
1112: FROM fnd_exclude_table_stats fets,
1113: fnd_oracle_userid fou ,
1114: fnd_product_installations fpi
1115: WHERE fou.oracle_username=upper(schemaname)
1116: AND fou.oracle_id =fpi.oracle_id

Line 1385: FROM fnd_exclude_table_stats fets,

1381: AND LAST_GATHER_END_TIME IS NOT NULL
1382: )
1383: AND NOT EXISTS
1384: (SELECT NULL
1385: FROM fnd_exclude_table_stats fets,
1386: fnd_oracle_userid fou ,
1387: fnd_product_installations fpi
1388: WHERE fou.oracle_username=upper(schemaname)
1389: AND fou.oracle_id =fpi.oracle_id

Line 1781: FROM fnd_exclude_table_stats fets,

1777: AND table_name not like 'DR#%' -- added for Bug 8452962
1778: -- leave alone if excluded table
1779: AND NOT EXISTS
1780: (SELECT NULL
1781: FROM fnd_exclude_table_stats fets,
1782: fnd_oracle_userid fou ,
1783: fnd_product_installations fpi
1784: WHERE fou.oracle_username=upper(schemaname)
1785: AND fou.oracle_id =fpi.oracle_id

Line 1813: FROM fnd_exclude_table_stats fets,

1809: AND di.generated <> 'Y' -- change done by saleem for bug 9542112
1810: AND di.last_analyzed IS NULL
1811: AND NOT EXISTS
1812: (SELECT NULL
1813: FROM fnd_exclude_table_stats fets,
1814: fnd_oracle_userid fou ,
1815: fnd_product_installations fpi
1816: WHERE fou.oracle_username=upper(schemaname)
1817: AND fou.oracle_id =fpi.oracle_id

Line 1902: FROM fnd_exclude_table_stats fets,

1898: AND table_name not like 'DR#%' -- added for Bug 8452962
1899: -- leave alone if excluded table
1900: AND NOT EXISTS
1901: (SELECT NULL
1902: FROM fnd_exclude_table_stats fets,
1903: fnd_oracle_userid fou ,
1904: fnd_product_installations fpi
1905: WHERE fou.oracle_username=upper(schemaname)
1906: AND fou.oracle_id =fpi.oracle_id

Line 2024: FROM fnd_exclude_table_stats fets,

2020: )
2021: -- leave alone if excluded table
2022: AND NOT EXISTS
2023: (SELECT NULL
2024: FROM fnd_exclude_table_stats fets,
2025: fnd_oracle_userid fou ,
2026: fnd_product_installations fpi
2027: WHERE fou.oracle_username=upper(schemaname)
2028: AND fou.oracle_id =fpi.oracle_id

Line 2270: FROM fnd_exclude_table_stats fets,

2266: )
2267: -- leave alone if excluded table
2268: AND NOT EXISTS
2269: (SELECT NULL
2270: FROM fnd_exclude_table_stats fets,
2271: fnd_oracle_userid fou ,
2272: fnd_product_installations fpi
2273: WHERE fou.oracle_username=upper(schemaname)
2274: AND fou.oracle_id =fpi.oracle_id

Line 3518: /* will be used to populate fnd_exclude_table_stats table , which */

3514: /******************************************************************************/
3515: /* Procedure: LOAD_XCLUD_TAB */
3516: /* Desciption: This procedure was deprecated, but 11.5.2CU2 onwards */
3517: /* we are reuseing it for a different purpose. This procedure */
3518: /* will be used to populate fnd_exclude_table_stats table , which */
3519: /* which contains the list of tables which should be skipped */
3520: /* by the gather schema stats program. */
3521: /******************************************************************************/
3522: PROCEDURE LOAD_XCLUD_TAB(action IN VARCHAR2,

Line 3572: INTO FND_EXCLUDE_TABLE_STATS

3568: END;
3569: END;
3570: -- Now insert
3571: INSERT
3572: INTO FND_EXCLUDE_TABLE_STATS
3573: (
3574: APPLICATION_ID ,
3575: TABLE_NAME ,
3576: CREATION_DATE ,

Line 3603: FROM FND_EXCLUDE_TABLE_STATS

3599: Upper(action) = 'D'
3600: )
3601: ) THEN
3602: DELETE
3603: FROM FND_EXCLUDE_TABLE_STATS
3604: WHERE table_name = upper(tabname)
3605: AND application_id = appl_id;
3606:
3607: END IF;