APPS.WSH_USA_INV_PVT dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 72: l_new_delivery_id WSH_DELIVERY_ASSIGNMENTS_V.DELIVERY_ID%TYPE;

68: l_mdc_detail_tab wsh_util_core.id_tab_type;
69: l_dd_id WSH_UTIL_CORE.ID_TAB_TYPE;
70: l_del_tab WSH_UTIL_CORE.Id_Tab_Type;
71: l_return_status VARCHAR2(1);
72: l_new_delivery_id WSH_DELIVERY_ASSIGNMENTS_V.DELIVERY_ID%TYPE;
73:
74: l_reprice_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;
75:
76: MARK_REPRICE_ERROR EXCEPTION;

Line 213: UPDATE wsh_delivery_assignments_v

209: -- 1. Delivery can be absent.
210: -- 2. Unassign Api will raise error if called for Planned Delivery. Also unpacking should be
211: -- independent of unassignment
212:
213: UPDATE wsh_delivery_assignments_v
214: SET delivery_id = decode(p_backorder_rec_tbl(i).planned_flag, 'N', null, delivery_id),
215: parent_delivery_detail_id = decode(p_org_info_tbl(p_backorder_rec_tbl(i).organization_id).wms_org,
216: 'Y', null,
217: decode(p_backorder_rec_tbl(i).planned_flag, 'N', null, parent_delivery_detail_id))

Line 425: WSH_DEBUG_SV.log(l_module_name,'Updated wsh_delivery_assignments_v for backordered_delivery_detail ' ,p_backorder_rec_tbl(i).delivery_detail_id);

421: END IF; --}
422: END IF; --}
423:
424: IF l_debug_on THEN
425: WSH_DEBUG_SV.log(l_module_name,'Updated wsh_delivery_assignments_v for backordered_delivery_detail ' ,p_backorder_rec_tbl(i).delivery_detail_id);
426: END IF;
427:
428: -- FP bug 4208538 from bug 4075078
429: -- Freight costs need to be deleted for the delivery detail if

Line 605: from wsh_delivery_assignments_v

601: -- J: W/V Changes
602: CURSOR C1 is
603: select parent_delivery_detail_id,
604: delivery_id
605: from wsh_delivery_assignments_v
606: where delivery_detail_id = p_delivery_detail_id;
607: l_container_id NUMBER;
608: l_delivery_id NUMBER;
609: l_gross_weight NUMBER;

Line 4071: wsh_delivery_assignments_v wda

4067: IS
4068: SELECT count (wdd.delivery_detail_id), delivery_id
4069: FROM
4070: wsh_delivery_details wdd,
4071: wsh_delivery_assignments_v wda
4072: WHERE
4073: wdd.delivery_detail_id = wda.delivery_detail_id
4074: AND wda.delivery_id = ( SELECT delivery_id
4075: FROM wsh_delivery_assignments_v

Line 4075: FROM wsh_delivery_assignments_v

4071: wsh_delivery_assignments_v wda
4072: WHERE
4073: wdd.delivery_detail_id = wda.delivery_detail_id
4074: AND wda.delivery_id = ( SELECT delivery_id
4075: FROM wsh_delivery_assignments_v
4076: WHERE delivery_detail_id = c_delivery_detail_id )
4077: AND wdd.released_status NOT IN ('R', 'X', 'N')
4078: AND wdd.pickable_flag = 'Y'
4079: AND wdd.container_flag = 'N'

Line 4276: wsh_delivery_assignments_v wda

4272: l_planned_flag,
4273: l_del_batch_id
4274: FROM wsh_new_deliveries wnd,
4275: wsh_delivery_details wdd,
4276: wsh_delivery_assignments_v wda
4277: WHERE wdd.delivery_detail_id = p_changed_attributes(l_Counter).delivery_detail_id
4278: AND wda.delivery_id = wnd.delivery_id
4279: AND wda.delivery_detail_id = wdd.delivery_detail_id ;
4280: EXCEPTION

Line 5697: FROM wsh_delivery_assignments_v

5693:
5694: BEGIN
5695: SELECT parent_delivery_detail_id
5696: INTO l_parent_detail_id
5697: FROM wsh_delivery_assignments_v
5698: WHERE delivery_detail_id = p_changed_attributes(l_Counter).delivery_detail_id
5699: AND parent_delivery_detail_id IS NOT NULL;
5700:
5701: SELECT container_name