APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WSH_TRIPS_OB_GRP_V

Line 1593: mtl_item_locations_kfv milk, wsh_trips_ob_grp_v wt

1589: BEGIN
1590: select wt.name, milk.concatenated_segments
1591: into x_trip_name, x_loaded_dock_door
1592: from wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts,wms_dock_appointments_b wda,
1593: mtl_item_locations_kfv milk, wsh_trips_ob_grp_v wt
1594: where wdl.delivery_id = l_delivery_id
1595: and wdl.pick_up_stop_id = wts.stop_id
1596: and wda.trip_stop = wts.stop_id
1597: and wda.organization_id = p_organization_id

Line 1637: from wsh_trips_ob_grp_v

1633: fetch lpn_in_other_dock2 into x_loaded_dock_door;
1634: if lpn_in_other_dock2%FOUND then
1635: select name
1636: into x_trip_name
1637: from wsh_trips_ob_grp_v
1638: where trip_id = l_trip_id;
1639: x_result := 1;
1640: close lpn_in_other_dock2;
1641: close deliveries_in_lpn;

Line 2927: wsh_trips_ob_grp_v wt

2923: SELECT wts.trip_id,wt.ship_method_code
2924: INTO l_trip_id,l_trip_ship_method_code
2925: FROM wsh_delivery_legs_ob_grp_v wdl,
2926: wsh_trip_stops_ob_grp_v wts,
2927: wsh_trips_ob_grp_v wt
2928: WHERE wdl.delivery_id=p_delivery_id
2929: AND wdl.pick_up_stop_id=wts.stop_id
2930: AND wt.trip_id=wts.trip_id
2931: AND ROWNUM=1;

Line 4108: wsh_trips_ob_grp_v wt

4104: SELECT wts.trip_id,
4105: wt.ship_method_code
4106: FROM wsh_delivery_legs_ob_grp_v wdl,
4107: wsh_trip_stops_ob_grp_v wts,
4108: wsh_trips_ob_grp_v wt
4109: WHERE wdl.delivery_id = l_delivery_id
4110: AND wdl.pick_up_stop_id = wts.stop_id
4111: AND wt.trip_id = wts.trip_id
4112: AND ROWNUM = 1;

Line 4183: l_trip_ship_method_code wsh_trips_ob_grp_v.ship_method_code%type := null;

4179: l_trip_name VARCHAR2(30);
4180: l_msg_data VARCHAR2(2000);
4181:
4182: l_trip_trip_id NUMBER;
4183: l_trip_ship_method_code wsh_trips_ob_grp_v.ship_method_code%type := null;
4184:
4185: BEGIN
4186: savepoint ship_confirm;
4187: