APPS.WSH_DELIVERY_AUTOCREATE dependencies on WSH_DELIVERY_ASSIGNMENTS

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

3150: AND NVL(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
3151: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT
3152: AND NOT EXISTS (
3153: SELECT 'x'
3154: FROM wsh_delivery_assignments wda
3155: WHERE wda.delivery_id = wnd.delivery_id
3156: AND wda.delivery_id IS NOT NULL);
3157: --END OTM R12
3158: ELSE

Line 3163: FROM wsh_delivery_assignments wda

3159: DELETE FROM wsh_new_deliveries wnd
3160: WHERE batch_id = p_batch_id
3161: AND NOT EXISTS (
3162: SELECT 'x'
3163: FROM wsh_delivery_assignments wda
3164: WHERE wda.delivery_id = wnd.delivery_id
3165: AND wda.delivery_id IS NOT NULL);
3166: END IF;
3167: --

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:

Line 3589: UPDATE wsh_delivery_assignments wda

3585:
3586:
3587: /*
3588: FORALL l_counter in p_delivery_ids.FIRST .. p_delivery_ids.LAST
3589: UPDATE wsh_delivery_assignments wda
3590: SET wda.parent_delivery_detail_id = null,
3591: wda.delivery_id = null
3592: WHERE wda.delivery_id = p_delivery_ids(l_counter)
3593: AND wda.delivery_id IS NOT NULL

Line 3596: FROM wsh_delivery_assignments wda1

3592: WHERE wda.delivery_id = p_delivery_ids(l_counter)
3593: AND wda.delivery_id IS NOT NULL
3594: AND wda.delivery_detail_id not in(
3595: SELECT wda1.delivery_detail_id
3596: FROM wsh_delivery_assignments wda1
3597: START WITH wda1.delivery_detail_id in (
3598: SELECT wda2.delivery_detail_id
3599: FROM wsh_delivery_details wdd ,
3600: wsh_delivery_assignments wda2

Line 3600: wsh_delivery_assignments wda2

3596: FROM wsh_delivery_assignments wda1
3597: START WITH wda1.delivery_detail_id in (
3598: SELECT wda2.delivery_detail_id
3599: FROM wsh_delivery_details wdd ,
3600: wsh_delivery_assignments wda2
3601: WHERE wda2.delivery_id = wda.delivery_id
3602: AND wda2.delivery_detail_id = wdd.delivery_detail_id
3603: AND wdd.container_flag = 'N')
3604: CONNECT BY wda1.delivery_detail_id = prior wda1.parent_delivery_detail_id);

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

3607: --
3608: -- Debug Statements
3609: --
3610: IF l_debug_on THEN
3611: WSH_DEBUG_SV.logmsg(l_module_name, 'UPDATED '||SQL%ROWCOUNT||' RECORDS IN WSH_DELIVERY_ASSIGNMENTS' );
3612: END IF;
3613: --
3614: END IF;
3615: IF l_debug_on THEN