DBA Data[Home] [Help]

APPS.INV_ITEM_CATEGORY_OI dependencies on FND_INSTALLATION

Line 367: IF l_records > nvl(fnd_profile.value('EGO_GATHER_STATS'),100) AND FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_schema) THEN

363: AND process_flag IN (1,2,4); --R12C
364:
365: -- Bug 6983407 Collect statistics only if the no. of records is bigger than the profile
366: -- option threshold
367: IF l_records > nvl(fnd_profile.value('EGO_GATHER_STATS'),100) AND FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_schema) THEN
368: IF l_schema IS NOT NULL THEN
369: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_CATEGORIES_INTERFACE');
370: END IF;
371: END IF;