APPS.WSH_PURGE dependencies on WSH_NEW_DELIVERIES

Line 400: wsh_new_deliveries wnd

396: SELECT distinct wnd.delivery_id, wnd.name
397: FROM wsh_trips wt,
398: wsh_trip_stops wts,
399: wsh_delivery_legs wdl,
400: wsh_new_deliveries wnd
401: WHERE wt.trip_id = wts.trip_id
402: AND wts.stop_id = wdl.pick_up_stop_id
403: AND wdl.delivery_id = wnd.delivery_id
404: AND wts.trip_id = p_tripid;

Line 434: FROM wsh_new_deliveries wnd,

430: --cursor to select orphaned deliveries with only empty containers
431: CURSOR c_delivery_empty_containers IS
432: SELECT wnd.delivery_id
433: --wda.delivery_detail_id
434: FROM wsh_new_deliveries wnd,
435: wsh_delivery_assignments_v wda,
436: wsh_delivery_legs wdl
437: WHERE wnd.delivery_id = wda.delivery_id
438: AND wnd.delivery_id = wdl.delivery_id(+)

Line 610: wsh_new_deliveries wnd,

606: --construct delivery_sql for empty deliveries
607: delivery_sql := 'SELECT
608: wnd.delivery_id,wnd.name
609: FROM
610: wsh_new_deliveries wnd,
611: wsh_delivery_assignments_v wda,
612: wsh_delivery_legs wdl
613: WHERE
614: wda.delivery_id(+) = wnd.delivery_id AND

Line 1208: and finally WSH_NEW_DELIVERIES.

1204:
1205: If ITM Screening is done,
1206: WSH_ITM_RESPONSE_LINES, WSH_ITM_RESPONSE_HEADERS, WSH_ITM_REQUEST_CONTROL,
1207: WSH_INBOUND_TXN_HISTORY
1208: and finally WSH_NEW_DELIVERIES.
1209: -----------------------------------------------------------------------------*/
1210:
1211: PROCEDURE Purge_Deliveries( p_tbl_delivery_purge_set Delivery_ID_Tbl_Type,
1212: x_return_status OUT NOCOPY VARCHAR2

Line 1274: AND entity_name = 'WSH_NEW_DELIVERIES';

1270:
1271: DELETE
1272: FROM wsh_document_instances
1273: WHERE entity_id = l_delivery_id
1274: AND entity_name = 'WSH_NEW_DELIVERIES';
1275:
1276: IF SQL%FOUND THEN
1277: IF l_debug_on THEN
1278: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_document_instances: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1424: FROM wsh_new_deliveries

1420:
1421: DELETE
1422: FROM wsh_inbound_txn_history
1423: WHERE shipment_header_id IN ( SELECT rcv_shipment_header_id
1424: FROM wsh_new_deliveries
1425: WHERE delivery_id = l_delivery_id) ;
1426:
1427: IF SQL%FOUND THEN
1428: IF l_debug_on THEN

Line 1434: FROM wsh_new_deliveries

1430: END IF;
1431: END IF;
1432:
1433: DELETE
1434: FROM wsh_new_deliveries
1435: WHERE delivery_id = l_delivery_id;
1436:
1437: IF SQL%FOUND THEN
1438: IF l_debug_on THEN

Line 1439: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_new_deliveries: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);

1435: WHERE delivery_id = l_delivery_id;
1436:
1437: IF SQL%FOUND THEN
1438: IF l_debug_on THEN
1439: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_new_deliveries: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1440: END IF;
1441: END IF;
1442:
1443: END LOOP;

Line 2672: wsh_new_deliveries wnd,

2668: SELECT wdd.lpn_id
2669: FROM wsh_trips wt,
2670: wsh_trip_stops wts,
2671: wsh_delivery_legs wdl,
2672: wsh_new_deliveries wnd,
2673: wsh_delivery_assignments_v wda,
2674: wsh_delivery_details wdd
2675: WHERE wt.trip_id = wts.trip_id
2676: AND wts.stop_id = wdl.pick_up_stop_id

Line 2711: wsh_new_deliveries wnd,

2707: FROM wsh_delivery_legs
2708: WHERE parent_delivery_leg_id IS NULL
2709: START WITH delivery_id IN (SELECT wdl.delivery_id
2710: FROM
2711: wsh_new_deliveries wnd,
2712: wsh_delivery_legs wdl,
2713: wsh_trip_stops pickup_stop,
2714: wsh_trip_stops dropoff_stop,
2715: wsh_trips wt