eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.INV_ITEM_API dependencies on MTL_SYSTEM_ITEMS_TL

Line 476: MTL_SYSTEM_ITEMS_TL

472: , LAST_UPDATE_DATE
473: , LAST_UPDATED_BY
474: , LAST_UPDATE_LOGIN
475: FROM
476: MTL_SYSTEM_ITEMS_TL
477: WHERE
478: INVENTORY_ITEM_ID = p_Item_ID
479: AND ( ( p_fetch_Master = g_TRUE AND ORGANIZATION_ID = p_Org_ID ) OR
480: ( p_fetch_Orgs = g_TRUE AND

Line 1028: UPDATE MTL_SYSTEM_ITEMS_TL

1024: BEGIN -- Update block
1025:
1026: -- Do not validate Item and Org IDs since p_Item_rec is fetched
1027:
1028: UPDATE MTL_SYSTEM_ITEMS_TL
1029: SET
1030: DESCRIPTION = NVL(trim(p_Item_rec.DESCRIPTION),DESCRIPTION) --Bug 4416173
1031: , LONG_DESCRIPTION = trim(p_Item_rec.LONG_DESCRIPTION)
1032: , LAST_UPDATE_DATE = p_Item_rec.LAST_UPDATE_DATE

Line 1066: UPDATE MTL_SYSTEM_ITEMS_TL

1062: BEGIN
1063:
1064: -- Update translated item row at Item_TL_csr cursor position
1065: --
1066: UPDATE MTL_SYSTEM_ITEMS_TL
1067: SET
1068: DESCRIPTION = p_Item_TL_rec.DESCRIPTION
1069: , LONG_DESCRIPTION = p_Item_TL_rec.LONG_DESCRIPTION
1070: , LAST_UPDATE_DATE = p_Item_TL_rec.LAST_UPDATE_DATE