eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_PURGE dependencies on WSH_DELIVERY_LEGS

Line 399: wsh_delivery_legs wdl,

395: CURSOR c_dels_for_trip(p_tripid NUMBER) IS
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

Line 413: FROM wsh_delivery_legs

409: WHERE trip_id= p_tripid;
410:
411: CURSOR c_legs_for_del(p_deliveryid NUMBER) IS
412: SELECT delivery_leg_id
413: FROM wsh_delivery_legs
414: WHERE delivery_id = p_deliveryid;
415:
416: CURSOR c_details_for_del(p_deliveryid NUMBER) IS
417: SELECT wda.delivery_detail_id,

Line 436: wsh_delivery_legs wdl

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(+)
439: AND wdl.delivery_leg_id IS NULL
440: AND NOT EXISTS (

Line 612: wsh_delivery_legs wdl

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
615: wnd.delivery_id = wdl.delivery_id(+) AND
616: wdl.delivery_leg_id IS NULL AND

Line 639: wsh_delivery_legs wdl1,

635: --construct SQL for empty trips
636: empty_trip_sql := ' SELECT distinct wt.trip_id, wt.name
637: FROM wsh_trips wt,
638: wsh_trip_stops wts,
639: wsh_delivery_legs wdl1,
640: wsh_delivery_legs wdl2
641: WHERE ';
642:
643: --check for taking creation dates

Line 640: wsh_delivery_legs wdl2

636: empty_trip_sql := ' SELECT distinct wt.trip_id, wt.name
637: FROM wsh_trips wt,
638: wsh_trip_stops wts,
639: wsh_delivery_legs wdl1,
640: wsh_delivery_legs wdl2
641: WHERE ';
642:
643: --check for taking creation dates
644: IF (p_create_date_from IS NOT NULL) THEN

Line 664: wsh_delivery_legs wdl1s

660: AND wdl2.delivery_leg_id IS NULL
661: AND NOT EXISTS
662: ( SELECT 1
663: FROM wsh_trip_stops wtss,
664: wsh_delivery_legs wdl1s
665: WHERE wtss.trip_id = wt.trip_id
666: AND wdl1s.pick_up_stop_id = wtss.stop_id
667: )
668: ' ;

Line 1566: WSH_DELIVERY_LEG_DETAILS, WSH_DELIVERY_LEGS

1562: Output: Return Status - success or failure
1563: ==============================================================================
1564: Logic: i) Delete records from the following tables:
1565: WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES, WSH_DELIVERY_LEG_ACTIVITIES,
1566: WSH_DELIVERY_LEG_DETAILS, WSH_DELIVERY_LEGS
1567:
1568: If FTE is installed,
1569: FTE_INVOICE_LINES, FTE_INVOICE_HISTORY, FTE_INVOICE_HEADERS,
1570: FTE_FAILURE_REASONS

Line 1618: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'

1614: WHERE invoice_header_id IN ( SELECT fih.invoice_header_id
1615: FROM fte_invoice_headers fih,
1616: wsh_document_instances wdi
1617: WHERE wdi.entity_id = l_leg_id
1618: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'
1619: AND wdi.sequence_number = fih.bol
1620: ) ;
1621: IF SQL%FOUND THEN
1622: IF l_debug_on THEN

Line 1632: AND entity_name = 'WSH_DELIVERY_LEGS') ;

1628: FROM fte_invoice_headers
1629: WHERE bol IN (SELECT sequence_number
1630: FROM wsh_document_instances
1631: WHERE entity_id = l_leg_id
1632: AND entity_name = 'WSH_DELIVERY_LEGS') ;
1633:
1634: IF SQL%FOUND THEN
1635: IF l_debug_on THEN
1636: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_invoice_headers: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1645: AND entity_name = 'WSH_DELIVERY_LEGS') ;

1641: FROM fte_invoice_history
1642: WHERE bol IN (SELECT sequence_number
1643: FROM wsh_document_instances
1644: WHERE entity_id = l_leg_id
1645: AND entity_name = 'WSH_DELIVERY_LEGS') ;
1646:
1647: IF SQL%FOUND THEN
1648: IF l_debug_on THEN
1649: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_invoice_history: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1658: AND entity_name = 'WSH_DELIVERY_LEGS') ;

1654: FROM fte_failure_reasons
1655: WHERE bol IN ( SELECT sequence_number
1656: FROM wsh_document_instances
1657: WHERE entity_id = l_leg_id
1658: AND entity_name = 'WSH_DELIVERY_LEGS') ;
1659:
1660: IF SQL%FOUND THEN
1661: IF l_debug_on THEN
1662: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_failure_reasons: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1671: AND entity_name = 'WSH_DELIVERY_LEGS';

1667:
1668: DELETE
1669: FROM wsh_document_instances
1670: WHERE entity_id = l_leg_id
1671: AND entity_name = 'WSH_DELIVERY_LEGS';
1672:
1673: IF SQL%FOUND THEN
1674: IF l_debug_on THEN
1675: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_document_instances: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1701: FROM wsh_delivery_legs

1697: END IF;
1698:
1699:
1700: DELETE
1701: FROM wsh_delivery_legs
1702: WHERE delivery_leg_id = l_leg_id ;
1703:
1704: IF SQL%FOUND THEN
1705: IF l_debug_on THEN

Line 1706: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_delivery_legs: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);

1702: WHERE delivery_leg_id = l_leg_id ;
1703:
1704: IF SQL%FOUND THEN
1705: IF l_debug_on THEN
1706: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_delivery_legs: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1707: END IF;
1708: END IF;
1709: END LOOP;
1710:

Line 2671: wsh_delivery_legs wdl,

2667: CURSOR c_lpns_for_trip(p_tripid NUMBER) IS
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

Line 2698: wsh_delivery_legs wdl1

2694: FROM
2695: wsh_trips wt1,
2696: wsh_trip_stops pickup_stop1,
2697: wsh_trip_stops dropoff_stop1,
2698: wsh_delivery_legs wdl1
2699: WHERE
2700: wdl1.pick_up_stop_id = pickup_stop1.stop_id AND
2701: wdl1.drop_off_stop_id = dropoff_stop1.stop_id AND
2702: wt1.trip_id = pickup_stop1.trip_id AND

Line 2705: FROM wsh_delivery_legs

2701: wdl1.drop_off_stop_id = dropoff_stop1.stop_id AND
2702: wt1.trip_id = pickup_stop1.trip_id AND
2703: wt1.trip_id = dropoff_stop1.trip_id AND
2704: wdl1.delivery_id IN (SELECT delivery_id
2705: FROM wsh_delivery_legs
2706: START WITH delivery_id IN (SELECT delivery_id
2707: FROM wsh_delivery_legs
2708: WHERE parent_delivery_leg_id IS NULL
2709: START WITH delivery_id IN (SELECT wdl.delivery_id

Line 2707: FROM wsh_delivery_legs

2703: wt1.trip_id = dropoff_stop1.trip_id AND
2704: wdl1.delivery_id IN (SELECT delivery_id
2705: FROM wsh_delivery_legs
2706: START WITH delivery_id IN (SELECT delivery_id
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,

Line 2712: wsh_delivery_legs wdl,

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
2716: WHERE

Line 2738: wsh_delivery_legs wdl1

2734: DISTINCT wt1.trip_id
2735: FROM
2736: wsh_trips wt1,
2737: wsh_trip_stops wts,
2738: wsh_delivery_legs wdl1
2739: WHERE
2740: (wdl1.pick_up_stop_id = wts.stop_id OR
2741: wdl1.drop_off_stop_id = wts.stop_id) AND
2742: wt1.trip_id = wts.trip_id AND

Line 2746: FROM wsh_delivery_legs

2742: wt1.trip_id = wts.trip_id AND
2743: wdl1.delivery_id IN
2744: (
2745: SELECT delivery_id
2746: FROM wsh_delivery_legs
2747: WHERE parent_delivery_leg_id
2748: IN
2749: (
2750: SELECT wdl.delivery_leg_id

Line 2752: wsh_delivery_legs wdl,

2748: IN
2749: (
2750: SELECT wdl.delivery_leg_id
2751: FROM
2752: wsh_delivery_legs wdl,
2753: wsh_trip_stops wts,
2754: wsh_trips wt
2755: WHERE
2756: (wdl.pick_up_stop_id = wts.stop_id OR