APPS.WSH_PURGE dependencies on WSH_NEW_DELIVERIES

Line 407: wsh_new_deliveries wnd

403: SELECT distinct wnd.delivery_id, wnd.name
404: FROM wsh_trips wt,
405: wsh_trip_stops wts,
406: wsh_delivery_legs wdl,
407: wsh_new_deliveries wnd
408: WHERE wt.trip_id = wts.trip_id
409: AND wts.stop_id = wdl.pick_up_stop_id
410: AND wdl.delivery_id = wnd.delivery_id
411: AND wts.trip_id = p_tripid;

Line 454: FROM wsh_new_deliveries wnd,

450: --cursor to select orphaned deliveries with only empty containers
451: CURSOR c_delivery_empty_containers IS
452: SELECT wnd.delivery_id
453: --wda.delivery_detail_id
454: FROM wsh_new_deliveries wnd,
455: wsh_delivery_assignments_v wda,
456: wsh_delivery_legs wdl
457: WHERE wnd.delivery_id = wda.delivery_id
458: AND wnd.delivery_id = wdl.delivery_id(+)

Line 676: wsh_new_deliveries wnd,

672: --construct delivery_sql for empty deliveries
673: delivery_sql := 'SELECT
674: wnd.delivery_id,wnd.name
675: FROM
676: wsh_new_deliveries wnd,
677: wsh_delivery_assignments_v wda,
678: wsh_delivery_legs wdl
679: WHERE
680: wda.delivery_id(+) = wnd.delivery_id AND

Line 1333: and finally WSH_NEW_DELIVERIES.

1329:
1330: If ITM Screening is done,
1331: WSH_ITM_RESPONSE_LINES, WSH_ITM_RESPONSE_HEADERS, WSH_ITM_REQUEST_CONTROL,
1332: WSH_INBOUND_TXN_HISTORY
1333: and finally WSH_NEW_DELIVERIES.
1334: -----------------------------------------------------------------------------*/
1335:
1336: PROCEDURE Purge_Deliveries( p_tbl_delivery_purge_set Delivery_ID_Tbl_Type,
1337: x_return_status OUT NOCOPY VARCHAR2

Line 1399: AND entity_name = 'WSH_NEW_DELIVERIES';

1395:
1396: DELETE
1397: FROM wsh_document_instances
1398: WHERE entity_id = l_delivery_id
1399: AND entity_name = 'WSH_NEW_DELIVERIES';
1400:
1401: IF SQL%FOUND THEN
1402: IF l_debug_on THEN
1403: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_document_instances: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1549: FROM wsh_new_deliveries

1545:
1546: DELETE
1547: FROM wsh_inbound_txn_history
1548: WHERE shipment_header_id IN ( SELECT rcv_shipment_header_id
1549: FROM wsh_new_deliveries
1550: WHERE delivery_id = l_delivery_id) ;
1551:
1552: IF SQL%FOUND THEN
1553: IF l_debug_on THEN

Line 1559: FROM wsh_new_deliveries

1555: END IF;
1556: END IF;
1557:
1558: DELETE
1559: FROM wsh_new_deliveries
1560: WHERE delivery_id = l_delivery_id;
1561:
1562: IF SQL%FOUND THEN
1563: IF l_debug_on THEN

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

1560: WHERE delivery_id = l_delivery_id;
1561:
1562: IF SQL%FOUND THEN
1563: IF l_debug_on THEN
1564: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_new_deliveries: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1565: END IF;
1566: END IF;
1567:
1568: END LOOP;

Line 2859: wsh_new_deliveries wnd,

2855: SELECT wdd.lpn_id
2856: FROM wsh_trips wt,
2857: wsh_trip_stops wts,
2858: wsh_delivery_legs wdl,
2859: wsh_new_deliveries wnd,
2860: wsh_delivery_assignments_v wda,
2861: wsh_delivery_details wdd
2862: WHERE wt.trip_id = wts.trip_id
2863: AND wts.stop_id = wdl.pick_up_stop_id

Line 2898: wsh_new_deliveries wnd,

2894: FROM wsh_delivery_legs
2895: WHERE parent_delivery_leg_id IS NULL
2896: START WITH delivery_id IN (SELECT wdl.delivery_id
2897: FROM
2898: wsh_new_deliveries wnd,
2899: wsh_delivery_legs wdl,
2900: wsh_trip_stops pickup_stop,
2901: wsh_trip_stops dropoff_stop,
2902: wsh_trips wt