DBA Data[Home] [Help]

APPS.WSH_TMS_RELEASE dependencies on WSH_DELIVERY_DETAILS

Line 3581: wsh_delivery_assignments wda, wsh_delivery_details wdd

3577: CURSOR c_lock_deliveries_and_details (c_drop_off_stop_id IN number) IS
3578: SELECT wnd.delivery_id, wdd.delivery_detail_id
3579: FROM wsh_new_deliveries wnd,
3580: wsh_delivery_legs wdl,
3581: wsh_delivery_assignments wda, wsh_delivery_details wdd
3582: WHERE wdl.drop_off_stop_id = c_drop_off_stop_id
3583: AND wdl.delivery_id = wnd.delivery_id
3584: AND WSH_UTIL_VALIDATE.CHECK_WMS_ORG(wnd.organization_id) = 'Y'
3585: AND wnd.delivery_id = wda.delivery_id

Line 3622: UPDATE wsh_delivery_details

3618: last_update_login = FND_GLOBAL.LOGIN_ID
3619: WHERE delivery_id = l_del_tab(i);
3620:
3621: FORALL i in l_del_det_tab.FIRST..l_del_det_tab.LAST
3622: UPDATE wsh_delivery_details
3623: SET load_seq_number = l_loading_sequence,
3624: last_update_date = SYSDATE,
3625: last_updated_by = FND_GLOBAL.USER_ID,
3626: last_update_login = FND_GLOBAL.LOGIN_ID