APPS.WMS_DIRECT_SHIP_PVT dependencies on WSH_TRIPS_OB_GRP_V

Line 181: FROM wsh_trips_ob_grp_v wt

177: ,wts.departure_seal_code
178: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP
179: ,WMS_DIRECT_SHIP_PVT.GET_SHIPMETHOD_MEANING(wt.ship_method_code)
180: ,wt.ship_method_code
181: FROM wsh_trips_ob_grp_v wt
182: ,wsh_trip_stops_ob_grp_v wts
183: ,mtl_system_items_kfv msi
184: WHERE wt.trip_id = p_trip_id
185: AND wt.trip_id = wts.trip_id

Line 240: wsh_trips_ob_grp_v wt

236: SELECT wts.trip_id,wt.name
237: INTO l_trip_id,l_trip_name
238: FROM wsh_delivery_legs_ob_grp_v wdl,
239: wsh_trip_stops_ob_grp_v wts,
240: wsh_trips_ob_grp_v wt
241: WHERE wdl.delivery_id=p_delivery_id
242: AND wdl.pick_up_stop_id=wts.stop_id
243: AND wt.trip_id=wts.trip_id
244: AND ROWNUM=1;

Line 1635: wsh_trips_ob_grp_v wt

1631: SELECT wts.trip_id,wt.name
1632: INTO l_trip_id,l_trip_name
1633: FROM wsh_delivery_legs_ob_grp_v wdl,
1634: wsh_trip_stops_ob_grp_v wts,
1635: wsh_trips_ob_grp_v wt
1636: WHERE wdl.delivery_id=l_deliveries.delivery_id
1637: AND wdl.pick_up_stop_id=wts.stop_id
1638: AND wt.trip_id=wts.trip_id
1639: AND ROWNUM=1;

Line 1837: ,WSH_TRIPS_OB_GRP_V wt

1833: BEGIN
1834: SELECT wt.trip_id
1835: INTO l_chk_trip_id
1836: FROM WMS_SHIPPING_TRANSACTION_TEMP wstt
1837: ,WSH_TRIPS_OB_GRP_V wt
1838: WHERE
1839: wt.trip_id = wstt.trip_id
1840: AND organization_id = p_organization_id
1841: AND status_code = 'OP'

Line 2031: FROM wsh_trips_ob_grp_v

2027: FOR UPDATE NOWAIT;
2028:
2029: CURSOR trips IS
2030: SELECT 'x'
2031: FROM wsh_trips_ob_grp_v
2032: WHERE trip_id = p_trip_id
2033: FOR UPDATE NOWAIT;
2034:
2035: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 2087: FROM wsh_trips_ob_grp_v

2083: ELSE
2084: BEGIN
2085: SELECT name
2086: INTO l_name
2087: FROM wsh_trips_ob_grp_v
2088: WHERE trip_id=l_trip_id;
2089: EXCEPTION
2090: WHEN no_data_found THEN
2091: RETURN;

Line 2564: FROM wms_shipping_transaction_temp wstt, wsh_trips_ob_grp_v wt

2560: AND milk.inventory_location_id = wstt.dock_door_id;
2561:
2562: CURSOR closed_trips IS
2563: SELECT DISTINCT wstt.trip_id
2564: FROM wms_shipping_transaction_temp wstt, wsh_trips_ob_grp_v wt
2565: WHERE wstt.organization_id = p_org_id
2566: AND wstt.dock_door_id = p_dock_door_id
2567: AND wt.trip_id = wstt.trip_id
2568: AND wt.status_code IN('CL', 'IT');

Line 2614: FROM wsh_trips_ob_grp_v

2610: ELSE
2611: BEGIN
2612: SELECT NAME
2613: INTO l_name
2614: FROM wsh_trips_ob_grp_v
2615: WHERE trip_id = p_trip_id;
2616: EXCEPTION
2617: WHEN NO_DATA_FOUND THEN
2618: NULL;

Line 2686: FROM wsh_trips_ob_grp_v

2682:
2683: IF lpn_in_other_dock%FOUND THEN
2684: SELECT NAME
2685: INTO l_trip_name
2686: FROM wsh_trips_ob_grp_v
2687: WHERE trip_id = p_trip_id;
2688:
2689: -- Raise error and set the message to be shown in Mobile
2690: fnd_message.set_name('WMS', 'WMS_CLOSE_TRIP_FAIL');

Line 6610: FROM wsh_trips_ob_grp_v

6606: SELECT ship_method_code
6607: , NAME
6608: INTO l_ship_method_code
6609: , l_trip_name
6610: FROM wsh_trips_ob_grp_v
6611: WHERE trip_id = l_trip_cursor.trip_id;
6612: EXCEPTION
6613: WHEN NO_DATA_FOUND THEN
6614: l_ship_method_code := NULL;

Line 6626: FROM wsh_trips_ob_grp_v

6622: /*Bug6878013 If the Vehicle Item Id is not null, pass its value else pass NULL*/
6623: BEGIN
6624: SELECT vehicle_item_id
6625: INTO l_vehicle_item_id
6626: FROM wsh_trips_ob_grp_v
6627: WHERE trip_id = l_trip_cursor.trip_id;
6628: EXCEPTION
6629: WHEN NO_DATA_FOUND THEN
6630: l_vehicle_item_id := NULL;