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 9509: --fnd_stats.gather_table_stats('MSC', 'MSC_ALLOC_TEMP_' || to_char(l_plan_id), granularity => 'ALL');

9505: msc_util.msc_log('Done creating indexes on temp table');
9506: msc_util.msc_log('Gather Table Stats');
9507:
9508: -- Use p_plan_id instead of l_plan_id
9509: --fnd_stats.gather_table_stats('MSC', 'MSC_ALLOC_TEMP_' || to_char(l_plan_id), granularity => 'ALL');
9510: fnd_stats.gather_table_stats('MSC', l_alloc_temp_table, granularity => 'ALL');
9511: END IF;
9512: /* forecast at PF changes end*/
9513:

Line 9510: fnd_stats.gather_table_stats('MSC', l_alloc_temp_table, granularity => 'ALL');

9506: msc_util.msc_log('Gather Table Stats');
9507:
9508: -- Use p_plan_id instead of l_plan_id
9509: --fnd_stats.gather_table_stats('MSC', 'MSC_ALLOC_TEMP_' || to_char(l_plan_id), granularity => 'ALL');
9510: fnd_stats.gather_table_stats('MSC', l_alloc_temp_table, granularity => 'ALL');
9511: END IF;
9512: /* forecast at PF changes end*/
9513:
9514: IF l_share_partition = 'Y' THEN

Line 9613: fnd_stats.gather_table_stats(ownname=>'MSC',tabname=>'MSC_ALLOC_DEMANDS',

9609: msc_util.msc_log('rows processed: ' || rows_processed);
9610: msc_util.msc_log('after inserting item data into MSC_ALLOC_SUPPLIES tables');
9611:
9612: msc_util.msc_log('Analyze Plan partition for MSC_ALLOC_DEMANDS');
9613: fnd_stats.gather_table_stats(ownname=>'MSC',tabname=>'MSC_ALLOC_DEMANDS',
9614: partname=>'ALLOC_DEMANDS_999999',
9615: granularity=>'PARTITION',
9616: percent =>10);
9617:

Line 9619: fnd_stats.gather_table_stats(ownname=>'MSC',tabname=>'MSC_ALLOC_SUPPLIES',

9615: granularity=>'PARTITION',
9616: percent =>10);
9617:
9618: msc_util.msc_log('Analyze Plan partition for MSC_ALLOC_SUPPLIES');
9619: fnd_stats.gather_table_stats(ownname=>'MSC',tabname=>'MSC_ALLOC_SUPPLIES',
9620: partname=>'ALLOC_SUPPLIES_999999',
9621: granularity=>'PARTITION',
9622: percent =>10);
9623:

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

9998: msc_util.msc_log('After index : ' || l_temp_table || '.' || l_temp_table || '_N3');
9999:
10000: msc_util.msc_log('Gather Table Stats for Allocated S/D Tables');
10001:
10002: fnd_stats.gather_table_stats('MSC', 'MSC_TEMP_ALLOC_DEM_' || to_char(l_plan_id), granularity => 'ALL');
10003: fnd_stats.gather_table_stats('MSC', 'MSC_TEMP_ALLOC_SUP_' || to_char(l_plan_id), granularity => 'ALL');
10004:
10005: msc_util.msc_log('swap partition for demands');
10006: l_partition_name := 'ALLOC_DEMANDS_' || to_char(l_plan_id);

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

9999:
10000: msc_util.msc_log('Gather Table Stats for Allocated S/D Tables');
10001:
10002: fnd_stats.gather_table_stats('MSC', 'MSC_TEMP_ALLOC_DEM_' || to_char(l_plan_id), granularity => 'ALL');
10003: fnd_stats.gather_table_stats('MSC', 'MSC_TEMP_ALLOC_SUP_' || to_char(l_plan_id), granularity => 'ALL');
10004:
10005: msc_util.msc_log('swap partition for demands');
10006: l_partition_name := 'ALLOC_DEMANDS_' || to_char(l_plan_id);
10007: