APPS.WSH_PURGE dependencies on WSH_TRIPS

Line 404: FROM wsh_trips wt,

400: c_wdd_purge_cur PurgeCurType;
401:
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

Line 712: FROM wsh_trips wt,

708: --end construct delivery_sql
709:
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 ';

Line 1219: WSH_EXCEPTIONS, WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES,WSH_TRIPS

1215: Input: Table of Record Types for Trips
1216: Output: Return Status - success or failure
1217: ==============================================================================
1218: Logic: i) Delete records from the following tables:
1219: WSH_EXCEPTIONS, WSH_FREIGHT_COSTS, WSH_DOCUMENT_INSTANCES,WSH_TRIPS
1220: -----------------------------------------------------------------------------*/
1221:
1222: PROCEDURE Purge_Trips( p_tbl_trip_purge_set Trip_ID_Tbl_Type,
1223: x_return_status OUT NOCOPY VARCHAR2

Line 1274: AND entity_name = 'WSH_TRIPS';

1270:
1271: DELETE
1272: FROM wsh_document_instances
1273: WHERE entity_id = l_trip_id
1274: AND entity_name = 'WSH_TRIPS';
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: TRIP_ID=' || l_trip_id, WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1283: FROM wsh_trips

1279: END IF;
1280: END IF;
1281:
1282: DELETE
1283: FROM wsh_trips
1284: WHERE trip_id = l_trip_id;
1285:
1286: IF SQL%FOUND THEN
1287: IF l_debug_on THEN

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

1284: WHERE trip_id = l_trip_id;
1285:
1286: IF SQL%FOUND THEN
1287: IF l_debug_on THEN
1288: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_trips: TRIP_ID=' || l_trip_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1289: END IF;
1290: END IF;
1291:
1292: END LOOP;

Line 2856: FROM wsh_trips wt,

2852: l_tbl_trip_mdc WSH_UTIL_CORE.ID_TAB_TYPE;
2853:
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,

Line 2882: wsh_trips wt1,

2878: CURSOR c_get_mdc_trips(p_tripid NUMBER) IS
2879: SELECT
2880: DISTINCT wt1.trip_id
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

Line 2902: wsh_trips wt

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
2904: wnd.delivery_id = wdl.delivery_id AND
2905: wdl.pick_up_stop_id = pickup_stop.stop_id AND
2906: wdl.drop_off_stop_id = dropoff_stop.stop_id AND

Line 2923: wsh_trips wt1,

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

Line 2941: wsh_trips wt

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