DBA Data[Home] [Help]

APPS.EGO_ITEM_PVT dependencies on MTL_SYSTEM_ITEMS_TL

Line 1916: UPDATE MTL_SYSTEM_ITEMS_TL ASSIGNEE

1912: SELECT MASTER_ORGANIZATION_ID INTO l_master_org
1913: FROM mtl_parameters
1914: WHERE ORGANIZATION_ID = l_Item_rec_in.ORGANIZATION_ID;
1915:
1916: UPDATE MTL_SYSTEM_ITEMS_TL ASSIGNEE
1917: SET (ASSIGNEE.DESCRIPTION, ASSIGNEE.LONG_DESCRIPTION, ASSIGNEE.SOURCE_LANG)
1918: = (SELECT DESCRIPTION, LONG_DESCRIPTION, SOURCE_LANG
1919: FROM MTL_SYSTEM_ITEMS_TL MASTER
1920: WHERE INVENTORY_ITEM_ID = l_Item_rec_in.INVENTORY_ITEM_ID

Line 1919: FROM MTL_SYSTEM_ITEMS_TL MASTER

1915:
1916: UPDATE MTL_SYSTEM_ITEMS_TL ASSIGNEE
1917: SET (ASSIGNEE.DESCRIPTION, ASSIGNEE.LONG_DESCRIPTION, ASSIGNEE.SOURCE_LANG)
1918: = (SELECT DESCRIPTION, LONG_DESCRIPTION, SOURCE_LANG
1919: FROM MTL_SYSTEM_ITEMS_TL MASTER
1920: WHERE INVENTORY_ITEM_ID = l_Item_rec_in.INVENTORY_ITEM_ID
1921: AND ORGANIZATION_ID =L_MASTER_ORG
1922: AND MASTER."LANGUAGE" = ASSIGNEE."LANGUAGE")
1923: WHERE INVENTORY_ITEM_ID = l_Item_rec_in.INVENTORY_ITEM_ID