APPS.OPI_DBI_OPM_COGS_PKG dependencies on FND_STATS

Line 345: fnd_stats.gather_table_stats( ownname => g_opi_schema,

341: ,TURNS_COGS_FLAG
342: ,SOURCE ;
343:
344: commit;
345: fnd_stats.gather_table_stats( ownname => g_opi_schema,
346: tabname => 'OPI_DBI_OPM_COGSTST_CURRENT',
347: percent => 10);
348:
349:

Line 484: fnd_stats.gather_table_stats( ownname => g_opi_schema,

480: ,TURNS_COGS_FLAG
481: ,SOURCE ;
482:
483: commit;
484: fnd_stats.gather_table_stats( ownname => g_opi_schema,
485: tabname => 'OPI_DBI_OPM_COGSLED_CURRENT',
486: percent => 10);
487:
488:

Line 591: fnd_stats.gather_table_stats( ownname => g_opi_schema,

587: execute immediate 'truncate table ' || g_opi_schema
588: || '.opi_dbi_opm_cogstst_prior ';
589:
590: commit;
591: fnd_stats.gather_table_stats( ownname => g_opi_schema,
592: tabname => 'OPI_DBI_COGS_STG',
593: percent => 10);
594:
595:

Line 626: fnd_stats.gather_table_stats( ownname => g_opi_schema,

622: ,SOURCE
623: from opi_dbi_opm_cogstst_current;
624:
625: commit;
626: fnd_stats.gather_table_stats( ownname => g_opi_schema,
627: tabname => 'OPI_DBI_OPM_COGSTST_PRIOR',
628: percent => 10);
629:
630:

Line 917: fnd_stats.gather_table_stats( ownname => g_opi_schema,

913: -- execute immediate 'alter session disable parallel query';
914:
915: commit;
916:
917: fnd_stats.gather_table_stats( ownname => g_opi_schema,
918: tabname => 'OPI_DBI_OPM_COGSTST_CURRENT',
919: percent => 10);
920:
921: -- execute immediate 'alter session force parallel query parallel '||p_degree ;

Line 1092: fnd_stats.gather_table_stats( ownname => g_opi_schema,

1088:
1089: -- execute immediate 'alter session disable parallel query';
1090:
1091: commit;
1092: fnd_stats.gather_table_stats( ownname => g_opi_schema,
1093: tabname => 'OPI_DBI_OPM_COGSLED_CURRENT',
1094: percent => 10);
1095:
1096:

Line 1202: fnd_stats.gather_table_stats( ownname => g_opi_schema,

1198:
1199: execute immediate 'truncate table ' || g_opi_schema
1200: || '.opi_dbi_opm_cogstst_prior ';
1201:
1202: fnd_stats.gather_table_stats( ownname => g_opi_schema,
1203: tabname => 'OPI_DBI_COGS_STG',
1204: percent => 10);
1205:
1206:

Line 1244: fnd_stats.gather_table_stats( ownname => g_opi_schema,

1240:
1241: commit;
1242:
1243:
1244: fnd_stats.gather_table_stats( ownname => g_opi_schema,
1245: tabname => 'OPI_DBI_OPM_COGSTST_PRIOR',
1246: percent => 10);
1247:
1248: