APPS.WSH_DELIVERY_AUTOCREATE dependencies on WSH_DELIVERY_ASSIGNMENTS

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 3412: FROM wsh_delivery_assignments wda

3408: AND NVL(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
3409: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT
3410: AND NOT EXISTS (
3411: SELECT 'x'
3412: FROM wsh_delivery_assignments wda
3413: WHERE wda.delivery_id = wnd.delivery_id
3414: AND wda.delivery_id IS NOT NULL);
3415: --END OTM R12
3416: ELSE

Line 3421: FROM wsh_delivery_assignments wda

3417: DELETE FROM wsh_new_deliveries wnd
3418: WHERE batch_id = p_batch_id
3419: AND NOT EXISTS (
3420: SELECT 'x'
3421: FROM wsh_delivery_assignments wda
3422: WHERE wda.delivery_id = wnd.delivery_id
3423: AND wda.delivery_id IS NOT NULL);
3424: END IF;
3425: --

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:

Line 3848: UPDATE wsh_delivery_assignments wda

3844:
3845:
3846: /*
3847: FORALL l_counter in p_delivery_ids.FIRST .. p_delivery_ids.LAST
3848: UPDATE wsh_delivery_assignments wda
3849: SET wda.parent_delivery_detail_id = null,
3850: wda.delivery_id = null
3851: WHERE wda.delivery_id = p_delivery_ids(l_counter)
3852: AND wda.delivery_id IS NOT NULL

Line 3855: FROM wsh_delivery_assignments wda1

3851: WHERE wda.delivery_id = p_delivery_ids(l_counter)
3852: AND wda.delivery_id IS NOT NULL
3853: AND wda.delivery_detail_id not in(
3854: SELECT wda1.delivery_detail_id
3855: FROM wsh_delivery_assignments wda1
3856: START WITH wda1.delivery_detail_id in (
3857: SELECT wda2.delivery_detail_id
3858: FROM wsh_delivery_details wdd ,
3859: wsh_delivery_assignments wda2

Line 3859: wsh_delivery_assignments wda2

3855: FROM wsh_delivery_assignments wda1
3856: START WITH wda1.delivery_detail_id in (
3857: SELECT wda2.delivery_detail_id
3858: FROM wsh_delivery_details wdd ,
3859: wsh_delivery_assignments wda2
3860: WHERE wda2.delivery_id = wda.delivery_id
3861: AND wda2.delivery_detail_id = wdd.delivery_detail_id
3862: AND wdd.container_flag = 'N')
3863: CONNECT BY wda1.delivery_detail_id = prior wda1.parent_delivery_detail_id);

Line 3870: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATED '||SQL%ROWCOUNT||' RECORDS IN WSH_DELIVERY_ASSIGNMENTS' );

3866: --
3867: -- Debug Statements
3868: --
3869: IF l_debug_on THEN
3870: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATED '||SQL%ROWCOUNT||' RECORDS IN WSH_DELIVERY_ASSIGNMENTS' );
3871: END IF;
3872: --
3873: END IF;
3874: IF l_debug_on THEN