APPS.WSH_DETAILS_VALIDATIONS dependencies on WSH_NEW_DELIVERIES

Line 2181: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd

2177: FOR source_rec IN c_source_info LOOP
2178: BEGIN
2179: select sum(wdd.requested_quantity)
2180: into l_req_qty
2181: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd
2182: where wdd.delivery_detail_id = wda.delivery_detail_id
2183: and wnd.delivery_id(+) = wda.delivery_id
2184: and (wda.delivery_id <> p_delivery_id or wda.delivery_id is NULL)
2185: and wdd.released_status not in ('C', 'D')

Line 2271: FROM wsh_new_deliveries

2267:
2268: CURSOR get_delivery_status
2269: IS
2270: SELECT status_code
2271: FROM wsh_new_deliveries
2272: WHERE delivery_id = p_delivery_id;
2273:
2274: -- OPM 09/11/00
2275: CURSOR dd_info

Line 3414: nvl(wnd.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) -- OTM R12 : WSHDEVLS record

3410: wnd.planned_flag,
3411: wnd.delivery_id,
3412: nvl(wnd.shipment_direction, 'O'), -- J inbound logistics jckwok
3413: nvl(wnd.ignore_for_planning, 'N'), -- OTM R12 : WSHDEVLS record
3414: nvl(wnd.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) -- OTM R12 : WSHDEVLS record
3415: from wsh_new_deliveries wnd,
3416: wsh_delivery_assignments_v wda
3417: where wnd.delivery_id = wda.delivery_id
3418: and wda.delivery_detail_id = p_del_det_id;

Line 3415: from wsh_new_deliveries wnd,

3411: wnd.delivery_id,
3412: nvl(wnd.shipment_direction, 'O'), -- J inbound logistics jckwok
3413: nvl(wnd.ignore_for_planning, 'N'), -- OTM R12 : WSHDEVLS record
3414: nvl(wnd.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) -- OTM R12 : WSHDEVLS record
3415: from wsh_new_deliveries wnd,
3416: wsh_delivery_assignments_v wda
3417: where wnd.delivery_id = wda.delivery_id
3418: and wda.delivery_detail_id = p_del_det_id;
3419:

Line 3437: FROM wsh_new_deliveries wnd

3433: AND wdd.released_status = 'Y' );
3434:
3435: CURSOR c_isdelfirm(p_deliveryid IN NUMBER) IS
3436: SELECT 'Y'
3437: FROM wsh_new_deliveries wnd
3438: WHERE wnd.delivery_id=p_deliveryid
3439: AND wnd.planned_flag='F';
3440:
3441: CURSOR c_isvalidtpdel(p_detid IN NUMBER, p_deliveryid IN NUMBER) IS

Line 3443: FROM wsh_new_deliveries wnd

3439: AND wnd.planned_flag='F';
3440:
3441: CURSOR c_isvalidtpdel(p_detid IN NUMBER, p_deliveryid IN NUMBER) IS
3442: SELECT 'Y'
3443: FROM wsh_new_deliveries wnd
3444: WHERE wnd.delivery_id=p_deliveryid
3445: AND (nvl(wnd.ignore_for_planning, 'N') <>
3446: (select nvl(ignore_for_planning,'N') from wsh_delivery_details where delivery_detail_id=p_detid)
3447: );

Line 3488: l_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;

3484: e_wms_record_ineligible EXCEPTION;
3485: e_tp_record_ineligible EXCEPTION;
3486:
3487: -- OTM R12 : due to record changes in WSHDEVLS
3488: l_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
3489: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
3490: -- OTM R12-Org specific -Bug 5399341
3491: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
3492: -- End of OTM R12 : due to record changes in WSHDEVLS

Line 3489: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;

3485: e_tp_record_ineligible EXCEPTION;
3486:
3487: -- OTM R12 : due to record changes in WSHDEVLS
3488: l_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
3489: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
3490: -- OTM R12-Org specific -Bug 5399341
3491: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
3492: -- End of OTM R12 : due to record changes in WSHDEVLS
3493:

Line 4043: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_deliveryid));

4039: IF nvl(p_caller, FND_API.G_MISS_CHAR) = 'WSH_PUB'
4040: OR p_caller like 'FTE%' THEN
4041: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_ASSIGN_FIRMDEL_ERROR');
4042: FND_MESSAGE.SET_TOKEN('DETAIL_ID', p_del_detail_rec_tab(j).delivery_detail_id);
4043: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_deliveryid));
4044: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
4045: END IF;
4046:
4047: WHEN others THEN

Line 5220: FROM wsh_new_deliveries

5216:
5217:
5218: CURSOR get_delivery_status IS
5219: SELECT status_code
5220: FROM wsh_new_deliveries
5221: WHERE delivery_id = p_delivery_id;
5222:
5223:
5224: CURSOR c_tbl_rec IS