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.WSH_UTIL dependencies on MTL_ITEM_LOCATIONS

Line 395: FROM mtl_item_locations

391: subinventory IN VARCHAR2)
392: RETURN BOOLEAN IS
393: CURSOR c1 ( x_org_id NUMBER, x_loc_id NUMBER, x_subinv VARCHAR2) IS
394: SELECT 'Exist'
395: FROM mtl_item_locations
396: WHERE organization_id = x_org_id
397: AND inventory_location_id = x_loc_id
398: AND subinventory_code IS NOT NULL
399: AND subinventory_code <> x_subinv;

Line 423: UPDATE mtl_item_locations a

419:
420: x_org_id := organization_id;
421: x_loc_id := locator_id;
422:
423: UPDATE mtl_item_locations a
424: SET a.subinventory_code = subinventory
425: WHERE a.organization_id = x_org_id
426: AND a.inventory_location_id = x_loc_id;
427: