DBA Data[Home] [Help]

APPS.EGO_ITEM_PUB dependencies on EGO_MTL_SY_ITEMS_EXT_TL

Line 3609: DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID

3605: IF (P_ITEM_CATALOG_GROUP_ID IS NULL) THEN --delete query changed by absinha for Bug 3542129
3606: DELETE FROM EGO_MTL_SY_ITEMS_EXT_B WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3607: AND ATTR_GROUP_ID NOT IN (SELECT ATTR_GROUP_ID FROM EGO_ATTR_GROUPS_V WHERE APPLICATION_ID = 431
3608: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP' AND (ATTR_GROUP_NAME = 'ItemDetailDesc' OR ATTR_GROUP_NAME = 'ItemDetailImage'));
3609: DELETE FROM EGO_MTL_SY_ITEMS_EXT_TL WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3610: AND ATTR_GROUP_ID NOT IN (SELECT ATTR_GROUP_ID FROM EGO_ATTR_GROUPS_V WHERE APPLICATION_ID = 431
3611: AND ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP' AND (ATTR_GROUP_NAME = 'ItemDetailDesc' OR ATTR_GROUP_NAME = 'ItemDetailImage'));
3612: ELSE
3613: UPDATE EGO_MTL_SY_ITEMS_EXT_B

Line 3617: UPDATE EGO_MTL_SY_ITEMS_EXT_TL

3613: UPDATE EGO_MTL_SY_ITEMS_EXT_B
3614: SET ITEM_CATALOG_GROUP_ID = P_ITEM_CATALOG_GROUP_ID
3615: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
3616:
3617: UPDATE EGO_MTL_SY_ITEMS_EXT_TL
3618: SET ITEM_CATALOG_GROUP_ID = P_ITEM_CATALOG_GROUP_ID
3619: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
3620: END IF;
3621: