308: IF (l_records > 50)
309: AND FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_schema)
310: THEN
311: IF l_schema IS NOT NULL THEN
312: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_SYSTEM_ITEMS_INTERFACE');
313: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_REVISIONS_INTERFACE');
314: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_DESC_ELEM_VAL_INTERFACE');
315: END IF;
316: END IF;
309: AND FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_schema)
310: THEN
311: IF l_schema IS NOT NULL THEN
312: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_SYSTEM_ITEMS_INTERFACE');
313: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_REVISIONS_INTERFACE');
314: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_DESC_ELEM_VAL_INTERFACE');
315: END IF;
316: END IF;
317:
310: THEN
311: IF l_schema IS NOT NULL THEN
312: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_SYSTEM_ITEMS_INTERFACE');
313: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_REVISIONS_INTERFACE');
314: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_DESC_ELEM_VAL_INTERFACE');
315: END IF;
316: END IF;
317:
318: IF l_inv_debug_level IN(101, 102) THEN