DBA Data[Home] [Help]

APPS.WSH_DELIVERY_LEGS_ACTIONS dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 3203: FROM wsh_delivery_assignments wda,

3199: DECLARE
3200:
3201: CURSOR c_lock_delivery_details (c_delivery_id IN number) IS
3202: SELECT wdd.delivery_detail_id
3203: FROM wsh_delivery_assignments wda,
3204: wsh_delivery_details wdd
3205: WHERE wda.delivery_id = c_delivery_id
3206: AND wda.delivery_detail_id = wdd.delivery_detail_id
3207: FOR UPDATE OF wdd.load_seq_number NOWAIT;

Line 3593: wsh_delivery_assignments_v da,

3589: cursor get_trip_from_det( c_delivery_detail_id NUMBER) is
3590: SELECT dlg.delivery_leg_id, trip.trip_id, trip.consolidation_allowed,
3591: trip.lane_id, trip.mode_of_transport
3592: FROM wsh_delivery_legs dlg,
3593: wsh_delivery_assignments_v da,
3594: wsh_trips trip,
3595: wsh_trip_stops st
3596: WHERE da.delivery_detail_id = c_delivery_detail_id AND
3597: da.delivery_id = dlg.delivery_id AND