DBA Data[Home] [Help]

APPS.ISC_DBI_BOOK_SUM2_F_C dependencies on FND_STATS

Line 668: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,

664: COMMIT;
665:
666:
667: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_schema)) THEN
668: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
669: TABNAME => 'ISC_DBI_CHANGE_LOG');
670: END IF;
671:
672:

Line 706: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,

702: BIS_COLLECTION_UTILITIES.Put_Line(' ');
703: BIS_COLLECTION_UTILITIES.Put_Line('Analyzing table ISC_TMP_BOOK_SUM2');
704: FII_UTIL.Start_Timer;
705: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_schema)) THEN
706: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
707: TABNAME => 'ISC_TMP_BOOK_SUM2');
708: END IF;
709: FII_UTIL.Stop_Timer;
710: FII_UTIL.Print_Timer('Analyzed table ISC_TMP_BOOK_SUM2 in ');

Line 2436: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,

2432: BIS_COLLECTION_UTILITIES.Put_Line('Analyzing table ISC_TMP_BOOK_SUM2');
2433: FII_UTIL.Start_Timer;
2434:
2435: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_schema)) THEN
2436: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2437: TABNAME => 'ISC_TMP_BOOK_SUM2');
2438: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2439: TABNAME => 'ISC_CURR_BOOK_SUM2');
2440: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,

Line 2438: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,

2434:
2435: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_schema)) THEN
2436: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2437: TABNAME => 'ISC_TMP_BOOK_SUM2');
2438: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2439: TABNAME => 'ISC_CURR_BOOK_SUM2');
2440: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2441: TABNAME => 'ISC_SERVICE_BOOK_SUM2');
2442: END IF;

Line 2440: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,

2436: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2437: TABNAME => 'ISC_TMP_BOOK_SUM2');
2438: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2439: TABNAME => 'ISC_CURR_BOOK_SUM2');
2440: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2441: TABNAME => 'ISC_SERVICE_BOOK_SUM2');
2442: END IF;
2443:
2444: FII_UTIL.Stop_Timer;

Line 2616: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,

2612: BIS_COLLECTION_UTILITIES.Put_Line('Analyzing table ISC_TMP_BOOK_SUM2');
2613: FII_UTIL.Start_Timer;
2614:
2615: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_schema)) THEN
2616: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2617: TABNAME => 'ISC_TMP_BOOK_SUM2');
2618: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2619: TABNAME => 'ISC_CURR_BOOK_SUM2');
2620: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,

Line 2618: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,

2614:
2615: IF (FND_INSTALLATION.GET_APP_INFO('ISC', l_status, l_industry, l_schema)) THEN
2616: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2617: TABNAME => 'ISC_TMP_BOOK_SUM2');
2618: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2619: TABNAME => 'ISC_CURR_BOOK_SUM2');
2620: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2621: TABNAME => 'ISC_SERVICE_BOOK_SUM2');
2622: END IF;

Line 2620: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,

2616: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2617: TABNAME => 'ISC_TMP_BOOK_SUM2');
2618: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2619: TABNAME => 'ISC_CURR_BOOK_SUM2');
2620: FND_STATS.GATHER_TABLE_STATS(OWNNAME => l_schema,
2621: TABNAME => 'ISC_SERVICE_BOOK_SUM2');
2622: END IF;
2623:
2624: FII_UTIL.Stop_Timer;