APPS.EGO_ITEM_PUB dependencies on EGO_MTL_SY_ITEMS_EXT_TL

Line 3862: DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID

3858: IF (P_ITEM_CATALOG_GROUP_ID IS NULL) THEN --delete query changed by absinha for Bug 3542129
3859: DELETE FROM EGO_MTL_SY_ITEMS_EXT_B WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3860: AND ATTR_GROUP_ID NOT IN (SELECT ATTR_GROUP_ID FROM EGO_ATTR_GROUPS_V WHERE APPLICATION_ID = 431
3861: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP' AND (ATTR_GROUP_NAME = 'ItemDetailDesc' OR ATTR_GROUP_NAME = 'ItemDetailImage'));
3862: DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3863: AND ATTR_GROUP_ID NOT IN (SELECT ATTR_GROUP_ID FROM EGO_ATTR_GROUPS_V WHERE APPLICATION_ID = 431
3864: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP' AND (ATTR_GROUP_NAME = 'ItemDetailDesc' OR ATTR_GROUP_NAME = 'ItemDetailImage'));
3865: ELSE
3866: UPDATE EGO_MTL_SY_ITEMS_EXT_B

Line 3870: UPDATE EGO_MTL_SY_ITEMS_EXT_TL

3866: UPDATE EGO_MTL_SY_ITEMS_EXT_B
3867: SET ITEM_CATALOG_GROUP_ID = P_ITEM_CATALOG_GROUP_ID
3868: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
3869:
3870: UPDATE EGO_MTL_SY_ITEMS_EXT_TL
3871: SET ITEM_CATALOG_GROUP_ID = P_ITEM_CATALOG_GROUP_ID
3872: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
3873: END IF;
3874: