[Home] [Help]
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
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;
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');
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);
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 ;
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;
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
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;
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'
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;
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
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
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: