APPS.WSH_DELIVERY_AUTOCREATE dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 282: wsh_delivery_assignments_v wda

278: NULL, -- X-dock, is_xdocked_flag
279: wdd.client_id, -- LSP PROJECT
280: nvl(wdd.consignee_flag, 'C') -- RTV changes
281: FROM wsh_delivery_details wdd,
282: wsh_delivery_assignments_v wda
283: WHERE wdd.delivery_detail_id = p_dd_id AND
284: wdd.released_status <> 'D'AND
285: wda.delivery_detail_id = wdd.delivery_detail_id;
286:

Line 3500: FROM wsh_delivery_assignments_v

3496:
3497: CURSOR l_detail_assgn_info_csr (p_detail_id IN NUMBER) is
3498: SELECT delivery_id,
3499: parent_delivery_detail_id
3500: FROM wsh_delivery_assignments_v
3501: where delivery_detail_id = p_detail_id;
3502: -- LPN CONV. rv
3503:
3504: -- bug 4416863

Line 3568: FROM wsh_delivery_assignments_v wda

3564: wdd.deliver_to_location_id = NULL,
3565: wdd.client_id = NULL -- LSP PROJECT
3566: WHERE wdd.delivery_detail_id in (
3567: SELECT wda.delivery_detail_id
3568: FROM wsh_delivery_assignments_v wda
3569: WHERE wda.delivery_id = p_delivery_ids(l_counter)
3570: AND wda.delivery_id IS NOT NULL
3571: AND wda.delivery_detail_id not in (
3572: SELECT wda1.delivery_detail_id

Line 3573: FROM wsh_delivery_assignments_v wda1

3569: WHERE wda.delivery_id = p_delivery_ids(l_counter)
3570: AND wda.delivery_id IS NOT NULL
3571: AND wda.delivery_detail_id not in (
3572: SELECT wda1.delivery_detail_id
3573: FROM wsh_delivery_assignments_v wda1
3574: START WITH wda1.delivery_detail_id in (
3575: SELECT wda2.delivery_detail_id
3576: FROM wsh_delivery_details wdd1 ,
3577: wsh_delivery_assignments_v wda2

Line 3577: wsh_delivery_assignments_v wda2

3573: FROM wsh_delivery_assignments_v wda1
3574: START WITH wda1.delivery_detail_id in (
3575: SELECT wda2.delivery_detail_id
3576: FROM wsh_delivery_details wdd1 ,
3577: wsh_delivery_assignments_v wda2
3578: WHERE wda2.delivery_id = p_delivery_ids(l_counter)
3579: AND wda2.delivery_detail_id = wdd1.delivery_detail_id
3580: AND wdd1.container_flag = 'N')
3581: CONNECT BY wda1.delivery_detail_id = prior wda1.parent_delivery_detail_id))

Line 3834: UPDATE WSH_DELIVERY_ASSIGNMENTS_V

3830: -- Now it is a simple update
3831: -- LPN CONV. rv
3832:
3833: FORALL l_counter in indices of l_del_det_id_tbl
3834: UPDATE WSH_DELIVERY_ASSIGNMENTS_V
3835: SET DELIVERY_ID = NULL,
3836: PARENT_DELIVERY_DETAIL_ID = NULL
3837: WHERE DELIVERY_DETAIL_ID = l_del_det_id_tbl(l_counter);
3838: