[Home] [Help]
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
1471: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: calling INV_ITEM_CATALOG_ELEM_PUB.process_Item_Catalog_grp_recs');
1472: END IF;
1473:
1474: SELECT COUNT(1) INTO mtl_count
1475: FROM mtl_desc_elem_val_interface mdei
1476: WHERE mdei.set_process_id = xset_id
1477: AND mdei.process_flag IN (1, 2, 4);
1478:
1479: IF mtl_count > 0 THEN