DBA Data[Home] [Help]

APPS.EGO_ITEM_PVT dependencies on MTL_SYSTEM_ITEMS_TL

Line 2142: UPDATE MTL_SYSTEM_ITEMS_TL ASSIGNEE

2138: SELECT MASTER_ORGANIZATION_ID INTO l_master_org
2139: FROM mtl_parameters
2140: WHERE ORGANIZATION_ID = l_Item_rec_in.ORGANIZATION_ID;
2141:
2142: UPDATE MTL_SYSTEM_ITEMS_TL ASSIGNEE
2143: SET (ASSIGNEE.DESCRIPTION, ASSIGNEE.LONG_DESCRIPTION, ASSIGNEE.SOURCE_LANG)
2144: = (SELECT DESCRIPTION, LONG_DESCRIPTION, SOURCE_LANG
2145: FROM MTL_SYSTEM_ITEMS_TL MASTER
2146: WHERE INVENTORY_ITEM_ID = l_Item_rec_in.INVENTORY_ITEM_ID

Line 2145: FROM MTL_SYSTEM_ITEMS_TL MASTER

2141:
2142: UPDATE MTL_SYSTEM_ITEMS_TL ASSIGNEE
2143: SET (ASSIGNEE.DESCRIPTION, ASSIGNEE.LONG_DESCRIPTION, ASSIGNEE.SOURCE_LANG)
2144: = (SELECT DESCRIPTION, LONG_DESCRIPTION, SOURCE_LANG
2145: FROM MTL_SYSTEM_ITEMS_TL MASTER
2146: WHERE INVENTORY_ITEM_ID = l_Item_rec_in.INVENTORY_ITEM_ID
2147: AND ORGANIZATION_ID =L_MASTER_ORG
2148: AND MASTER."LANGUAGE" = ASSIGNEE."LANGUAGE")
2149: WHERE INVENTORY_ITEM_ID = l_Item_rec_in.INVENTORY_ITEM_ID