APPS.FII_PMV_HELPER_TABLES_C dependencies on FND_STATS

Line 715: FND_STATS.gather_table_stats

711: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_FC_PMV_AGRT_NODES');
712: END IF;
713:
714: g_phase := 'gather_table_stats for FII_FIN_ITEM_LEAF_HIERS';
715: FND_STATS.gather_table_stats
716: (ownname => g_schema_name,
717: tabname => 'FII_FIN_ITEM_LEAF_HIERS');
718:
719: -- Bug 4200473. Not to analyze MLOG in incremental run.

Line 723: -- FND_STATS.gather_table_stats

719: -- Bug 4200473. Not to analyze MLOG in incremental run.
720: -- As per performance teams suggestions.
721:
722: -- g_phase := 'gather_table_stats MLOG$_FII_FIN_ITEM_LEAF_HI';
723: -- FND_STATS.gather_table_stats
724: -- (ownname => g_schema_name,
725: -- tabname => 'MLOG$_FII_FIN_ITEM_LEAF_HI');
726:
727: ELSIF (p_dim_short_name = 'HRI_CL_ORGCC') THEN

Line 756: FND_STATS.gather_table_stats

752: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_CC_PMV_AGRT_NODES');
753: END IF;
754:
755: g_phase := 'gather_table_stats for FII_COST_CTR_HIERARCHIES';
756: FND_STATS.gather_table_stats
757: (ownname => g_schema_name,
758: tabname => 'FII_COST_CTR_HIERARCHIES');
759:
760: -- Bug 4200473. Not to analyze MLOG in incremental run.

Line 764: --FND_STATS.gather_table_stats

760: -- Bug 4200473. Not to analyze MLOG in incremental run.
761: -- As per performance teams suggestions.
762:
763: --g_phase := 'gather_table_stats for MLOG$_FII_COST_CTR_HIERARC';
764: --FND_STATS.gather_table_stats
765: -- (ownname => g_schema_name,
766: -- tabname => 'MLOG$_FII_COST_CTR_HIERARC');
767:
768: ELSIF (p_dim_short_name = 'FII_COMPANIES') THEN

Line 796: FND_STATS.gather_table_stats

792: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_COM_PMV_AGRT_NODES');
793: END IF;
794:
795: g_phase := 'gather_table_stats for FII_COMPANY_HIERARCHIES';
796: FND_STATS.gather_table_stats
797: (ownname => g_schema_name,
798: tabname => 'FII_COMPANY_HIERARCHIES');
799:
800: -- Bug 4200473. Not to analyze MLOG in incremental run.

Line 804: -- FND_STATS.gather_table_stats

800: -- Bug 4200473. Not to analyze MLOG in incremental run.
801: -- As per performance teams suggestions.
802:
803: -- g_phase := 'gather_table_stats for MLOG$_FII_COMPANY_HIERARCH';
804: -- FND_STATS.gather_table_stats
805: -- (ownname => g_schema_name,
806: -- tabname => 'MLOG$_FII_COMPANY_HIERARCH');
807:
808: ELSIF (p_dim_short_name = 'FII_USER_DEFINED_1') THEN

Line 836: FND_STATS.gather_table_stats

832: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT || ' rows into FII_UDD1_PMV_AGRT_NODES');
833: END IF;
834:
835: g_phase := 'gather_table_stats for FII_UDD1_HIERARCHIES';
836: FND_STATS.gather_table_stats
837: (ownname => g_schema_name,
838: tabname => 'FII_UDD1_HIERARCHIES');
839:
840: -- Bug 4200473. Not to analyze MLOG in incremental run.

Line 844: -- FND_STATS.gather_table_stats

840: -- Bug 4200473. Not to analyze MLOG in incremental run.
841: -- As per performance teams suggestions.
842:
843: -- g_phase := 'gather_table_stats for MLOG$_FII_UDD1_HIERARCHIES';
844: -- FND_STATS.gather_table_stats
845: -- (ownname => g_schema_name,
846: -- tabname => 'MLOG$_FII_UDD1_HIERARCHIES');
847:
848: END IF;

Line 1798: FND_STATS.gather_table_stats

1794:
1795: -- Gather table statistics
1796: -- This will be by seeding in RSG
1797: -- Need to remove this when RSG SEED data is done.
1798: FND_STATS.gather_table_stats
1799: (ownname => g_schema_name,
1800: tabname => 'FII_FC_PMV_AGRT_NODES');
1801:
1802: g_phase := 'gather_table_stats for FII_COM_PMV_AGRT_NODES';

Line 1804: FND_STATS.gather_table_stats

1800: tabname => 'FII_FC_PMV_AGRT_NODES');
1801:
1802: g_phase := 'gather_table_stats for FII_COM_PMV_AGRT_NODES';
1803:
1804: FND_STATS.gather_table_stats
1805: (ownname => g_schema_name,
1806: tabname => 'FII_COM_PMV_AGRT_NODES');
1807:
1808: g_phase := 'gather_table_stats for FII_CC_PMV_AGRT_NODES';

Line 1810: FND_STATS.gather_table_stats

1806: tabname => 'FII_COM_PMV_AGRT_NODES');
1807:
1808: g_phase := 'gather_table_stats for FII_CC_PMV_AGRT_NODES';
1809:
1810: FND_STATS.gather_table_stats
1811: (ownname => g_schema_name,
1812: tabname => 'FII_CC_PMV_AGRT_NODES');
1813:
1814: g_phase := 'gather_table_stats for FII_UDD1_PMV_AGRT_NODES';

Line 1816: FND_STATS.gather_table_stats

1812: tabname => 'FII_CC_PMV_AGRT_NODES');
1813:
1814: g_phase := 'gather_table_stats for FII_UDD1_PMV_AGRT_NODES';
1815:
1816: FND_STATS.gather_table_stats
1817: (ownname => g_schema_name,
1818: tabname => 'FII_UDD1_PMV_AGRT_NODES');
1819:
1820: --==============================================================--