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

Line 9535: --fnd_stats.gather_table_stats('MSC', 'MSC_ALLOC_TEMP_' || to_char(l_plan_id), granularity => 'ALL');

9531: msc_util.msc_log('Done creating indexes on temp table');
9532: msc_util.msc_log('Gather Table Stats');
9533:
9534: -- Use p_plan_id instead of l_plan_id
9535: --fnd_stats.gather_table_stats('MSC', 'MSC_ALLOC_TEMP_' || to_char(l_plan_id), granularity => 'ALL');
9536: fnd_stats.gather_table_stats(l_msc_schema, l_alloc_temp_table, granularity => 'ALL');
9537: END IF;
9538: /* forecast at PF changes end*/
9539:

Line 9536: fnd_stats.gather_table_stats(l_msc_schema, l_alloc_temp_table, granularity => 'ALL');

9532: msc_util.msc_log('Gather Table Stats');
9533:
9534: -- Use p_plan_id instead of l_plan_id
9535: --fnd_stats.gather_table_stats('MSC', 'MSC_ALLOC_TEMP_' || to_char(l_plan_id), granularity => 'ALL');
9536: fnd_stats.gather_table_stats(l_msc_schema, l_alloc_temp_table, granularity => 'ALL');
9537: END IF;
9538: /* forecast at PF changes end*/
9539:
9540: IF l_share_partition = 'Y' THEN

Line 9639: fnd_stats.gather_table_stats(ownname=>l_msc_schema,tabname=>'MSC_ALLOC_DEMANDS',

9635: msc_util.msc_log('rows processed: ' || rows_processed);
9636: msc_util.msc_log('after inserting item data into MSC_ALLOC_SUPPLIES tables');
9637:
9638: msc_util.msc_log('Analyze Plan partition for MSC_ALLOC_DEMANDS');
9639: fnd_stats.gather_table_stats(ownname=>l_msc_schema,tabname=>'MSC_ALLOC_DEMANDS',
9640: partname=>'ALLOC_DEMANDS_999999',
9641: granularity=>'PARTITION',
9642: percent =>10);
9643:

Line 9645: fnd_stats.gather_table_stats(ownname=>l_msc_schema,tabname=>'MSC_ALLOC_SUPPLIES',

9641: granularity=>'PARTITION',
9642: percent =>10);
9643:
9644: msc_util.msc_log('Analyze Plan partition for MSC_ALLOC_SUPPLIES');
9645: fnd_stats.gather_table_stats(ownname=>l_msc_schema,tabname=>'MSC_ALLOC_SUPPLIES',
9646: partname=>'ALLOC_SUPPLIES_999999',
9647: granularity=>'PARTITION',
9648: percent =>10);
9649:

Line 10028: fnd_stats.gather_table_stats(l_msc_schema, 'MSC_TEMP_ALLOC_DEM_' || to_char(l_plan_id), granularity => 'ALL');

10024: msc_util.msc_log('After index : ' || l_temp_table || '.' || l_temp_table || '_N3');
10025:
10026: msc_util.msc_log('Gather Table Stats for Allocated S/D Tables');
10027:
10028: fnd_stats.gather_table_stats(l_msc_schema, 'MSC_TEMP_ALLOC_DEM_' || to_char(l_plan_id), granularity => 'ALL');
10029: fnd_stats.gather_table_stats(l_msc_schema, 'MSC_TEMP_ALLOC_SUP_' || to_char(l_plan_id), granularity => 'ALL');
10030:
10031: msc_util.msc_log('swap partition for demands');
10032: l_partition_name := 'ALLOC_DEMANDS_' || to_char(l_plan_id);

Line 10029: fnd_stats.gather_table_stats(l_msc_schema, 'MSC_TEMP_ALLOC_SUP_' || to_char(l_plan_id), granularity => 'ALL');

10025:
10026: msc_util.msc_log('Gather Table Stats for Allocated S/D Tables');
10027:
10028: fnd_stats.gather_table_stats(l_msc_schema, 'MSC_TEMP_ALLOC_DEM_' || to_char(l_plan_id), granularity => 'ALL');
10029: fnd_stats.gather_table_stats(l_msc_schema, 'MSC_TEMP_ALLOC_SUP_' || to_char(l_plan_id), granularity => 'ALL');
10030:
10031: msc_util.msc_log('swap partition for demands');
10032: l_partition_name := 'ALLOC_DEMANDS_' || to_char(l_plan_id);
10033: