DBA Data[Home] [Help]

APPS.ISC_DBI_WSH_FTE_OBJECTS_C dependencies on FND_STATS

Line 677: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

673: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount || ' rows into ISC_DBI_TMP_WDD_LOG');
674:
675: COMMIT;
676:
677: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
678: TABNAME => 'ISC_DBI_TMP_WDD_LOG');
679:
680: BIS_COLLECTION_UTILITIES.put_line('Deleting obsolete records from the base summary');
681: FII_UTIL.Start_Timer;

Line 792: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

788: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount || ' rows into ISC_DBI_TMP_WTS_LOG');
789:
790: COMMIT;
791:
792: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
793: TABNAME => 'ISC_DBI_TMP_WTS_LOG');
794:
795: BIS_COLLECTION_UTILITIES.put_line('Deleting obsolete records from the base summary');
796: FII_UTIL.Start_Timer;

Line 1053: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

1049: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount || ' rows into ISC_DBI_TMP_FIH_LOG');
1050:
1051: COMMIT;
1052:
1053: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
1054: TABNAME => 'ISC_DBI_TMP_FIH_LOG');
1055:
1056: BIS_COLLECTION_UTILITIES.put_line('Deleting obsolete records from the base summary');
1057: FII_UTIL.Start_Timer;

Line 3241: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

3237: BIS_COLLECTION_UTILITIES.Put_Line(' ');
3238: BIS_COLLECTION_UTILITIES.Put_Line('Analyzing temp tables');
3239: FII_UTIL.Start_Timer;
3240:
3241: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3242: TABNAME => 'ISC_DBI_TMP_DEL_DETAILS');
3243: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3244: TABNAME => 'ISC_DBI_TMP_DEL_LEGS');
3245: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

Line 3243: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

3239: FII_UTIL.Start_Timer;
3240:
3241: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3242: TABNAME => 'ISC_DBI_TMP_DEL_DETAILS');
3243: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3244: TABNAME => 'ISC_DBI_TMP_DEL_LEGS');
3245: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3246: TABNAME => 'ISC_DBI_TMP_TRIP_STOPS');
3247: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

Line 3245: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

3241: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3242: TABNAME => 'ISC_DBI_TMP_DEL_DETAILS');
3243: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3244: TABNAME => 'ISC_DBI_TMP_DEL_LEGS');
3245: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3246: TABNAME => 'ISC_DBI_TMP_TRIP_STOPS');
3247: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3248: TABNAME => 'ISC_DBI_TMP_FTE_INVOICES');
3249: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

Line 3247: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

3243: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3244: TABNAME => 'ISC_DBI_TMP_DEL_LEGS');
3245: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3246: TABNAME => 'ISC_DBI_TMP_TRIP_STOPS');
3247: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3248: TABNAME => 'ISC_DBI_TMP_FTE_INVOICES');
3249: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3250: TABNAME => 'ISC_DBI_FTE_CURR_RATES');
3251: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

Line 3249: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

3245: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3246: TABNAME => 'ISC_DBI_TMP_TRIP_STOPS');
3247: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3248: TABNAME => 'ISC_DBI_TMP_FTE_INVOICES');
3249: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3250: TABNAME => 'ISC_DBI_FTE_CURR_RATES');
3251: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3252: TABNAME => 'ISC_DBI_FTE_UOM_RATES');
3253:

Line 3251: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

3247: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3248: TABNAME => 'ISC_DBI_TMP_FTE_INVOICES');
3249: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3250: TABNAME => 'ISC_DBI_FTE_CURR_RATES');
3251: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3252: TABNAME => 'ISC_DBI_FTE_UOM_RATES');
3253:
3254: FII_UTIL.Stop_Timer;
3255: FII_UTIL.Print_Timer('Analyzed the temp tables in ');

Line 3392: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

3388: BIS_COLLECTION_UTILITIES.Put_Line(' ');
3389: BIS_COLLECTION_UTILITIES.Put_Line('Analyzing temp tables');
3390: FII_UTIL.Start_Timer;
3391:
3392: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3393: TABNAME => 'ISC_DBI_TMP_DEL_DETAILS');
3394:
3395: FII_UTIL.Stop_Timer;
3396: FII_UTIL.Print_Timer('Analyzed the temp tables in ');

Line 3546: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

3542: BIS_COLLECTION_UTILITIES.Put_Line(' ');
3543: BIS_COLLECTION_UTILITIES.Put_Line('Analyzing temp tables');
3544: FII_UTIL.Start_Timer;
3545:
3546: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3547: TABNAME => 'ISC_DBI_TMP_DEL_LEGS');
3548: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3549: TABNAME => 'ISC_DBI_TMP_TRIP_STOPS');
3550: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

Line 3548: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

3544: FII_UTIL.Start_Timer;
3545:
3546: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3547: TABNAME => 'ISC_DBI_TMP_DEL_LEGS');
3548: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3549: TABNAME => 'ISC_DBI_TMP_TRIP_STOPS');
3550: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3551: TABNAME => 'ISC_DBI_FTE_CURR_RATES');
3552: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

Line 3550: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

3546: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3547: TABNAME => 'ISC_DBI_TMP_DEL_LEGS');
3548: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3549: TABNAME => 'ISC_DBI_TMP_TRIP_STOPS');
3550: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3551: TABNAME => 'ISC_DBI_FTE_CURR_RATES');
3552: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3553: TABNAME => 'ISC_DBI_FTE_UOM_RATES');
3554:

Line 3552: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

3548: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3549: TABNAME => 'ISC_DBI_TMP_TRIP_STOPS');
3550: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3551: TABNAME => 'ISC_DBI_FTE_CURR_RATES');
3552: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3553: TABNAME => 'ISC_DBI_FTE_UOM_RATES');
3554:
3555: FII_UTIL.Stop_Timer;
3556: FII_UTIL.Print_Timer('Analyzed the temp tables in ');

Line 3698: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

3694: BIS_COLLECTION_UTILITIES.Put_Line(' ');
3695: BIS_COLLECTION_UTILITIES.Put_Line('Analyzing temp tables');
3696: FII_UTIL.Start_Timer;
3697:
3698: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3699: TABNAME => 'ISC_DBI_TMP_FTE_INVOICES');
3700: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3701: TABNAME => 'ISC_DBI_FTE_CURR_RATES');
3702:

Line 3700: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,

3696: FII_UTIL.Start_Timer;
3697:
3698: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3699: TABNAME => 'ISC_DBI_TMP_FTE_INVOICES');
3700: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
3701: TABNAME => 'ISC_DBI_FTE_CURR_RATES');
3702:
3703: FII_UTIL.Stop_Timer;
3704: FII_UTIL.Print_Timer('Analyzed the temp tables in ');