APPS.WSH_TMS_RELEASE dependencies on WSH_DELIVERY_DETAILS

Line 3573: wsh_delivery_assignments wda, wsh_delivery_details wdd

3569: CURSOR c_lock_deliveries_and_details (c_drop_off_stop_id IN number) IS
3570: SELECT wnd.delivery_id, wdd.delivery_detail_id
3571: FROM wsh_new_deliveries wnd,
3572: wsh_delivery_legs wdl,
3573: wsh_delivery_assignments wda, wsh_delivery_details wdd
3574: WHERE wdl.drop_off_stop_id = c_drop_off_stop_id
3575: AND wdl.delivery_id = wnd.delivery_id
3576: AND WSH_UTIL_VALIDATE.CHECK_WMS_ORG(wnd.organization_id) = 'Y'
3577: AND wnd.delivery_id = wda.delivery_id

Line 3614: UPDATE wsh_delivery_details

3610: last_update_login = FND_GLOBAL.LOGIN_ID
3611: WHERE delivery_id = l_del_tab(i);
3612:
3613: FORALL i in l_del_det_tab.FIRST..l_del_det_tab.LAST
3614: UPDATE wsh_delivery_details
3615: SET load_seq_number = l_loading_sequence,
3616: last_update_date = SYSDATE,
3617: last_updated_by = FND_GLOBAL.USER_ID,
3618: last_update_login = FND_GLOBAL.LOGIN_ID