[Home] [Help]
217: ,WMS_DIRECT_SHIP_PVT.GET_BOL(wnd.delivery_id)
218: ,nvl(wnd.status_code,'OP')
219: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP
220: ,wts1.trip_id --2767767
221: FROM wsh_new_deliveries_ob_grp_v wnd,
222: -- 2767767
223: (SELECT wdl.delivery_id,wts.trip_id
224: FROM wsh_delivery_legs_ob_grp_v wdl,
225: wsh_trip_stops_ob_grp_v wts
487: IF p_delivery_id IS NOT NULL THEN
488: BEGIN
489: SELECT name
490: INTO l_del_name
491: FROM wsh_new_deliveries_ob_grp_v
492: WHERE delivery_id =p_delivery_id;
493: EXCEPTION
494: WHEN no_data_found THEN
495: NULL;
497: END IF;
498: BEGIN
499: SELECT 1
500: INTO temp_val
501: FROM wsh_new_deliveries_ob_grp_v
502: WHERE delivery_id = p_delivery_id
503: FOR UPDATE NOWAIT;
504: IF (l_debug = 1) THEN
505: debug('Lock delivery successful','Check_Delivery');
625: END IF;
626: BEGIN
627: SELECT name
628: INTO x_delivery_name
629: FROM wsh_new_deliveries_ob_grp_v
630: WHERE delivery_id = p_delivery_id;
631: FND_MESSAGE.SET_NAME('WMS','WMS_LPN_OTHER_DOCK');
632: FND_MESSAGE.SET_TOKEN('LPN_NAME',x_outermost_lpn);
633: FND_MESSAGE.SET_TOKEN('DOCK',l_loaded_dock_door);
799:
800: IF p_delivery_id IS NOT NULL THEN
801: SELECT status_code
802: INTO l_status_code
803: FROM wsh_new_deliveries_ob_grp_v
804: WHERE delivery_id = p_delivery_id;
805:
806: IF l_status_code IN ('CL','CO','IT') THEN
807: RETURN ;
827: IF p_delivery_id IS NOT NULL THEN
828: BEGIN
829: SELECT name
830: INTO l_del_name
831: FROM wsh_new_deliveries_ob_grp_v
832: WHERE delivery_id = p_delivery_id;
833: EXCEPTION
834: WHEN NO_DATA_FOUND THEN
835: NULL;
1050: msik.concatenated_segments,
1051: msik.description
1052: from wsh_delivery_details_ob_grp_v wdd
1053: ,wsh_delivery_assignments_v wda
1054: ,wsh_new_deliveries_ob_grp_v wnd
1055: ,mtl_system_items_kfv msik
1056: where wnd.delivery_id = p_delivery_id
1057: AND wnd.delivery_id = wda.delivery_id
1058: AND wda.delivery_detail_id = wdd.delivery_detail_id
1154: and wts.trip_id=wt.trip_id;
1155:
1156: CURSOR c_get_delivery_info IS
1157: SELECT status_code,NAME,ignore_for_planning, tms_interface_flag
1158: FROM wsh_new_deliveries_ob_grp_v
1159: WHERE delivery_id = p_delivery_id;
1160:
1161: BEGIN
1162: x_return_status := FND_API.G_RET_STS_SUCCESS;
1535: l_trip_name VARCHAR2(30);
1536: CURSOR loaded_deliveries IS
1537: SELECT DISTINCT WSTT.delivery_id
1538: FROM WMS_SHIPPING_TRANSACTION_TEMP wstt
1539: ,WSH_NEW_DELIVERIES_OB_GRP_V WND
1540: WHERE wstt.organization_id = p_org_id
1541: AND wstt.dock_door_id = p_dock_door_id
1542: AND wstt.dock_appoint_flag = 'N'
1543: AND nvl(wstt.direct_ship_flag,'N') = 'Y'
3024: SELECT wstt.delivery_id
3025: , wnd.status_code
3026: INTO l_del_id
3027: , l_status_code
3028: FROM wms_shipping_transaction_temp wstt, wsh_new_deliveries_ob_grp_v wnd
3029: WHERE wstt.outermost_lpn_id = p_outermost_lpn_id
3030: AND wstt.direct_ship_flag = 'Y'
3031: AND wstt.delivery_id = wnd.delivery_id
3032: AND ROWNUM = 1;
5010:
5011:
5012: CURSOR c_Get_OTM_flag(v_del_id NUMBER) IS
5013: SELECT ignore_for_planning, tms_interface_flag
5014: FROM wsh_new_deliveries_ob_grp_v
5015: WHERE delivery_id = v_del_id ;
5016:
5017: l_delivery_detail_tab delivery_detail_tab;
5018: l_new_delivery_detail_id NUMBER;
7573: DEBUG('Unpack delivery_id is: ' || l_delivery_id, 'Container_Nesting');
7574:
7575: SELECT wnd.planned_flag
7576: INTO l_delivery_planned_flag
7577: FROM wsh_new_deliveries_ob_grp_v wnd
7578: WHERE wnd.delivery_id = l_delivery_id;
7579:
7580: DEBUG('Unpack delivery planned status: ' || l_delivery_planned_flag,'Container_Nesting');
7581: EXCEPTION
11660:
11661: --
11662: CURSOR closed_del(p_del_id NUMBER) IS
11663: SELECT delivery_id
11664: FROM wsh_new_deliveries_ob_grp_v
11665: WHERE delivery_id = p_del_id
11666: AND status_code IN('CL', 'IT');
11667:
11668: --