APPS.MSC_POST_PRO dependencies on FND_STATS

Line 539: fnd_stats.gather_table_stats('MSC', '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('MSC', '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('MSC', '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('MSC', '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=>'MSC',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=>'MSC',tabname=>'MSC_ALLOC_DEMANDS',
5080: partname=>'ALLOC_DEMANDS_999999',
5081: granularity=>'PARTITION',
5082: percent =>10);
5083:

Line 5085: fnd_stats.gather_table_stats(ownname=>'MSC',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=>'MSC',tabname=>'MSC_ALLOC_SUPPLIES',
5086: partname=>'ALLOC_SUPPLIES_999999',
5087: granularity=>'PARTITION',
5088: percent =>10);
5089: ELSE

Line 6126: fnd_stats.gather_table_stats('MSC', '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('MSC', 'MSC_TEMP_ALLOC_DEM_' || to_char(l_plan_id), granularity => 'ALL');
6127: fnd_stats.gather_table_stats('MSC', '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('MSC', '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('MSC', 'MSC_TEMP_ALLOC_DEM_' || to_char(l_plan_id), granularity => 'ALL');
6127: fnd_stats.gather_table_stats('MSC', '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 8846: fnd_stats.gather_table_stats(ownname=>'MSC',

8842: ELSE
8843: l_partition_name := 'ATP_SUMMARY_SD_' || to_char(p_plan_id);
8844: END IF;
8845:
8846: fnd_stats.gather_table_stats(ownname=>'MSC',
8847: tabname=>'MSC_ATP_SUMMARY_SD',
8848: partname=>l_partition_name,
8849: granularity=>'PARTITION',
8850: percent =>10);

Line 8860: fnd_stats.gather_table_stats(ownname=>'MSC',

8856: ELSE
8857: l_partition_name := 'ATP_SUMMARY_SUP_' || to_char(p_plan_id);
8858: END IF;
8859:
8860: fnd_stats.gather_table_stats(ownname=>'MSC',
8861: tabname=>'MSC_ATP_SUMMARY_SUP',
8862: partname=>l_partition_name,
8863: granularity=>'PARTITION',
8864: percent =>10);

Line 8874: fnd_stats.gather_table_stats(ownname=>'MSC',

8870: ELSE
8871: l_partition_name := 'ATP_SUMMARY_RES_' || to_char(p_plan_id);
8872: END IF;
8873:
8874: fnd_stats.gather_table_stats(ownname=>'MSC',
8875: tabname=>'MSC_ATP_SUMMARY_RES',
8876: partname=>l_partition_name,
8877: granularity=>'PARTITION',
8878: percent =>10);