DBA Data[Home] [Help]

APPS.INVPOPIF dependencies on MTL_DESC_ELEM_VAL_INTERFACE

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

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

Line 1284: FROM mtl_desc_elem_val_interface mdei

1280: INVPUTLI.info('INVPOPIF.inopinp_open_interface_process: calling INV_ITEM_CATALOG_ELEM_PUB.process_Item_Catalog_grp_recs');
1281: END IF;
1282:
1283: SELECT COUNT(1) INTO mtl_count
1284: FROM mtl_desc_elem_val_interface mdei
1285: WHERE mdei.set_process_id = xset_id
1286: AND mdei.process_flag IN (1, 2, 4);
1287:
1288: IF mtl_count > 0 THEN