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 406: wsh_delivery_legs wdl,

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

Line 420: FROM wsh_delivery_legs

416: WHERE trip_id= p_tripid;
417:
418: CURSOR c_legs_for_del(p_deliveryid NUMBER) IS
419: SELECT delivery_leg_id
420: FROM wsh_delivery_legs
421: WHERE delivery_id = p_deliveryid;
422:
423: --Bug 12397111 : Added union to fetch cancelled delivery lines while purging
424: CURSOR c_details_for_del(p_deliveryid NUMBER) IS

Line 456: wsh_delivery_legs wdl

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

Line 678: wsh_delivery_legs wdl

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

Line 714: wsh_delivery_legs wdl1,

710: --construct SQL for empty trips
711: empty_trip_sql := ' SELECT distinct wt.trip_id, wt.name
712: FROM wsh_trips wt,
713: wsh_trip_stops wts,
714: wsh_delivery_legs wdl1,
715: wsh_delivery_legs wdl2
716: WHERE ';
717:
718: --check for taking creation dates

Line 715: wsh_delivery_legs wdl2

711: empty_trip_sql := ' SELECT distinct wt.trip_id, wt.name
712: FROM wsh_trips wt,
713: wsh_trip_stops wts,
714: wsh_delivery_legs wdl1,
715: wsh_delivery_legs wdl2
716: WHERE ';
717:
718: --check for taking creation dates
719: --added TRUNC function for bug 12605679

Line 740: wsh_delivery_legs wdl1s

736: AND wdl2.delivery_leg_id IS NULL
737: AND NOT EXISTS
738: ( SELECT 1
739: FROM wsh_trip_stops wtss,
740: wsh_delivery_legs wdl1s
741: WHERE wtss.trip_id = wt.trip_id
742: AND wdl1s.pick_up_stop_id = wtss.stop_id
743: )' ;
744: --end contructing SQL for empty trips

Line 1691: WSH_DELIVERY_LEG_DETAILS, WSH_DELIVERY_LEGS

1687: Output: Return Status - success or failure
1688: ==============================================================================
1689: Logic: i) Delete records from the following tables:
1690: WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES, WSH_DELIVERY_LEG_ACTIVITIES,
1691: WSH_DELIVERY_LEG_DETAILS, WSH_DELIVERY_LEGS
1692:
1693: If FTE is installed,
1694: FTE_INVOICE_LINES, FTE_INVOICE_HISTORY, FTE_INVOICE_HEADERS,
1695: FTE_FAILURE_REASONS

Line 1743: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'

1739: WHERE invoice_header_id IN ( SELECT fih.invoice_header_id
1740: FROM fte_invoice_headers fih,
1741: wsh_document_instances wdi
1742: WHERE wdi.entity_id = l_leg_id
1743: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'
1744: AND wdi.sequence_number = fih.bol
1745: ) ;
1746: IF SQL%FOUND THEN
1747: IF l_debug_on THEN

Line 1757: AND entity_name = 'WSH_DELIVERY_LEGS') ;

1753: FROM fte_invoice_headers
1754: WHERE bol IN (SELECT sequence_number
1755: FROM wsh_document_instances
1756: WHERE entity_id = l_leg_id
1757: AND entity_name = 'WSH_DELIVERY_LEGS') ;
1758:
1759: IF SQL%FOUND THEN
1760: IF l_debug_on THEN
1761: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_invoice_headers: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1770: AND entity_name = 'WSH_DELIVERY_LEGS') ;

1766: FROM fte_invoice_history
1767: WHERE bol IN (SELECT sequence_number
1768: FROM wsh_document_instances
1769: WHERE entity_id = l_leg_id
1770: AND entity_name = 'WSH_DELIVERY_LEGS') ;
1771:
1772: IF SQL%FOUND THEN
1773: IF l_debug_on THEN
1774: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_invoice_history: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1783: AND entity_name = 'WSH_DELIVERY_LEGS') ;

1779: FROM fte_failure_reasons
1780: WHERE bol IN ( SELECT sequence_number
1781: FROM wsh_document_instances
1782: WHERE entity_id = l_leg_id
1783: AND entity_name = 'WSH_DELIVERY_LEGS') ;
1784:
1785: IF SQL%FOUND THEN
1786: IF l_debug_on THEN
1787: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_failure_reasons: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1796: AND entity_name = 'WSH_DELIVERY_LEGS';

1792:
1793: DELETE
1794: FROM wsh_document_instances
1795: WHERE entity_id = l_leg_id
1796: AND entity_name = 'WSH_DELIVERY_LEGS';
1797:
1798: IF SQL%FOUND THEN
1799: IF l_debug_on THEN
1800: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_document_instances: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1826: FROM wsh_delivery_legs

1822: END IF;
1823:
1824:
1825: DELETE
1826: FROM wsh_delivery_legs
1827: WHERE delivery_leg_id = l_leg_id ;
1828:
1829: IF SQL%FOUND THEN
1830: IF l_debug_on THEN

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

1827: WHERE delivery_leg_id = l_leg_id ;
1828:
1829: IF SQL%FOUND THEN
1830: IF l_debug_on THEN
1831: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_delivery_legs: LEG_ID=' || l_leg_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1832: END IF;
1833: END IF;
1834: END LOOP;
1835:

Line 2858: wsh_delivery_legs wdl,

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

Line 2885: wsh_delivery_legs wdl1

2881: FROM
2882: wsh_trips wt1,
2883: wsh_trip_stops pickup_stop1,
2884: wsh_trip_stops dropoff_stop1,
2885: wsh_delivery_legs wdl1
2886: WHERE
2887: wdl1.pick_up_stop_id = pickup_stop1.stop_id AND
2888: wdl1.drop_off_stop_id = dropoff_stop1.stop_id AND
2889: wt1.trip_id = pickup_stop1.trip_id AND

Line 2892: FROM wsh_delivery_legs

2888: wdl1.drop_off_stop_id = dropoff_stop1.stop_id AND
2889: wt1.trip_id = pickup_stop1.trip_id AND
2890: wt1.trip_id = dropoff_stop1.trip_id AND
2891: wdl1.delivery_id IN (SELECT delivery_id
2892: FROM wsh_delivery_legs
2893: START WITH delivery_id IN (SELECT delivery_id
2894: FROM wsh_delivery_legs
2895: WHERE parent_delivery_leg_id IS NULL
2896: START WITH delivery_id IN (SELECT wdl.delivery_id

Line 2894: FROM wsh_delivery_legs

2890: wt1.trip_id = dropoff_stop1.trip_id AND
2891: wdl1.delivery_id IN (SELECT delivery_id
2892: FROM wsh_delivery_legs
2893: START WITH delivery_id IN (SELECT delivery_id
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,

Line 2899: wsh_delivery_legs wdl,

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

Line 2925: wsh_delivery_legs wdl1

2921: DISTINCT wt1.trip_id
2922: FROM
2923: wsh_trips wt1,
2924: wsh_trip_stops wts,
2925: wsh_delivery_legs wdl1
2926: WHERE
2927: (wdl1.pick_up_stop_id = wts.stop_id OR
2928: wdl1.drop_off_stop_id = wts.stop_id) AND
2929: wt1.trip_id = wts.trip_id AND

Line 2933: FROM wsh_delivery_legs

2929: wt1.trip_id = wts.trip_id AND
2930: wdl1.delivery_id IN
2931: (
2932: SELECT delivery_id
2933: FROM wsh_delivery_legs
2934: WHERE parent_delivery_leg_id
2935: IN
2936: (
2937: SELECT wdl.delivery_leg_id

Line 2939: wsh_delivery_legs wdl,

2935: IN
2936: (
2937: SELECT wdl.delivery_leg_id
2938: FROM
2939: wsh_delivery_legs wdl,
2940: wsh_trip_stops wts,
2941: wsh_trips wt
2942: WHERE
2943: (wdl.pick_up_stop_id = wts.stop_id OR