APPS.WSH_DETAILS_VALIDATIONS dependencies on WSH_NEW_DELIVERIES

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

2262: IF source_rec.fulfill_base = 'P' THEN
2263: BEGIN
2264: select sum(wdd.requested_quantity)
2265: into l_req_qty
2266: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd
2267: where wdd.delivery_detail_id = wda.delivery_detail_id
2268: and wnd.delivery_id(+) = wda.delivery_id
2269: and (wda.delivery_id <> p_delivery_id or wda.delivery_id is NULL)
2270: and wdd.released_status not in ('C', 'D')

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

2286: ELSE
2287: BEGIN
2288: select sum(wdd.requested_quantity2)
2289: into l_req_qty
2290: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd
2291: where wdd.delivery_detail_id = wda.delivery_detail_id
2292: and wnd.delivery_id(+) = wda.delivery_id
2293: and (wda.delivery_id <> p_delivery_id or wda.delivery_id is NULL)
2294: and wdd.released_status not in ('C', 'D')

Line 2381: FROM wsh_new_deliveries

2377:
2378: CURSOR get_delivery_status
2379: IS
2380: SELECT status_code
2381: FROM wsh_new_deliveries
2382: WHERE delivery_id = p_delivery_id;
2383:
2384: -- OPM 09/11/00
2385: CURSOR dd_info

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

3533: wnd.planned_flag,
3534: wnd.delivery_id,
3535: nvl(wnd.shipment_direction, 'O'), -- J inbound logistics jckwok
3536: nvl(wnd.ignore_for_planning, 'N'), -- OTM R12 : WSHDEVLS record
3537: nvl(wnd.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) -- OTM R12 : WSHDEVLS record
3538: from wsh_new_deliveries wnd,
3539: wsh_delivery_assignments_v wda
3540: where wnd.delivery_id = wda.delivery_id
3541: and wda.delivery_detail_id = p_del_det_id;

Line 3538: from wsh_new_deliveries wnd,

3534: wnd.delivery_id,
3535: nvl(wnd.shipment_direction, 'O'), -- J inbound logistics jckwok
3536: nvl(wnd.ignore_for_planning, 'N'), -- OTM R12 : WSHDEVLS record
3537: nvl(wnd.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) -- OTM R12 : WSHDEVLS record
3538: from wsh_new_deliveries wnd,
3539: wsh_delivery_assignments_v wda
3540: where wnd.delivery_id = wda.delivery_id
3541: and wda.delivery_detail_id = p_del_det_id;
3542:

Line 3560: FROM wsh_new_deliveries wnd

3556: AND wdd.released_status = 'Y' );
3557:
3558: CURSOR c_isdelfirm(p_deliveryid IN NUMBER) IS
3559: SELECT 'Y'
3560: FROM wsh_new_deliveries wnd
3561: WHERE wnd.delivery_id=p_deliveryid
3562: AND wnd.planned_flag='F';
3563:
3564: CURSOR c_isvalidtpdel(p_detid IN NUMBER, p_deliveryid IN NUMBER) IS

Line 3566: FROM wsh_new_deliveries wnd

3562: AND wnd.planned_flag='F';
3563:
3564: CURSOR c_isvalidtpdel(p_detid IN NUMBER, p_deliveryid IN NUMBER) IS
3565: SELECT 'Y'
3566: FROM wsh_new_deliveries wnd
3567: WHERE wnd.delivery_id=p_deliveryid
3568: AND (nvl(wnd.ignore_for_planning, 'N') <>
3569: (select nvl(ignore_for_planning,'N') from wsh_delivery_details where delivery_detail_id=p_detid)
3570: );

Line 3620: l_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;

3616: e_wms_record_ineligible EXCEPTION;
3617: e_tp_record_ineligible EXCEPTION;
3618:
3619: -- OTM R12 : due to record changes in WSHDEVLS
3620: l_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
3621: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
3622: -- OTM R12-Org specific -Bug 5399341
3623: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
3624: -- End of OTM R12 : due to record changes in WSHDEVLS

Line 3621: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;

3617: e_tp_record_ineligible EXCEPTION;
3618:
3619: -- OTM R12 : due to record changes in WSHDEVLS
3620: l_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
3621: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
3622: -- OTM R12-Org specific -Bug 5399341
3623: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
3624: -- End of OTM R12 : due to record changes in WSHDEVLS
3625:

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

4214: IF nvl(p_caller, FND_API.G_MISS_CHAR) = 'WSH_PUB'
4215: OR p_caller like 'FTE%' THEN
4216: FND_MESSAGE.SET_NAME('WSH', 'WSH_DET_ASSIGN_FIRMDEL_ERROR');
4217: FND_MESSAGE.SET_TOKEN('DETAIL_ID', p_del_detail_rec_tab(j).delivery_detail_id);
4218: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(p_deliveryid));
4219: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
4220: END IF;
4221:
4222: WHEN others THEN

Line 5408: FROM wsh_new_deliveries

5404:
5405:
5406: CURSOR get_delivery_status IS
5407: SELECT status_code
5408: FROM wsh_new_deliveries
5409: WHERE delivery_id = p_delivery_id;
5410:
5411:
5412: CURSOR c_tbl_rec IS