APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WSH_TRIPS_OB_GRP_V

Line 1535: mtl_item_locations_kfv milk, wsh_trips_ob_grp_v wt

1531: BEGIN
1532: select wt.name, milk.concatenated_segments
1533: into x_trip_name, x_loaded_dock_door
1534: from wsh_delivery_legs_ob_grp_v wdl, wsh_trip_stops_ob_grp_v wts,wms_dock_appointments_b wda,
1535: mtl_item_locations_kfv milk, wsh_trips_ob_grp_v wt
1536: where wdl.delivery_id = l_delivery_id
1537: and wdl.pick_up_stop_id = wts.stop_id
1538: and wda.trip_stop = wts.stop_id
1539: and wda.organization_id = p_organization_id

Line 1579: from wsh_trips_ob_grp_v

1575: fetch lpn_in_other_dock2 into x_loaded_dock_door;
1576: if lpn_in_other_dock2%FOUND then
1577: select name
1578: into x_trip_name
1579: from wsh_trips_ob_grp_v
1580: where trip_id = l_trip_id;
1581: x_result := 1;
1582: close lpn_in_other_dock2;
1583: close deliveries_in_lpn;

Line 2866: wsh_trips_ob_grp_v wt

2862: SELECT wts.trip_id,wt.ship_method_code
2863: INTO l_trip_id,l_trip_ship_method_code
2864: FROM wsh_delivery_legs_ob_grp_v wdl,
2865: wsh_trip_stops_ob_grp_v wts,
2866: wsh_trips_ob_grp_v wt
2867: WHERE wdl.delivery_id=p_delivery_id
2868: AND wdl.pick_up_stop_id=wts.stop_id
2869: AND wt.trip_id=wts.trip_id
2870: AND ROWNUM=1;

Line 3948: wsh_trips_ob_grp_v wt

3944: SELECT wts.trip_id,
3945: wt.ship_method_code
3946: FROM wsh_delivery_legs_ob_grp_v wdl,
3947: wsh_trip_stops_ob_grp_v wts,
3948: wsh_trips_ob_grp_v wt
3949: WHERE wdl.delivery_id = l_delivery_id
3950: AND wdl.pick_up_stop_id = wts.stop_id
3951: AND wt.trip_id = wts.trip_id
3952: AND ROWNUM = 1;

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

4019: l_trip_name VARCHAR2(30);
4020: l_msg_data VARCHAR2(2000);
4021:
4022: l_trip_trip_id NUMBER;
4023: l_trip_ship_method_code wsh_trips_ob_grp_v.ship_method_code%type := null;
4024:
4025: BEGIN
4026: savepoint ship_confirm;
4027: