APPS.WMS_DIRECT_SHIP_PVT dependencies on WSH_NEW_DELIVERIES

Line 263: FROM wsh_new_deliveries_ob_grp_v wnd,

259: ,nvl(wnd.status_code,'OP')
260: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP
261: ,wts1.trip_id --2767767
262: ,wnd.fob_code --Bug#9668537,9668537 and 9399092
263: FROM wsh_new_deliveries_ob_grp_v wnd,
264: -- 2767767
265: (SELECT wdl.delivery_id,wts.trip_id
266: FROM wsh_delivery_legs_ob_grp_v wdl,
267: wsh_trip_stops_ob_grp_v wts

Line 574: FROM wsh_new_deliveries_ob_grp_v

570: IF p_delivery_id IS NOT NULL THEN
571: BEGIN
572: SELECT name
573: INTO l_del_name
574: FROM wsh_new_deliveries_ob_grp_v
575: WHERE delivery_id =p_delivery_id;
576: EXCEPTION
577: WHEN no_data_found THEN
578: NULL;

Line 584: FROM wsh_new_deliveries_ob_grp_v

580: END IF;
581: BEGIN
582: SELECT 1
583: INTO temp_val
584: FROM wsh_new_deliveries_ob_grp_v
585: WHERE delivery_id = p_delivery_id
586: FOR UPDATE NOWAIT;
587: IF (l_debug = 1) THEN
588: debug('Lock delivery successful','Check_Delivery');

Line 594: /*Failed to aquire locks on wsh_new_deliveries for */

590: EXCEPTION WHEN others THEN
591: x_return_Status := fnd_api.g_ret_sts_error;
592: fnd_message.set_name('WMS','WMS_DEL_LOCK_FAILURE');
593: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',l_del_name);
594: /*Failed to aquire locks on wsh_new_deliveries for */
595: fnd_msg_pub.add;
596: fnd_msg_pub.count_and_get( p_count => x_msg_count,
597: p_data => x_msg_data
598: );

Line 712: FROM wsh_new_deliveries_ob_grp_v

708: END IF;
709: BEGIN
710: SELECT name
711: INTO x_delivery_name
712: FROM wsh_new_deliveries_ob_grp_v
713: WHERE delivery_id = p_delivery_id;
714: FND_MESSAGE.SET_NAME('WMS','WMS_LPN_OTHER_DOCK');
715: FND_MESSAGE.SET_TOKEN('LPN_NAME',x_outermost_lpn);
716: FND_MESSAGE.SET_TOKEN('DOCK',l_loaded_dock_door);

Line 886: FROM wsh_new_deliveries_ob_grp_v

882:
883: IF p_delivery_id IS NOT NULL THEN
884: SELECT status_code
885: INTO l_status_code
886: FROM wsh_new_deliveries_ob_grp_v
887: WHERE delivery_id = p_delivery_id;
888:
889: IF l_status_code IN ('CL','CO','IT') THEN
890: RETURN ;

Line 914: FROM wsh_new_deliveries_ob_grp_v

910: IF p_delivery_id IS NOT NULL THEN
911: BEGIN
912: SELECT name
913: INTO l_del_name
914: FROM wsh_new_deliveries_ob_grp_v
915: WHERE delivery_id = p_delivery_id;
916: EXCEPTION
917: WHEN NO_DATA_FOUND THEN
918: NULL;

Line 1137: ,wsh_new_deliveries_ob_grp_v wnd

1133: msik.concatenated_segments,
1134: msik.description
1135: from wsh_delivery_details_ob_grp_v wdd
1136: ,wsh_delivery_assignments_v wda
1137: ,wsh_new_deliveries_ob_grp_v wnd
1138: ,mtl_system_items_kfv msik
1139: where wnd.delivery_id = p_delivery_id
1140: AND wnd.delivery_id = wda.delivery_id
1141: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 1214: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%type;

1210:
1211: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1212:
1213: l_ignore_for_planning wsh_delivery_details.ignore_for_planning%type;
1214: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%type;
1215: l_otm_trip_id wsh_trips.trip_id%type;
1216: l_otm_carrier_id wsh_trips.carrier_id%type;
1217: l_otm_ship_method_code wsh_trips.ship_method_code%type;
1218: l_otm_mode wsh_trips.mode_of_transport%type;

Line 1242: FROM wsh_new_deliveries_ob_grp_v

1238: and wts.trip_id=wt.trip_id;
1239:
1240: CURSOR c_get_delivery_info IS
1241: SELECT status_code,NAME,ignore_for_planning, tms_interface_flag
1242: FROM wsh_new_deliveries_ob_grp_v
1243: WHERE delivery_id = p_delivery_id;
1244:
1245: BEGIN
1246: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1634: ,WSH_NEW_DELIVERIES_OB_GRP_V WND

1630: l_trip_name VARCHAR2(30);
1631: CURSOR loaded_deliveries IS
1632: SELECT DISTINCT WSTT.delivery_id
1633: FROM WMS_SHIPPING_TRANSACTION_TEMP wstt
1634: ,WSH_NEW_DELIVERIES_OB_GRP_V WND
1635: WHERE wstt.organization_id = p_org_id
1636: AND wstt.dock_door_id = p_dock_door_id
1637: AND wstt.dock_appoint_flag = 'N'
1638: AND nvl(wstt.direct_ship_flag,'N') = 'Y'

Line 3185: FROM wms_shipping_transaction_temp wstt, wsh_new_deliveries_ob_grp_v wnd

3181: SELECT wstt.delivery_id
3182: , wnd.status_code
3183: INTO l_del_id
3184: , l_status_code
3185: FROM wms_shipping_transaction_temp wstt, wsh_new_deliveries_ob_grp_v wnd
3186: WHERE wstt.outermost_lpn_id = p_outermost_lpn_id
3187: AND wstt.direct_ship_flag = 'Y'
3188: AND wstt.delivery_id = wnd.delivery_id
3189: AND ROWNUM = 1;

Line 5292: FROM wsh_new_deliveries_ob_grp_v

5288:
5289:
5290: CURSOR c_Get_OTM_flag(v_del_id NUMBER) IS
5291: SELECT ignore_for_planning, tms_interface_flag
5292: FROM wsh_new_deliveries_ob_grp_v
5293: WHERE delivery_id = v_del_id ;
5294:
5295: CURSOR c_ds_ct_wt_gtemp_exists(
5296: p_organization_id IN NUMBER

Line 5396: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%type;

5392: * variable to hold the ignore_for_planning flag of WDD.
5393: * Added for g-log changes
5394: **********************************/
5395: l_ignore_for_planning wsh_delivery_details.ignore_for_planning%type;
5396: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%type;
5397:
5398: l_dual_uom_item BOOLEAN := FALSE;
5399:
5400: BEGIN

Line 8674: FROM wsh_new_deliveries_ob_grp_v wnd

8670: DEBUG('Unpack delivery_id is: ' || l_delivery_id, 'Container_Nesting');
8671:
8672: SELECT wnd.planned_flag
8673: INTO l_delivery_planned_flag
8674: FROM wsh_new_deliveries_ob_grp_v wnd
8675: WHERE wnd.delivery_id = l_delivery_id;
8676:
8677: DEBUG('Unpack delivery planned status: ' || l_delivery_planned_flag,'Container_Nesting');
8678: EXCEPTION

Line 13647: , wsh_new_deliveries_ob_grp_v wnd

13643:
13644: CURSOR c_wstt_closed_del IS
13645: SELECT DISTINCT wstt.outermost_lpn_id, wstt.delivery_id, wstt.trip_id
13646: FROM wms_shipping_transaction_temp wstt
13647: , wsh_new_deliveries_ob_grp_v wnd
13648: WHERE wstt.organization_id = p_org_id
13649: AND wnd.delivery_id = wstt.delivery_id
13650: AND wnd.status_code IN ('CL','IT');
13651: