APPS.MSC_POST_PRO dependencies on FND_STATS

Line 539: fnd_stats.gather_table_stats(l_msc_schema, 'MSC_TEMP_SUMM_SO', granularity => 'ALL');

535: STATEMENT => l_sql_stmt_1,
536: OBJECT_NAME => 'MSC_TEMP_SUMM_SO');
537: END;
538: --analyze temp table
539: fnd_stats.gather_table_stats(l_msc_schema, 'MSC_TEMP_SUMM_SO', granularity => 'ALL');
540:
541: l_partition_name := 'ATP_SUMMARY_SO__' || to_char(p_instance_id);
542: msc_util.msc_log('Sales order partition name := ' || l_partition_name);
543: l_sql_stmt := 'ALTER TABLE MSC_ATP_SUMMARY_SO exchange partition ' || l_partition_name ||

Line 574: fnd_stats.gather_table_stats(l_msc_schema, 'MSC_TEMP_SUMM_SD', granularity => 'ALL');

570: STATEMENT => l_sql_stmt_1,
571: OBJECT_NAME => 'MSC_TEMP_SUMM_SD');
572: END;
573: ---analyze supply demand table
574: fnd_stats.gather_table_stats(l_msc_schema, 'MSC_TEMP_SUMM_SD', granularity => 'ALL');
575:
576: l_partition_name := 'ATP_SUMMARY_SD__' || to_char(p_instance_id) ;
577:
578: msc_util.msc_log('Partition name for msc_atp_summary table sd part := ' || l_partition_name);

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

5075:
5076: msc_util.msc_log('after inserting item data into MSC_ALLOC_SUPPLIES tables');
5077:
5078: msc_util.msc_log('Analyze Plan partition for MSC_ALLOC_DEMANDS');
5079: fnd_stats.gather_table_stats(ownname=>l_msc_schema,tabname=>'MSC_ALLOC_DEMANDS',
5080: partname=>'ALLOC_DEMANDS_999999',
5081: granularity=>'PARTITION',
5082: percent =>10);
5083:

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

5081: granularity=>'PARTITION',
5082: percent =>10);
5083:
5084: msc_util.msc_log('Analyze Plan partition for MSC_ALLOC_SUPPLIES');
5085: fnd_stats.gather_table_stats(ownname=>l_msc_schema,tabname=>'MSC_ALLOC_SUPPLIES',
5086: partname=>'ALLOC_SUPPLIES_999999',
5087: granularity=>'PARTITION',
5088: percent =>10);
5089: ELSE

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

6122: msc_util.msc_log('After index : ' || l_temp_table || '.' || l_temp_table || '_N3');
6123:
6124: msc_util.msc_log('Gather Table Stats for Allocated S/D Tables');
6125:
6126: fnd_stats.gather_table_stats(l_msc_schema, 'MSC_TEMP_ALLOC_DEM_' || to_char(l_plan_id), granularity => 'ALL');
6127: fnd_stats.gather_table_stats(l_msc_schema, 'MSC_TEMP_ALLOC_SUP_' || to_char(l_plan_id), granularity => 'ALL');
6128:
6129: msc_util.msc_log('swap partition for demands');
6130: l_partition_name := 'ALLOC_DEMANDS_' || to_char(l_plan_id);

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

6123:
6124: msc_util.msc_log('Gather Table Stats for Allocated S/D Tables');
6125:
6126: fnd_stats.gather_table_stats(l_msc_schema, 'MSC_TEMP_ALLOC_DEM_' || to_char(l_plan_id), granularity => 'ALL');
6127: fnd_stats.gather_table_stats(l_msc_schema, 'MSC_TEMP_ALLOC_SUP_' || to_char(l_plan_id), granularity => 'ALL');
6128:
6129: msc_util.msc_log('swap partition for demands');
6130: l_partition_name := 'ALLOC_DEMANDS_' || to_char(l_plan_id);
6131:

Line 8884: fnd_stats.gather_table_stats(ownname=>l_msc_schema,

8880: ELSE
8881: l_partition_name := 'ATP_SUMMARY_SD_' || to_char(p_plan_id);
8882: END IF;
8883:
8884: fnd_stats.gather_table_stats(ownname=>l_msc_schema,
8885: tabname=>'MSC_ATP_SUMMARY_SD',
8886: partname=>l_partition_name,
8887: granularity=>'PARTITION',
8888: percent =>10);

Line 8898: fnd_stats.gather_table_stats(ownname=>l_msc_schema,

8894: ELSE
8895: l_partition_name := 'ATP_SUMMARY_SUP_' || to_char(p_plan_id);
8896: END IF;
8897:
8898: fnd_stats.gather_table_stats(ownname=>l_msc_schema,
8899: tabname=>'MSC_ATP_SUMMARY_SUP',
8900: partname=>l_partition_name,
8901: granularity=>'PARTITION',
8902: percent =>10);

Line 8912: fnd_stats.gather_table_stats(ownname=>l_msc_schema,

8908: ELSE
8909: l_partition_name := 'ATP_SUMMARY_RES_' || to_char(p_plan_id);
8910: END IF;
8911:
8912: fnd_stats.gather_table_stats(ownname=>l_msc_schema,
8913: tabname=>'MSC_ATP_SUMMARY_RES',
8914: partname=>l_partition_name,
8915: granularity=>'PARTITION',
8916: percent =>10);