APPS.WMS_DIRECT_SHIP_PVT dependencies on WSH_TRIPS_OB_GRP_V

Line 222: FROM wsh_trips_ob_grp_v wt

218: ,wts.departure_seal_code
219: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP
220: ,WMS_DIRECT_SHIP_PVT.GET_SHIPMETHOD_MEANING(wt.ship_method_code)
221: ,wt.ship_method_code
222: FROM wsh_trips_ob_grp_v wt
223: ,wsh_trip_stops_ob_grp_v wts
224: ,mtl_system_items_kfv msi
225: WHERE wt.trip_id = p_trip_id
226: AND wt.trip_id = wts.trip_id

Line 282: wsh_trips_ob_grp_v wt

278: SELECT wts.trip_id,wt.name
279: INTO l_trip_id,l_trip_name
280: FROM wsh_delivery_legs_ob_grp_v wdl,
281: wsh_trip_stops_ob_grp_v wts,
282: wsh_trips_ob_grp_v wt
283: WHERE wdl.delivery_id=p_delivery_id
284: AND wdl.pick_up_stop_id=wts.stop_id
285: AND wt.trip_id=wts.trip_id
286: AND ROWNUM=1;

Line 1730: wsh_trips_ob_grp_v wt

1726: SELECT wts.trip_id,wt.name
1727: INTO l_trip_id,l_trip_name
1728: FROM wsh_delivery_legs_ob_grp_v wdl,
1729: wsh_trip_stops_ob_grp_v wts,
1730: wsh_trips_ob_grp_v wt
1731: WHERE wdl.delivery_id=l_deliveries.delivery_id
1732: AND wdl.pick_up_stop_id=wts.stop_id
1733: AND wt.trip_id=wts.trip_id
1734: AND ROWNUM=1;

Line 1932: ,WSH_TRIPS_OB_GRP_V wt

1928: BEGIN
1929: SELECT wt.trip_id
1930: INTO l_chk_trip_id
1931: FROM WMS_SHIPPING_TRANSACTION_TEMP wstt
1932: ,WSH_TRIPS_OB_GRP_V wt
1933: WHERE
1934: wt.trip_id = wstt.trip_id
1935: AND organization_id = p_organization_id
1936: AND status_code = 'OP'

Line 2127: FROM wsh_trips_ob_grp_v

2123: FOR UPDATE NOWAIT;
2124:
2125: CURSOR trips IS
2126: SELECT 'x'
2127: FROM wsh_trips_ob_grp_v
2128: WHERE trip_id = p_trip_id
2129: FOR UPDATE NOWAIT;
2130:
2131: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 2183: FROM wsh_trips_ob_grp_v

2179: ELSE
2180: BEGIN
2181: SELECT name
2182: INTO l_name
2183: FROM wsh_trips_ob_grp_v
2184: WHERE trip_id=l_trip_id;
2185: EXCEPTION
2186: WHEN no_data_found THEN
2187: RETURN;

Line 2666: FROM wms_shipping_transaction_temp wstt, wsh_trips_ob_grp_v wt

2662: AND milk.inventory_location_id = wstt.dock_door_id;
2663:
2664: CURSOR closed_trips IS
2665: SELECT DISTINCT wstt.trip_id
2666: FROM wms_shipping_transaction_temp wstt, wsh_trips_ob_grp_v wt
2667: WHERE wstt.organization_id = p_org_id
2668: AND wstt.dock_door_id = p_dock_door_id
2669: AND wt.trip_id = wstt.trip_id
2670: AND wt.status_code IN('CL', 'IT');

Line 2716: FROM wsh_trips_ob_grp_v

2712: ELSE
2713: BEGIN
2714: SELECT NAME
2715: INTO l_name
2716: FROM wsh_trips_ob_grp_v
2717: WHERE trip_id = p_trip_id;
2718: EXCEPTION
2719: WHEN NO_DATA_FOUND THEN
2720: NULL;

Line 2788: FROM wsh_trips_ob_grp_v

2784:
2785: IF lpn_in_other_dock%FOUND THEN
2786: SELECT NAME
2787: INTO l_trip_name
2788: FROM wsh_trips_ob_grp_v
2789: WHERE trip_id = p_trip_id;
2790:
2791: -- Raise error and set the message to be shown in Mobile
2792: fnd_message.set_name('WMS', 'WMS_CLOSE_TRIP_FAIL');

Line 7717: FROM wsh_trips_ob_grp_v

7713: SELECT ship_method_code
7714: , NAME
7715: INTO l_ship_method_code
7716: , l_trip_name
7717: FROM wsh_trips_ob_grp_v
7718: WHERE trip_id = l_trip_cursor.trip_id;
7719: EXCEPTION
7720: WHEN NO_DATA_FOUND THEN
7721: l_ship_method_code := NULL;

Line 7733: FROM wsh_trips_ob_grp_v

7729: /*Bug6878013 If the Vehicle Item Id is not null, pass its value else pass NULL*/
7730: BEGIN
7731: SELECT vehicle_item_id
7732: INTO l_vehicle_item_id
7733: FROM wsh_trips_ob_grp_v
7734: WHERE trip_id = l_trip_cursor.trip_id;
7735: EXCEPTION
7736: WHEN NO_DATA_FOUND THEN
7737: l_vehicle_item_id := NULL;