DBA Data[Home] [Help]

APPS.INVPOPIF dependencies on FND_STATS

Line 366: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_SYSTEM_ITEMS_INTERFACE');

362: As mentioned in the note 1208945.1 and suggested by performance team,
363: for any performance issues we need to gather stats manualy so no need to gather stats in the code.
364: */
365: /*
366: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_SYSTEM_ITEMS_INTERFACE');
367: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_REVISIONS_INTERFACE');
368: */
369: -- Bug 12669091 : End
370: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_DESC_ELEM_VAL_INTERFACE');

Line 367: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_REVISIONS_INTERFACE');

363: for any performance issues we need to gather stats manualy so no need to gather stats in the code.
364: */
365: /*
366: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_SYSTEM_ITEMS_INTERFACE');
367: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_REVISIONS_INTERFACE');
368: */
369: -- Bug 12669091 : End
370: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_DESC_ELEM_VAL_INTERFACE');
371: END IF;

Line 370: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_DESC_ELEM_VAL_INTERFACE');

366: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_SYSTEM_ITEMS_INTERFACE');
367: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_REVISIONS_INTERFACE');
368: */
369: -- Bug 12669091 : End
370: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_DESC_ELEM_VAL_INTERFACE');
371: END IF;
372: END IF;
373:
374: IF l_inv_debug_level IN(101, 102) THEN