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.

APPS.INV_ITEM_API dependencies on MTL_SYSTEM_ITEMS_TL

Line 474: MTL_SYSTEM_ITEMS_TL

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

Line 1024: UPDATE MTL_SYSTEM_ITEMS_TL

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

Line 1061: UPDATE MTL_SYSTEM_ITEMS_TL

1057: BEGIN
1058:
1059: -- Update translated item row at Item_TL_csr cursor position
1060: --
1061: UPDATE MTL_SYSTEM_ITEMS_TL
1062: SET
1063: DESCRIPTION = p_Item_TL_rec.DESCRIPTION
1064: , LONG_DESCRIPTION = p_Item_TL_rec.LONG_DESCRIPTION
1065: , LAST_UPDATE_DATE = p_Item_TL_rec.LAST_UPDATE_DATE