APPS.WSH_PURGE dependencies on WSH_TRIPS

Line 397: FROM wsh_trips wt,

393: c_empty_containers PurgeCurType;
394:
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

Line 637: FROM wsh_trips wt,

633: --end construct delivery_sql
634:
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 ';

Line 1094: WSH_EXCEPTIONS, WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES,WSH_TRIPS

1090: Input: Table of Record Types for Trips
1091: Output: Return Status - success or failure
1092: ==============================================================================
1093: Logic: i) Delete records from the following tables:
1094: WSH_EXCEPTIONS, WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES,WSH_TRIPS
1095: -----------------------------------------------------------------------------*/
1096:
1097: PROCEDURE Purge_Trips( p_tbl_trip_purge_set Trip_ID_Tbl_Type,
1098: x_return_status OUT NOCOPY VARCHAR2

Line 1149: AND entity_name = 'WSH_TRIPS';

1145:
1146: DELETE
1147: FROM wsh_document_instances
1148: WHERE entity_id = l_trip_id
1149: AND entity_name = 'WSH_TRIPS';
1150:
1151: IF SQL%FOUND THEN
1152: IF l_debug_on THEN
1153: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_document_instances: TRIP_ID=' || l_trip_id, WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1158: FROM wsh_trips

1154: END IF;
1155: END IF;
1156:
1157: DELETE
1158: FROM wsh_trips
1159: WHERE trip_id = l_trip_id;
1160:
1161: IF SQL%FOUND THEN
1162: IF l_debug_on THEN

Line 1163: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_trips: TRIP_ID=' || l_trip_id, WSH_DEBUG_SV.C_PROC_LEVEL);

1159: WHERE trip_id = l_trip_id;
1160:
1161: IF SQL%FOUND THEN
1162: IF l_debug_on THEN
1163: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_trips: TRIP_ID=' || l_trip_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1164: END IF;
1165: END IF;
1166:
1167: END LOOP;

Line 2669: FROM wsh_trips wt,

2665: l_tbl_trip_mdc WSH_UTIL_CORE.ID_TAB_TYPE;
2666:
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,

Line 2695: wsh_trips wt1,

2691: CURSOR c_get_mdc_trips(p_tripid NUMBER) IS
2692: SELECT
2693: DISTINCT wt1.trip_id
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

Line 2715: wsh_trips wt

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
2717: wnd.delivery_id = wdl.delivery_id AND
2718: wdl.pick_up_stop_id = pickup_stop.stop_id AND
2719: wdl.drop_off_stop_id = dropoff_stop.stop_id AND

Line 2736: wsh_trips wt1,

2732: CURSOR c_get_mdc_trips(p_tripid NUMBER) IS
2733: SELECT
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

Line 2754: wsh_trips wt

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
2757: wdl.drop_off_stop_id = wts.stop_id) AND
2758: wt.trip_id = wts.trip_id AND