APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on WSH_TRIP_STOPS

Line 3397: wsh_trip_stops wts

3393: FROM wsh_delivery_assignments wda,
3394: wsh_delivery_details wdd,
3395: wsh_new_deliveries wnd,
3396: wsh_delivery_legs wdl,
3397: wsh_trip_stops wts
3398: WHERE wts.stop_id (+) = wdl.drop_off_stop_id
3399: AND wdl.delivery_id (+) = wnd.delivery_id
3400: AND nvl(wnd.status_code, 'OP') = 'OP'
3401: AND wnd.delivery_id (+) = wda.delivery_id

Line 3480: Wsh_trip_stops wts,

3476: SELECT wdl.rowid, tmp.rowid, wnd.delivery_id, wdl.delivery_leg_id, wts.trip_id,
3477: wts.stop_id, wnd.gross_weight, wnd.net_weight, wnd.volume
3478: FROM wsh_delivery_legs wdl,
3479: wsh_new_deliveries wnd,
3480: Wsh_trip_stops wts,
3481: wsh_tmp tmp
3482: WHERE wnd.ultimate_dropoff_location_id = c_to_location_id
3483: AND wts.stop_id = wdl.drop_off_stop_id
3484: AND wdl.delivery_id = wnd.delivery_id

Line 4349: UPDATE wsh_trip_stops

4345: l_gross_weight.delete;
4346: l_net_weight.delete;
4347: l_volume.delete;
4348:
4349: UPDATE wsh_trip_stops
4350: SET stop_location_id = l_to_location_id,
4351: last_update_date = SYSDATE,
4352: last_updated_by = fnd_global.user_id,
4353: last_update_login = fnd_global.conc_login_id,