DBA Data[Home] [Help]

APPS.MSC_ATP_PEG dependencies on FND_STATS

Line 4392: fnd_stats.gather_table_stats(ownname=>l_msc_schema,tabname=>'MSC_ATP_PEGGING',

4388:
4389: IF PG_DEBUG in ('Y', 'C') THEN
4390: msc_util.msc_log('Analyze Plan partition for MSC_ATP_PEGGING');
4391: END IF;
4392: fnd_stats.gather_table_stats(ownname=>l_msc_schema,tabname=>'MSC_ATP_PEGGING',
4393: partname=>'ATP_PEGGING_999999',
4394: granularity=>'PARTITION',
4395: percent =>10);
4396:

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

4497: IF PG_DEBUG in ('Y', 'C') THEN
4498: msc_util.msc_log('Gather Table Stats for MSC_ATP_PEGGING');
4499: END IF;
4500: --13021736 corrected the syntax.
4501: fnd_stats.gather_table_stats(ownname => l_msc_schema,
4502: tabname => 'MSC_ATP_PEGGING',
4503: partname => 'ATP_PEGGING_' || to_char(l_plan_id),
4504: granularity => 'ALL'
4505: );