DBA Data[Home] [Help]

APPS.MSC_MANAGE_PLAN_PARTITIONS dependencies on FND_STATS

Line 1446: fnd_stats.gather_table_stats(ownname=>'MSC',tabname=>cur_table,

1442: ,'MSC_DELIVERY_DETAILS','MSC_REGIONS','MSC_REGION_LOCATIONS','MSC_ZONE_REGIONS')) then
1443:
1444: msc_util.msc_debug('analyzing partition '||l_partition_name);
1445: IF v_analyze_plan_scope = 2 THEN
1446: fnd_stats.gather_table_stats(ownname=>'MSC',tabname=>cur_table,
1447: partname=>l_partition_name,
1448: granularity=>'PARTITION',
1449: percent =>10,degree=>4);
1450: ELSE

Line 1451: fnd_stats.gather_table_stats(ownname=>'MSC',tabname=>cur_table,

1447: partname=>l_partition_name,
1448: granularity=>'PARTITION',
1449: percent =>10,degree=>4);
1450: ELSE
1451: fnd_stats.gather_table_stats(ownname=>'MSC',tabname=>cur_table,
1452: partname=>l_partition_name,
1453: granularity=>'ALL',
1454: percent =>10,degree=>4);
1455: END IF;