APPS.WSH_WSHRDXCP_XMLP_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 231: FROM wsh_exceptions we1, wsh_delivery_assignments_v wda

227: L_DEL_LINES_CONT := L_DEL_LINES_CONT || P_BATCHES;
228: L_DEL_LINES_CONT := L_DEL_LINES_CONT || ' and (
229: we.exception_id IN (
230: SELECT we1.exception_id
231: FROM wsh_exceptions we1, wsh_delivery_assignments_v wda
232: WHERE we1.delivery_detail_id = wda.delivery_detail_id ';
233: IF P_DELIVERY_ID_LOW IS NOT NULL THEN
234: L_DEL_LINES_CONT := L_DEL_LINES_CONT || ' AND wda.delivery_id >= :p_delivery_id_low ';
235: END IF;

Line 244: FROM wsh_exceptions we1, wsh_delivery_assignments_v wda, wsh_delivery_details wdd1

240: AND we1.status <> ''CLOSED''
241: )
242: OR we.exception_id IN (
243: SELECT we1.exception_id
244: FROM wsh_exceptions we1, wsh_delivery_assignments_v wda, wsh_delivery_details wdd1
245: WHERE we1.delivery_detail_id = wdd1.delivery_detail_id --LPN Synch Up.added delivery_detail_id instead of container_name..samanna
246: AND wdd1.container_flag = ''Y''
247: AND wdd1.delivery_detail_id = wda.delivery_detail_id ';
248: IF P_DELIVERY_ID_LOW IS NOT NULL THEN

Line 363: WSH_DELIVERY_ASSIGNMENTS_V WDA

359: NAME
360: FROM
361: WSH_NEW_DELIVERIES WND,
362: WSH_DELIVERY_DETAILS WDD,
363: WSH_DELIVERY_ASSIGNMENTS_V WDA
364: WHERE WDD.DELIVERY_DETAIL_ID = P_DELIVERY_DETAIL_ID
365: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
366: AND WDA.DELIVERY_ID = WND.DELIVERY_ID
367: AND WND.DELIVERY_TYPE = 'STANDARD';