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.FII_UDD1_MAINTAIN_PKG dependencies on FND_STATS

Line 447: --Call FND_STATS to collect statistics after populating the table

443: Where flex_value_set_id = l_vset_id;
444:
445: END LOOP;
446:
447: --Call FND_STATS to collect statistics after populating the table
448: g_phase := 'gather_table_stats for FII_DIM_NORM_HIER_GT';
449:
450: FND_STATS.gather_table_stats
451: (ownname => g_schema_name,

Line 450: FND_STATS.gather_table_stats

446:
447: --Call FND_STATS to collect statistics after populating the table
448: g_phase := 'gather_table_stats for FII_DIM_NORM_HIER_GT';
449:
450: FND_STATS.gather_table_stats
451: (ownname => g_schema_name,
452: tabname => 'FII_DIM_NORM_HIER_GT');
453:
454: IF (FIIDIM_Debug) THEN

Line 889: --Call FND_STATS to collect statistics after populating the table

885: IF (FIIDIM_Debug) THEN
886: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT || ' rows into FII_UDD1_HIER_GT');
887: END IF;
888:
889: --Call FND_STATS to collect statistics after populating the table
890: g_phase := 'gather_table_stats for FII_FIN_ITEM_HIER_GT';
891:
892: FND_STATS.gather_table_stats
893: (ownname => g_schema_name,

Line 892: FND_STATS.gather_table_stats

888:
889: --Call FND_STATS to collect statistics after populating the table
890: g_phase := 'gather_table_stats for FII_FIN_ITEM_HIER_GT';
891:
892: FND_STATS.gather_table_stats
893: (ownname => g_schema_name,
894: tabname => 'FII_FIN_ITEM_HIER_GT');
895:
896: --====================================================================

Line 998: --Call FND_STATS to collect statistics after populating the table

994:
995: --------------------------------------------------------
996: -- Gather statistics for the use of cost-based optimizer
997: --------------------------------------------------------
998: --Call FND_STATS to collect statistics after populating the table
999: g_phase := 'gather_table_stats for FII_UDD1_MAPPINGS_GT';
1000:
1001: FND_STATS.gather_table_stats
1002: (ownname => g_schema_name,

Line 1001: FND_STATS.gather_table_stats

997: --------------------------------------------------------
998: --Call FND_STATS to collect statistics after populating the table
999: g_phase := 'gather_table_stats for FII_UDD1_MAPPINGS_GT';
1000:
1001: FND_STATS.gather_table_stats
1002: (ownname => g_schema_name,
1003: tabname => 'FII_UDD1_MAPPING_GT');
1004:
1005: IF (FIIDIM_Debug) THEN

Line 1314: --Call FND_STATS to collect statistics after re-populating the tables.

1310: --------------------------------------------------------
1311: -- Gather statistics for the use of cost-based optimizer
1312: --------------------------------------------------------
1313:
1314: --Call FND_STATS to collect statistics after re-populating the tables.
1315: --for the full dimension table since it will be used later
1316: FND_STATS.gather_table_stats
1317: (ownname => g_schema_name,
1318: tabname => 'FII_FULL_UDD1_HIERS');

Line 1316: FND_STATS.gather_table_stats

1312: --------------------------------------------------------
1313:
1314: --Call FND_STATS to collect statistics after re-populating the tables.
1315: --for the full dimension table since it will be used later
1316: FND_STATS.gather_table_stats
1317: (ownname => g_schema_name,
1318: tabname => 'FII_FULL_UDD1_HIERS');
1319:
1320: --==============================================================--

Line 1377: FND_STATS.gather_table_stats

1373:
1374:
1375: -- This will be in RSG data
1376: g_phase := 'gather_table_stats for FII_UDD1_HIERARCHIES';
1377: FND_STATS.gather_table_stats
1378: (ownname => g_schema_name,
1379: tabname => 'FII_UDD1_HIERARCHIES');
1380:
1381: g_phase := 'gather_table_stats for MLOG$_FII_UDD1_HIERARCHIES';

Line 1382: FND_STATS.gather_table_stats

1378: (ownname => g_schema_name,
1379: tabname => 'FII_UDD1_HIERARCHIES');
1380:
1381: g_phase := 'gather_table_stats for MLOG$_FII_UDD1_HIERARCHIES';
1382: FND_STATS.gather_table_stats
1383: (ownname => g_schema_name,
1384: tabname => 'MLOG$_FII_UDD1_HIERARCHIES');
1385:
1386: --to avoid ORA-12838: cannot read/modify an object after modifying

Line 1427: --Call FND_STATS to collect statistics after re-populating the table.

1423:
1424: --------------------------------------------------------
1425: -- Gather statistics for the use of cost-based optimizer
1426: --------------------------------------------------------
1427: --Call FND_STATS to collect statistics after re-populating the table.
1428:
1429: g_phase := 'gather_table_stats FII_UDD1_MAPPINGS';
1430:
1431: FND_STATS.gather_table_stats

Line 1431: FND_STATS.gather_table_stats

1427: --Call FND_STATS to collect statistics after re-populating the table.
1428:
1429: g_phase := 'gather_table_stats FII_UDD1_MAPPINGS';
1430:
1431: FND_STATS.gather_table_stats
1432: (ownname => g_schema_name,
1433: tabname => 'FII_UDD1_MAPPINGS');
1434:
1435: g_phase := 'gather_table_stats MLOG$_FII_UDD1_MAPPINGS';

Line 1437: FND_STATS.gather_table_stats

1433: tabname => 'FII_UDD1_MAPPINGS');
1434:
1435: g_phase := 'gather_table_stats MLOG$_FII_UDD1_MAPPINGS';
1436:
1437: FND_STATS.gather_table_stats
1438: (ownname => g_schema_name,
1439: tabname => 'MLOG$_FII_UDD1_MAPPINGS');
1440:
1441: --=====================================================================

Line 1568: --Call FND_STATS to collect statistics after re-populating the tables.

1564:
1565: --------------------------------------------------------
1566: -- Gather statistics for the use of cost-based optimizer
1567: --------------------------------------------------------
1568: --Call FND_STATS to collect statistics after re-populating the tables.
1569: --for the full dimension table since it will be used later
1570: FND_STATS.gather_table_stats
1571: (ownname => g_schema_name,
1572: tabname => 'FII_FULL_UDD1_HIERS');

Line 1570: FND_STATS.gather_table_stats

1566: -- Gather statistics for the use of cost-based optimizer
1567: --------------------------------------------------------
1568: --Call FND_STATS to collect statistics after re-populating the tables.
1569: --for the full dimension table since it will be used later
1570: FND_STATS.gather_table_stats
1571: (ownname => g_schema_name,
1572: tabname => 'FII_FULL_UDD1_HIERS');
1573:
1574: --==============================================================--

Line 1681: FND_STATS.gather_table_stats

1677: END IF;
1678:
1679: -- This will be in RSG data
1680: g_phase := 'gather_table_stats for FII_UDD1_HIERARCHIES';
1681: FND_STATS.gather_table_stats
1682: (ownname => g_schema_name,
1683: tabname => 'FII_UDD1_HIERARCHIES');
1684:
1685: -- Bug 4200473. Not to analyze MLOG in incremental run.

Line 1689: -- FND_STATS.gather_table_stats

1685: -- Bug 4200473. Not to analyze MLOG in incremental run.
1686: -- As per performance teams suggestions.
1687:
1688: -- g_phase := 'gather_table_stats for MLOG$_FII_UDD1_HIERARCHIES';
1689: -- FND_STATS.gather_table_stats
1690: -- (ownname => g_schema_name,
1691: -- tabname => 'MLOG$_FII_UDD1_HIERARCHIES');
1692:
1693: --=============================================================--

Line 1753: --Call FND_STATS to collect statistics after re-populating the table.

1749:
1750: --------------------------------------------------------
1751: -- Gather statistics for the use of cost-based optimizer
1752: --------------------------------------------------------
1753: --Call FND_STATS to collect statistics after re-populating the table.
1754:
1755: g_phase := 'gather_table_stats for FII_UDD1_MAPPINGS';
1756:
1757: FND_STATS.gather_table_stats

Line 1757: FND_STATS.gather_table_stats

1753: --Call FND_STATS to collect statistics after re-populating the table.
1754:
1755: g_phase := 'gather_table_stats for FII_UDD1_MAPPINGS';
1756:
1757: FND_STATS.gather_table_stats
1758: (ownname => g_schema_name,
1759: tabname => 'FII_UDD1_MAPPINGS');
1760:
1761: -- Bug 4200473. Not to analyze MLOG in incremental run.

Line 1766: -- FND_STATS.gather_table_stats

1762: -- As per performance teams suggestions.
1763:
1764: -- g_phase := 'gather_table_stats for MLOG$_FII_UDD1_MAPPINGS';
1765:
1766: -- FND_STATS.gather_table_stats
1767: -- (ownname => g_schema_name,
1768: -- tabname => 'MLOG$_FII_UDD1_MAPPINGS');
1769:
1770: --=====================================================================