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_CONC_UTIL_PKG dependencies on WSH_NEW_DELIVERIES

Line 298: FROM WSH_NEW_DELIVERIES

294:
295: CURSOR c_current_dels(x_ship_method_code IN VARCHAR2,
296: x_carrier_id IN NUMBER) IS
297: SELECT delivery_id
298: FROM WSH_NEW_DELIVERIES
299: WHERE status_code IN ('OP', 'CO', 'SA', 'SR', 'SC')
300: AND ship_method_code = x_ship_method_code
301: AND carrier_id = x_carrier_id
302: AND mode_of_transport IS NULL

Line 323: FROM WSH_NEW_DELIVERIES

319: FOR UPDATE NOWAIT;
320:
321: CURSOR c_lock_del(x_id IN NUMBER) IS
322: SELECT delivery_id
323: FROM WSH_NEW_DELIVERIES
324: WHERE delivery_id = x_id
325: FOR UPDATE NOWAIT;
326:
327: CURSOR c_lock_detail(x_id IN NUMBER) IS

Line 458: UPDATE WSH_NEW_DELIVERIES

454: AND ship_method_code = p_ship_method_code
455: AND carrier_id = p_carrier_id;
456: ELSIF p_entity = G_ENTITY_DEL THEN
457: FORALL i IN 1 .. l_update_index
458: UPDATE WSH_NEW_DELIVERIES
459: SET service_level = p_service_level,
460: mode_of_transport = p_mode_of_transport,
461: last_updated_by = l_user_id,
462: last_update_date = sysdate,