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 209: UPDATE wsh_delivery_assignments_v

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

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

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

Line 599: from wsh_delivery_assignments_v

595: -- J: W/V Changes
596: CURSOR C1 is
597: select parent_delivery_detail_id,
598: delivery_id
599: from wsh_delivery_assignments_v
600: where delivery_detail_id = p_delivery_detail_id;
601: l_container_id NUMBER;
602: l_delivery_id NUMBER;
603: l_gross_weight NUMBER;

Line 3676: wsh_delivery_assignments_v wda

3672: IS
3673: SELECT count (wdd.delivery_detail_id), delivery_id
3674: FROM
3675: wsh_delivery_details wdd,
3676: wsh_delivery_assignments_v wda
3677: WHERE
3678: wdd.delivery_detail_id = wda.delivery_detail_id
3679: AND wda.delivery_id = ( SELECT delivery_id
3680: FROM wsh_delivery_assignments_v

Line 3680: FROM wsh_delivery_assignments_v

3676: wsh_delivery_assignments_v wda
3677: WHERE
3678: wdd.delivery_detail_id = wda.delivery_detail_id
3679: AND wda.delivery_id = ( SELECT delivery_id
3680: FROM wsh_delivery_assignments_v
3681: WHERE delivery_detail_id = c_delivery_detail_id )
3682: AND wdd.released_status NOT IN ('R', 'X', 'N')
3683: AND wdd.pickable_flag = 'Y'
3684: AND wdd.container_flag = 'N'

Line 3871: wsh_delivery_assignments_v wda

3867: l_planned_flag,
3868: l_del_batch_id
3869: FROM wsh_new_deliveries wnd,
3870: wsh_delivery_details wdd,
3871: wsh_delivery_assignments_v wda
3872: WHERE wdd.delivery_detail_id = p_changed_attributes(l_Counter).delivery_detail_id
3873: AND wda.delivery_id = wnd.delivery_id
3874: AND wda.delivery_detail_id = wdd.delivery_detail_id ;
3875: EXCEPTION

Line 5133: FROM wsh_delivery_assignments_v

5129:
5130: BEGIN
5131: SELECT parent_delivery_detail_id
5132: INTO l_parent_detail_id
5133: FROM wsh_delivery_assignments_v
5134: WHERE delivery_detail_id = p_changed_attributes(l_Counter).delivery_detail_id
5135: AND parent_delivery_detail_id IS NOT NULL;
5136:
5137: SELECT container_name