DBA Data[Home] [Help]

APPS.WSH_INBOUND_UTIL_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 1452: UPDATE wsh_delivery_assignments_v

1448: --
1449: -- Assign input lines to new delivery.
1450: --
1451: FORALL i IN p_delivery_detail_id_tbl.FIRST..p_delivery_detail_id_tbl.LAST
1452: UPDATE wsh_delivery_assignments_v
1453: SET delivery_id = l_delivery_id,
1454: last_update_date = SYSDATE,
1455: last_updated_by = FND_GLOBAL.USER_ID,
1456: last_update_login = FND_GLOBAL.LOGIN_ID

Line 3412: wsh_delivery_assignments_v wda

3408:
3409: CURSOR get_routing_response IS
3410: SELECT wnd.routing_response_id
3411: FROM wsh_new_deliveries wnd,
3412: wsh_delivery_assignments_v wda
3413: WHERE wnd.delivery_id = wda.delivery_id
3414: AND wda.delivery_detail_id = p_delivery_detail_id
3415: AND wnd.routing_response_id IS NOT NULL;
3416: