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

Line 1600: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ALL_COLUMNS_MD',10,1);

1596: l_retcode varchar2(200);
1597: Begin
1598: log('system time is '|| fnd_date.date_to_displaydt (sysdate) );
1599: log('going to analyze metadata tables ');
1600: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ALL_COLUMNS_MD',10,1);
1601: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ATTRIBUTE_SETS_MD',10,1);
1602: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ATTRIBUTE_SET_COLUMN_MD',10,1);
1603: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_DIMENSIONS_MD',10,1);
1604: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_DIM_ATTRIBUTES_MD',10,1);

Line 1601: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ATTRIBUTE_SETS_MD',10,1);

1597: Begin
1598: log('system time is '|| fnd_date.date_to_displaydt (sysdate) );
1599: log('going to analyze metadata tables ');
1600: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ALL_COLUMNS_MD',10,1);
1601: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ATTRIBUTE_SETS_MD',10,1);
1602: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ATTRIBUTE_SET_COLUMN_MD',10,1);
1603: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_DIMENSIONS_MD',10,1);
1604: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_DIM_ATTRIBUTES_MD',10,1);
1605: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACTS_MD',10,1);

Line 1602: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ATTRIBUTE_SET_COLUMN_MD',10,1);

1598: log('system time is '|| fnd_date.date_to_displaydt (sysdate) );
1599: log('going to analyze metadata tables ');
1600: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ALL_COLUMNS_MD',10,1);
1601: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ATTRIBUTE_SETS_MD',10,1);
1602: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ATTRIBUTE_SET_COLUMN_MD',10,1);
1603: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_DIMENSIONS_MD',10,1);
1604: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_DIM_ATTRIBUTES_MD',10,1);
1605: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACTS_MD',10,1);
1606: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_ATTRIBUTES_MD',10,1);

Line 1603: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_DIMENSIONS_MD',10,1);

1599: log('going to analyze metadata tables ');
1600: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ALL_COLUMNS_MD',10,1);
1601: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ATTRIBUTE_SETS_MD',10,1);
1602: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ATTRIBUTE_SET_COLUMN_MD',10,1);
1603: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_DIMENSIONS_MD',10,1);
1604: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_DIM_ATTRIBUTES_MD',10,1);
1605: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACTS_MD',10,1);
1606: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_ATTRIBUTES_MD',10,1);
1607: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_DIM_RELATIONS_MD',10,1);

Line 1604: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_DIM_ATTRIBUTES_MD',10,1);

1600: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ALL_COLUMNS_MD',10,1);
1601: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ATTRIBUTE_SETS_MD',10,1);
1602: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ATTRIBUTE_SET_COLUMN_MD',10,1);
1603: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_DIMENSIONS_MD',10,1);
1604: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_DIM_ATTRIBUTES_MD',10,1);
1605: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACTS_MD',10,1);
1606: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_ATTRIBUTES_MD',10,1);
1607: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_DIM_RELATIONS_MD',10,1);
1608: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_HIER_MD',10,1);

Line 1605: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACTS_MD',10,1);

1601: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ATTRIBUTE_SETS_MD',10,1);
1602: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ATTRIBUTE_SET_COLUMN_MD',10,1);
1603: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_DIMENSIONS_MD',10,1);
1604: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_DIM_ATTRIBUTES_MD',10,1);
1605: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACTS_MD',10,1);
1606: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_ATTRIBUTES_MD',10,1);
1607: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_DIM_RELATIONS_MD',10,1);
1608: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_HIER_MD',10,1);
1609: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FOREIGN_KEYS_MD',10,1);

Line 1606: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_ATTRIBUTES_MD',10,1);

1602: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_ATTRIBUTE_SET_COLUMN_MD',10,1);
1603: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_DIMENSIONS_MD',10,1);
1604: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_DIM_ATTRIBUTES_MD',10,1);
1605: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACTS_MD',10,1);
1606: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_ATTRIBUTES_MD',10,1);
1607: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_DIM_RELATIONS_MD',10,1);
1608: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_HIER_MD',10,1);
1609: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FOREIGN_KEYS_MD',10,1);
1610: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FOREIGN_KEY_COLUMNS_MD',10,1);

Line 1607: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_DIM_RELATIONS_MD',10,1);

1603: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_DIMENSIONS_MD',10,1);
1604: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_DIM_ATTRIBUTES_MD',10,1);
1605: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACTS_MD',10,1);
1606: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_ATTRIBUTES_MD',10,1);
1607: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_DIM_RELATIONS_MD',10,1);
1608: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_HIER_MD',10,1);
1609: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FOREIGN_KEYS_MD',10,1);
1610: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FOREIGN_KEY_COLUMNS_MD',10,1);
1611: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_HIERARCHIES_MD',10,1);

Line 1608: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_HIER_MD',10,1);

1604: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_DIM_ATTRIBUTES_MD',10,1);
1605: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACTS_MD',10,1);
1606: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_ATTRIBUTES_MD',10,1);
1607: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_DIM_RELATIONS_MD',10,1);
1608: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_HIER_MD',10,1);
1609: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FOREIGN_KEYS_MD',10,1);
1610: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FOREIGN_KEY_COLUMNS_MD',10,1);
1611: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_HIERARCHIES_MD',10,1);
1612: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_HIERARCHY_LEVEL_MD',10,1);

Line 1609: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FOREIGN_KEYS_MD',10,1);

1605: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACTS_MD',10,1);
1606: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_ATTRIBUTES_MD',10,1);
1607: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_DIM_RELATIONS_MD',10,1);
1608: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_HIER_MD',10,1);
1609: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FOREIGN_KEYS_MD',10,1);
1610: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FOREIGN_KEY_COLUMNS_MD',10,1);
1611: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_HIERARCHIES_MD',10,1);
1612: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_HIERARCHY_LEVEL_MD',10,1);
1613: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVELS_MD',10,1);

Line 1610: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FOREIGN_KEY_COLUMNS_MD',10,1);

1606: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_ATTRIBUTES_MD',10,1);
1607: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_DIM_RELATIONS_MD',10,1);
1608: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_HIER_MD',10,1);
1609: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FOREIGN_KEYS_MD',10,1);
1610: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FOREIGN_KEY_COLUMNS_MD',10,1);
1611: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_HIERARCHIES_MD',10,1);
1612: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_HIERARCHY_LEVEL_MD',10,1);
1613: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVELS_MD',10,1);
1614: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_ATTS_MD',10,1);

Line 1611: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_HIERARCHIES_MD',10,1);

1607: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_DIM_RELATIONS_MD',10,1);
1608: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_HIER_MD',10,1);
1609: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FOREIGN_KEYS_MD',10,1);
1610: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FOREIGN_KEY_COLUMNS_MD',10,1);
1611: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_HIERARCHIES_MD',10,1);
1612: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_HIERARCHY_LEVEL_MD',10,1);
1613: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVELS_MD',10,1);
1614: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_ATTS_MD',10,1);
1615: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_RELATIONS_MD',10,1);

Line 1612: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_HIERARCHY_LEVEL_MD',10,1);

1608: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FACT_HIER_MD',10,1);
1609: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FOREIGN_KEYS_MD',10,1);
1610: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FOREIGN_KEY_COLUMNS_MD',10,1);
1611: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_HIERARCHIES_MD',10,1);
1612: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_HIERARCHY_LEVEL_MD',10,1);
1613: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVELS_MD',10,1);
1614: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_ATTS_MD',10,1);
1615: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_RELATIONS_MD',10,1);
1616: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_TABLE_ATTS_MD',10,1);

Line 1613: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVELS_MD',10,1);

1609: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FOREIGN_KEYS_MD',10,1);
1610: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FOREIGN_KEY_COLUMNS_MD',10,1);
1611: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_HIERARCHIES_MD',10,1);
1612: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_HIERARCHY_LEVEL_MD',10,1);
1613: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVELS_MD',10,1);
1614: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_ATTS_MD',10,1);
1615: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_RELATIONS_MD',10,1);
1616: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_TABLE_ATTS_MD',10,1);
1617: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_RELATIONMAPPING_MD',10,1);

Line 1614: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_ATTS_MD',10,1);

1610: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_FOREIGN_KEY_COLUMNS_MD',10,1);
1611: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_HIERARCHIES_MD',10,1);
1612: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_HIERARCHY_LEVEL_MD',10,1);
1613: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVELS_MD',10,1);
1614: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_ATTS_MD',10,1);
1615: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_RELATIONS_MD',10,1);
1616: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_TABLE_ATTS_MD',10,1);
1617: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_RELATIONMAPPING_MD',10,1);
1618: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_RELATIONS_MD',10,1);

Line 1615: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_RELATIONS_MD',10,1);

1611: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_HIERARCHIES_MD',10,1);
1612: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_HIERARCHY_LEVEL_MD',10,1);
1613: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVELS_MD',10,1);
1614: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_ATTS_MD',10,1);
1615: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_RELATIONS_MD',10,1);
1616: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_TABLE_ATTS_MD',10,1);
1617: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_RELATIONMAPPING_MD',10,1);
1618: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_RELATIONS_MD',10,1);
1619: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_TABLES_MD',10,1);

Line 1616: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_TABLE_ATTS_MD',10,1);

1612: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_HIERARCHY_LEVEL_MD',10,1);
1613: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVELS_MD',10,1);
1614: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_ATTS_MD',10,1);
1615: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_RELATIONS_MD',10,1);
1616: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_TABLE_ATTS_MD',10,1);
1617: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_RELATIONMAPPING_MD',10,1);
1618: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_RELATIONS_MD',10,1);
1619: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_TABLES_MD',10,1);
1620: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_UNIQUE_KEYS_MD',10,1);

Line 1617: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_RELATIONMAPPING_MD',10,1);

1613: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVELS_MD',10,1);
1614: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_ATTS_MD',10,1);
1615: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_RELATIONS_MD',10,1);
1616: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_TABLE_ATTS_MD',10,1);
1617: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_RELATIONMAPPING_MD',10,1);
1618: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_RELATIONS_MD',10,1);
1619: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_TABLES_MD',10,1);
1620: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_UNIQUE_KEYS_MD',10,1);
1621: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_UNIQUE_KEY_COLUMNS_MD',10,1);

Line 1618: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_RELATIONS_MD',10,1);

1614: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_ATTS_MD',10,1);
1615: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_RELATIONS_MD',10,1);
1616: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_TABLE_ATTS_MD',10,1);
1617: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_RELATIONMAPPING_MD',10,1);
1618: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_RELATIONS_MD',10,1);
1619: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_TABLES_MD',10,1);
1620: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_UNIQUE_KEYS_MD',10,1);
1621: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_UNIQUE_KEY_COLUMNS_MD',10,1);
1622: ----pvt tables

Line 1619: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_TABLES_MD',10,1);

1615: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_RELATIONS_MD',10,1);
1616: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_TABLE_ATTS_MD',10,1);
1617: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_RELATIONMAPPING_MD',10,1);
1618: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_RELATIONS_MD',10,1);
1619: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_TABLES_MD',10,1);
1620: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_UNIQUE_KEYS_MD',10,1);
1621: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_UNIQUE_KEY_COLUMNS_MD',10,1);
1622: ----pvt tables
1623: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_COLUMNS_MD',10,1);

Line 1620: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_UNIQUE_KEYS_MD',10,1);

1616: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_LEVEL_TABLE_ATTS_MD',10,1);
1617: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_RELATIONMAPPING_MD',10,1);
1618: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_RELATIONS_MD',10,1);
1619: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_TABLES_MD',10,1);
1620: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_UNIQUE_KEYS_MD',10,1);
1621: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_UNIQUE_KEY_COLUMNS_MD',10,1);
1622: ----pvt tables
1623: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_COLUMNS_MD',10,1);
1624: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_KEY_COLUMNS_MD',10,1);

Line 1621: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_UNIQUE_KEY_COLUMNS_MD',10,1);

1617: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_RELATIONMAPPING_MD',10,1);
1618: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_RELATIONS_MD',10,1);
1619: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_TABLES_MD',10,1);
1620: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_UNIQUE_KEYS_MD',10,1);
1621: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_UNIQUE_KEY_COLUMNS_MD',10,1);
1622: ----pvt tables
1623: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_COLUMNS_MD',10,1);
1624: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_KEY_COLUMNS_MD',10,1);
1625: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_LEVEL_RELATION_MD',10,1);

Line 1623: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_COLUMNS_MD',10,1);

1619: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_TABLES_MD',10,1);
1620: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_UNIQUE_KEYS_MD',10,1);
1621: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_UNIQUE_KEY_COLUMNS_MD',10,1);
1622: ----pvt tables
1623: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_COLUMNS_MD',10,1);
1624: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_KEY_COLUMNS_MD',10,1);
1625: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_LEVEL_RELATION_MD',10,1);
1626: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAPPINGS_MD',10,1);
1627: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_COLUMNS_MD',10,1);

Line 1624: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_KEY_COLUMNS_MD',10,1);

1620: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_UNIQUE_KEYS_MD',10,1);
1621: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_UNIQUE_KEY_COLUMNS_MD',10,1);
1622: ----pvt tables
1623: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_COLUMNS_MD',10,1);
1624: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_KEY_COLUMNS_MD',10,1);
1625: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_LEVEL_RELATION_MD',10,1);
1626: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAPPINGS_MD',10,1);
1627: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_COLUMNS_MD',10,1);
1628: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'edw_pvt_map_columns_tgt_md',10,1);

Line 1625: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_LEVEL_RELATION_MD',10,1);

1621: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_UNIQUE_KEY_COLUMNS_MD',10,1);
1622: ----pvt tables
1623: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_COLUMNS_MD',10,1);
1624: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_KEY_COLUMNS_MD',10,1);
1625: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_LEVEL_RELATION_MD',10,1);
1626: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAPPINGS_MD',10,1);
1627: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_COLUMNS_MD',10,1);
1628: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'edw_pvt_map_columns_tgt_md',10,1);
1629: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'edw_pvt_map_columns_src_md',10,1);

Line 1626: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAPPINGS_MD',10,1);

1622: ----pvt tables
1623: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_COLUMNS_MD',10,1);
1624: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_KEY_COLUMNS_MD',10,1);
1625: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_LEVEL_RELATION_MD',10,1);
1626: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAPPINGS_MD',10,1);
1627: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_COLUMNS_MD',10,1);
1628: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'edw_pvt_map_columns_tgt_md',10,1);
1629: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'edw_pvt_map_columns_src_md',10,1);
1630: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_FUNC_MD',10,1);

Line 1627: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_COLUMNS_MD',10,1);

1623: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_COLUMNS_MD',10,1);
1624: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_KEY_COLUMNS_MD',10,1);
1625: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_LEVEL_RELATION_MD',10,1);
1626: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAPPINGS_MD',10,1);
1627: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_COLUMNS_MD',10,1);
1628: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'edw_pvt_map_columns_tgt_md',10,1);
1629: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'edw_pvt_map_columns_src_md',10,1);
1630: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_FUNC_MD',10,1);
1631: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_KEY_USAGES_MD',10,1);

Line 1628: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'edw_pvt_map_columns_tgt_md',10,1);

1624: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_KEY_COLUMNS_MD',10,1);
1625: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_LEVEL_RELATION_MD',10,1);
1626: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAPPINGS_MD',10,1);
1627: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_COLUMNS_MD',10,1);
1628: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'edw_pvt_map_columns_tgt_md',10,1);
1629: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'edw_pvt_map_columns_src_md',10,1);
1630: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_FUNC_MD',10,1);
1631: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_KEY_USAGES_MD',10,1);
1632: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_PROPERTIES_MD',10,1);

Line 1629: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'edw_pvt_map_columns_src_md',10,1);

1625: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_LEVEL_RELATION_MD',10,1);
1626: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAPPINGS_MD',10,1);
1627: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_COLUMNS_MD',10,1);
1628: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'edw_pvt_map_columns_tgt_md',10,1);
1629: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'edw_pvt_map_columns_src_md',10,1);
1630: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_FUNC_MD',10,1);
1631: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_KEY_USAGES_MD',10,1);
1632: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_PROPERTIES_MD',10,1);
1633: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_SOURCES_MD',10,1);

Line 1630: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_FUNC_MD',10,1);

1626: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAPPINGS_MD',10,1);
1627: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_COLUMNS_MD',10,1);
1628: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'edw_pvt_map_columns_tgt_md',10,1);
1629: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'edw_pvt_map_columns_src_md',10,1);
1630: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_FUNC_MD',10,1);
1631: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_KEY_USAGES_MD',10,1);
1632: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_PROPERTIES_MD',10,1);
1633: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_SOURCES_MD',10,1);
1634: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_TARGETS_MD',10,1);

Line 1631: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_KEY_USAGES_MD',10,1);

1627: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_COLUMNS_MD',10,1);
1628: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'edw_pvt_map_columns_tgt_md',10,1);
1629: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'edw_pvt_map_columns_src_md',10,1);
1630: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_FUNC_MD',10,1);
1631: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_KEY_USAGES_MD',10,1);
1632: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_PROPERTIES_MD',10,1);
1633: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_SOURCES_MD',10,1);
1634: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_TARGETS_MD',10,1);
1635: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_SEQUENCES_MD',10,1);

Line 1632: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_PROPERTIES_MD',10,1);

1628: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'edw_pvt_map_columns_tgt_md',10,1);
1629: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'edw_pvt_map_columns_src_md',10,1);
1630: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_FUNC_MD',10,1);
1631: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_KEY_USAGES_MD',10,1);
1632: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_PROPERTIES_MD',10,1);
1633: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_SOURCES_MD',10,1);
1634: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_TARGETS_MD',10,1);
1635: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_SEQUENCES_MD',10,1);
1636: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_VIEWS_MD',10,1);

Line 1633: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_SOURCES_MD',10,1);

1629: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'edw_pvt_map_columns_src_md',10,1);
1630: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_FUNC_MD',10,1);
1631: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_KEY_USAGES_MD',10,1);
1632: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_PROPERTIES_MD',10,1);
1633: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_SOURCES_MD',10,1);
1634: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_TARGETS_MD',10,1);
1635: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_SEQUENCES_MD',10,1);
1636: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_VIEWS_MD',10,1);
1637: log('finish analyzing metadata tables.');

Line 1634: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_TARGETS_MD',10,1);

1630: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_FUNC_MD',10,1);
1631: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_KEY_USAGES_MD',10,1);
1632: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_PROPERTIES_MD',10,1);
1633: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_SOURCES_MD',10,1);
1634: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_TARGETS_MD',10,1);
1635: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_SEQUENCES_MD',10,1);
1636: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_VIEWS_MD',10,1);
1637: log('finish analyzing metadata tables.');
1638: log('system time is '|| fnd_date.date_to_displaydt (sysdate) );

Line 1635: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_SEQUENCES_MD',10,1);

1631: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_KEY_USAGES_MD',10,1);
1632: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_PROPERTIES_MD',10,1);
1633: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_SOURCES_MD',10,1);
1634: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_TARGETS_MD',10,1);
1635: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_SEQUENCES_MD',10,1);
1636: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_VIEWS_MD',10,1);
1637: log('finish analyzing metadata tables.');
1638: log('system time is '|| fnd_date.date_to_displaydt (sysdate) );
1639: Exception when others then

Line 1636: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_VIEWS_MD',10,1);

1632: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_PROPERTIES_MD',10,1);
1633: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_SOURCES_MD',10,1);
1634: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_MAP_TARGETS_MD',10,1);
1635: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_SEQUENCES_MD',10,1);
1636: fnd_stats.gather_table_stats(l_errbuf, l_retcode,g_bis_owner,'EDW_PVT_VIEWS_MD',10,1);
1637: log('finish analyzing metadata tables.');
1638: log('system time is '|| fnd_date.date_to_displaydt (sysdate) );
1639: Exception when others then
1640: log('Error in analye_all '||sqlerrm);