DBA Data[Home] [Help]

APPS.MSC_MANAGE_PLAN_PARTITIONS dependencies on FND_STATS

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

1496: ,'MSC_DELIVERY_DETAILS','MSC_REGIONS','MSC_REGION_LOCATIONS','MSC_ZONE_REGIONS')) then
1497:
1498: msc_util.msc_debug('analyzing partition '||l_partition_name);
1499: IF v_analyze_plan_scope = 2 THEN
1500: fnd_stats.gather_table_stats(ownname=>'MSC',tabname=>cur_table,
1501: partname=>l_partition_name,
1502: granularity=>'PARTITION',
1503: percent =>10,degree=>4);
1504: ELSE

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

1501: partname=>l_partition_name,
1502: granularity=>'PARTITION',
1503: percent =>10,degree=>4);
1504: ELSE
1505: fnd_stats.gather_table_stats(ownname=>'MSC',tabname=>cur_table,
1506: partname=>l_partition_name,
1507: granularity=>'ALL',
1508: percent =>10,degree=>4);
1509: END IF;