APPS.WSH_MBOLS_PVT dependencies on WSH_DELIVERY_LEGS

Line 255: wsh_delivery_legs dlg,

251: wt.ship_method_code,
252: del.initial_pickup_location_id,
253: wt.name
254: FROM wsh_new_deliveries del,
255: wsh_delivery_legs dlg,
256: wsh_trip_stops st,
257: wsh_trips wt
258: WHERE del.delivery_id = dlg.delivery_id
259: AND dlg.pick_up_stop_id = st.stop_id

Line 324: WHERE entity_name = 'WSH_DELIVERY_LEGS'

320:
321: SELECT count(*)
322: INTO l_bol_count
323: FROM wsh_document_instances
324: WHERE entity_name = 'WSH_DELIVERY_LEGS'
325: AND entity_id = l_delivery_leg_id
326: AND status <> 'CANCELLED';
327:
328: IF l_bol_count = 0 THEN

Line 360: , p_entity_name => 'WSH_DELIVERY_LEGS'

356: , p_validation_level => NULL
357: , x_return_status => l_return_status
358: , x_msg_count => l_msg_count
359: , x_msg_data => l_msg_data
360: , p_entity_name => 'WSH_DELIVERY_LEGS'
361: , p_entity_id => l_delivery_leg_id
362: , p_application_id => 665
363: , p_location_id => l_pickup_location_id
364: , p_document_type => 'BOL'

Line 1069: from wsh_trip_stops wts, wsh_delivery_legs wdl

1065: If l_organization_id is null then
1066: --{
1067: select min(delivery_id)
1068: into l_first_delivery_id
1069: from wsh_trip_stops wts, wsh_delivery_legs wdl
1070: where wts.trip_id = p_trip_id
1071: and wts.stop_id = wdl.pick_up_stop_id;
1072: IF l_debug_on THEN
1073: WSH_DEBUG_SV.log(l_module_name,'l_first_delivery_id', l_first_delivery_id);