APPS.WSH_DELIVERY_AUTOCREATE dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 231: wsh_delivery_assignments_v wda

227: NULL,
228: NULL,
229: NULL -- X-dock, is_xdocked_flag
230: FROM wsh_delivery_details wdd,
231: wsh_delivery_assignments_v wda
232: WHERE wdd.delivery_detail_id = p_dd_id AND
233: wdd.released_status <> 'D'AND
234: wda.delivery_detail_id = wdd.delivery_detail_id;
235:

Line 3242: FROM wsh_delivery_assignments_v

3238:
3239: CURSOR l_detail_assgn_info_csr (p_detail_id IN NUMBER) is
3240: SELECT delivery_id,
3241: parent_delivery_detail_id
3242: FROM wsh_delivery_assignments_v
3243: where delivery_detail_id = p_detail_id;
3244: -- LPN CONV. rv
3245:
3246: -- bug 4416863

Line 3309: FROM wsh_delivery_assignments_v wda

3305: wdd.ship_method_code = NULL,
3306: wdd.deliver_to_location_id = NULL
3307: WHERE wdd.delivery_detail_id in (
3308: SELECT wda.delivery_detail_id
3309: FROM wsh_delivery_assignments_v wda
3310: WHERE wda.delivery_id = p_delivery_ids(l_counter)
3311: AND wda.delivery_id IS NOT NULL
3312: AND wda.delivery_detail_id not in (
3313: SELECT wda1.delivery_detail_id

Line 3314: FROM wsh_delivery_assignments_v wda1

3310: WHERE wda.delivery_id = p_delivery_ids(l_counter)
3311: AND wda.delivery_id IS NOT NULL
3312: AND wda.delivery_detail_id not in (
3313: SELECT wda1.delivery_detail_id
3314: FROM wsh_delivery_assignments_v wda1
3315: START WITH wda1.delivery_detail_id in (
3316: SELECT wda2.delivery_detail_id
3317: FROM wsh_delivery_details wdd1 ,
3318: wsh_delivery_assignments_v wda2

Line 3318: wsh_delivery_assignments_v wda2

3314: FROM wsh_delivery_assignments_v wda1
3315: START WITH wda1.delivery_detail_id in (
3316: SELECT wda2.delivery_detail_id
3317: FROM wsh_delivery_details wdd1 ,
3318: wsh_delivery_assignments_v wda2
3319: WHERE wda2.delivery_id = p_delivery_ids(l_counter)
3320: AND wda2.delivery_detail_id = wdd1.delivery_detail_id
3321: AND wdd1.container_flag = 'N')
3322: CONNECT BY wda1.delivery_detail_id = prior wda1.parent_delivery_detail_id))

Line 3575: UPDATE WSH_DELIVERY_ASSIGNMENTS_V

3571: -- Now it is a simple update
3572: -- LPN CONV. rv
3573:
3574: FORALL l_counter in indices of l_del_det_id_tbl
3575: UPDATE WSH_DELIVERY_ASSIGNMENTS_V
3576: SET DELIVERY_ID = NULL,
3577: PARENT_DELIVERY_DETAIL_ID = NULL
3578: WHERE DELIVERY_DETAIL_ID = l_del_det_id_tbl(l_counter);
3579: