APPS.EGO_ITEM_PVT dependencies on EGO_MTL_SY_ITEMS_EXT_B

Line 1526: FROM ego_mtl_sy_items_ext_b

1522: IF (l_Item_rec_in.ITEM_CATALOG_GROUP_ID <> l_curr_icc_id
1523: AND l_Item_rec_in.ITEM_CATALOG_GROUP_ID <> G_MISS_NUM) THEN -- added condition for the bug 7422745
1524: -- Deleteing records for AGs that are not associated to the new ICC
1525: DELETE
1526: FROM ego_mtl_sy_items_ext_b
1527: WHERE inventory_item_id = l_Item_rec_in.INVENTORY_ITEM_ID
1528: AND attr_group_id NOT IN
1529: (SELECT ATTR_GROUP_ID
1530: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V AGV,

Line 2106: INSERT INTO EGO_MTL_SY_ITEMS_EXT_B

2102:
2103: ----------------------------------------------------------------------
2104: -- Insert a row for every newly created item in the interface table --
2105: ----------------------------------------------------------------------
2106: INSERT INTO EGO_MTL_SY_ITEMS_EXT_B
2107: (
2108: EXTENSION_ID
2109: ,ORGANIZATION_ID
2110: ,INVENTORY_ITEM_ID

Line 2175: ,EGO_MTL_SY_ITEMS_EXT_B EXT

2171: ,EXT.LAST_UPDATE_DATE
2172: ,NVL(M.MESSAGE_TEXT,'Long Description')
2173: ,43102 --Added for bug 6155995
2174: FROM MTL_SYSTEM_ITEMS_INTERFACE MTL
2175: ,EGO_MTL_SY_ITEMS_EXT_B EXT
2176: ,FND_LANGUAGES L
2177: ,FND_NEW_MESSAGES M
2178: WHERE MTL.SET_PROCESS_ID = p_set_process_id
2179: AND MTL.PROCESS_FLAG = 4