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_TMS_RELEASE dependencies on WSH_TRIP_STOPS

Line 351: wsh_trip_stops_interface wtsi,

347: AND wt.tp_plan_name(+) = wti.tp_plan_name
348: AND wti.group_id in
349: (SELECT wti.group_id FROM wsh_new_del_interface wndi,
350: wsh_del_legs_interface wdli,
351: wsh_trip_stops_interface wtsi,
352: wsh_trips_interface wti,
353: wsh_new_deliveries wnd
354: where wndi.interface_action_code IN (G_TMS_RELEASE_CODE,G_TMS_DELETE_CODE)
355: AND wdli.delivery_interface_id = wndi.delivery_interface_id

Line 480: FROM wsh_trip_stops_interface wtsi,

476: null attribute12,
477: null attribute13,
478: null attribute14,
479: null attribute15
480: FROM wsh_trip_stops_interface wtsi,
481: wsh_trips_interface wti
482: WHERE wti.group_id = p_group_id --p_group_id is the input parameter
483: AND wtsi.trip_interface_id = wti.trip_interface_id
484: AND wtsi.interface_action_code = G_TMS_RELEASE_CODE

Line 542: FROM wsh_trip_stops_interface wtsi,

538: null attribute12,
539: null attribute13,
540: null attribute14,
541: null attribute15
542: FROM wsh_trip_stops_interface wtsi,
543: wsh_trips_interface wti
544: WHERE wti.tp_plan_name >= nvl(p_tp_plan_low,wti.tp_plan_name)
545: AND wti.tp_plan_name <= nvl(p_tp_plan_high,wti.tp_plan_name)
546: AND wtsi.trip_interface_id = wti.trip_interface_id

Line 605: FROM wsh_trip_stops_interface wtsi,

601: null attribute12,
602: null attribute13,
603: null attribute14,
604: null attribute15
605: FROM wsh_trip_stops_interface wtsi,
606: wsh_trips_interface wti
607: WHERE wtsi.trip_interface_id = wti.trip_interface_id
608: AND wtsi.interface_action_code = G_TMS_RELEASE_CODE
609: AND wti.interface_action_code = G_TMS_RELEASE_CODE

Line 613: wsh_trip_stops_interface wtsi,

609: AND wti.interface_action_code = G_TMS_RELEASE_CODE
610: AND wti.group_id in
611: (SELECT wti.group_id FROM wsh_new_del_interface wndi,
612: wsh_del_legs_interface wdli,
613: wsh_trip_stops_interface wtsi,
614: wsh_trips_interface wti,
615: wsh_new_deliveries wnd
616: where wndi.interface_action_code IN (G_TMS_RELEASE_CODE,G_TMS_DELETE_CODE)
617: AND wdli.delivery_interface_id = wndi.delivery_interface_id

Line 682: FROM wsh_trip_stops_interface wtsi,

678: null attribute12,
679: null attribute13,
680: null attribute14,
681: null attribute15
682: FROM wsh_trip_stops_interface wtsi,
683: wsh_trips_interface wti
684: WHERE wtsi.trip_interface_id = wti.trip_interface_id
685: AND wtsi.interface_action_code = G_TMS_RELEASE_CODE
686: AND wti.interface_action_code = G_TMS_RELEASE_CODE

Line 714: wsh_trip_stops_interface wtsi_pu,

710: 'N' processed_flag, -- used to indicate which deliveries have to be assigned
711: wnd.tms_interface_flag -- used to check whether tms version check can be avoided.
712: FROM wsh_del_legs_interface wdli,
713: wsh_new_del_interface wndi,
714: wsh_trip_stops_interface wtsi_pu,
715: wsh_trip_stops_interface wtsi_do,
716: wsh_trips_interface wti,
717: wsh_new_deliveries wnd
718: WHERE wti.group_id = p_group_id --p_group_id is the input parameter

Line 715: wsh_trip_stops_interface wtsi_do,

711: wnd.tms_interface_flag -- used to check whether tms version check can be avoided.
712: FROM wsh_del_legs_interface wdli,
713: wsh_new_del_interface wndi,
714: wsh_trip_stops_interface wtsi_pu,
715: wsh_trip_stops_interface wtsi_do,
716: wsh_trips_interface wti,
717: wsh_new_deliveries wnd
718: WHERE wti.group_id = p_group_id --p_group_id is the input parameter
719: AND wti.interface_action_code = G_TMS_RELEASE_CODE

Line 761: wsh_trip_stops_interface wtsi_pu,

757: 'N' processed_flag, -- used to indicate which deliveries have to be assigned
758: wnd.tms_interface_flag -- used to check whether tms version check can be avoided.
759: FROM wsh_del_legs_interface wdli,
760: wsh_new_del_interface wndi,
761: wsh_trip_stops_interface wtsi_pu,
762: wsh_trip_stops_interface wtsi_do,
763: wsh_trips_interface wti,
764: wsh_new_deliveries wnd
765: WHERE wti.tp_plan_name >= nvl(p_tp_plan_low,wti.tp_plan_name)

Line 762: wsh_trip_stops_interface wtsi_do,

758: wnd.tms_interface_flag -- used to check whether tms version check can be avoided.
759: FROM wsh_del_legs_interface wdli,
760: wsh_new_del_interface wndi,
761: wsh_trip_stops_interface wtsi_pu,
762: wsh_trip_stops_interface wtsi_do,
763: wsh_trips_interface wti,
764: wsh_new_deliveries wnd
765: WHERE wti.tp_plan_name >= nvl(p_tp_plan_low,wti.tp_plan_name)
766: AND wti.tp_plan_name <= nvl(p_tp_plan_high,wti.tp_plan_name)

Line 809: wsh_trip_stops_interface wtsi_pu,

805: 'N' processed_flag, -- used to indicate which deliveries have to be assigned
806: wnd.tms_interface_flag -- used to check whether tms version check can be avoided.
807: FROM wsh_del_legs_interface wdli,
808: wsh_new_del_interface wndi,
809: wsh_trip_stops_interface wtsi_pu,
810: wsh_trip_stops_interface wtsi_do,
811: wsh_trips_interface wti,
812: wsh_new_deliveries wnd
813: WHERE wti.interface_action_code = G_TMS_RELEASE_CODE

Line 810: wsh_trip_stops_interface wtsi_do,

806: wnd.tms_interface_flag -- used to check whether tms version check can be avoided.
807: FROM wsh_del_legs_interface wdli,
808: wsh_new_del_interface wndi,
809: wsh_trip_stops_interface wtsi_pu,
810: wsh_trip_stops_interface wtsi_do,
811: wsh_trips_interface wti,
812: wsh_new_deliveries wnd
813: WHERE wti.interface_action_code = G_TMS_RELEASE_CODE
814: AND wtsi_pu.trip_interface_id = wti.trip_interface_id

Line 827: wsh_trip_stops_interface wtsi,

823: AND wdli.interface_action_code = G_TMS_RELEASE_CODE
824: AND wti.group_id in
825: (SELECT wti.group_id FROM wsh_new_del_interface wndi,
826: wsh_del_legs_interface wdli,
827: wsh_trip_stops_interface wtsi,
828: wsh_trips_interface wti,
829: wsh_new_deliveries wnd
830: where wndi.interface_action_code IN (G_TMS_RELEASE_CODE,G_TMS_DELETE_CODE)
831: AND wdli.delivery_interface_id = wndi.delivery_interface_id

Line 866: wsh_trip_stops_interface wtsi_pu,

862: 'N' processed_flag, -- used to indicate which deliveries have to be assigned
863: wnd.tms_interface_flag -- used to check whether tms version check can be avoided.
864: FROM wsh_del_legs_interface wdli,
865: wsh_new_del_interface wndi,
866: wsh_trip_stops_interface wtsi_pu,
867: wsh_trip_stops_interface wtsi_do,
868: wsh_trips_interface wti,
869: wsh_new_deliveries wnd
870: WHERE wti.interface_action_code = G_TMS_RELEASE_CODE

Line 867: wsh_trip_stops_interface wtsi_do,

863: wnd.tms_interface_flag -- used to check whether tms version check can be avoided.
864: FROM wsh_del_legs_interface wdli,
865: wsh_new_del_interface wndi,
866: wsh_trip_stops_interface wtsi_pu,
867: wsh_trip_stops_interface wtsi_do,
868: wsh_trips_interface wti,
869: wsh_new_deliveries wnd
870: WHERE wti.interface_action_code = G_TMS_RELEASE_CODE
871: AND wtsi_pu.trip_interface_id = wti.trip_interface_id

Line 925: FROM wsh_trip_stops

921: attribute12,
922: attribute13,
923: attribute14,
924: attribute15
925: FROM wsh_trip_stops
926: WHERE trip_id = p_trip_id;
927:
928: -- Find Deliveries associated to a stop
929: -- GC3 sends only physical stops back to EBS

Line 950: wsh_trip_stops wts

946: UNION
947: SELECT wdl.delivery_id, wnd.organization_id,wnd.tms_version_number
948: FROM wsh_delivery_legs wdl,
949: wsh_new_deliveries wnd,
950: wsh_trip_stops wts
951: WHERE wdl.drop_off_stop_id = wts.stop_id
952: AND wnd.delivery_id = wdl.delivery_id
953: AND wts.physical_stop_id = p_stop_id;
954:

Line 1003: wsh_trip_stops_interface wtsi ,

999: wdli.delivery_leg_interface_id,
1000: wtsi.stop_interface_id,
1001: wfci.freight_cost_interface_id
1002: from wsh_trips_interface wti ,
1003: wsh_trip_stops_interface wtsi ,
1004: wsh_del_legs_interface wdli ,
1005: wsh_freight_costs_interface wfci,
1006: wsh_new_del_interface wndi
1007: where wti.trip_interface_id = c_trip_interface_id --Bug7717569

Line 1383: from wsh_trip_stops_interface wtsi,

1379: DELETE from wsh_interface_errors wie
1380: WHERE wie.interface_table_name = 'WSH_NEW_DEL_INTERFACE'
1381: AND wie.interface_id in (
1382: select wdli.delivery_interface_id
1383: from wsh_trip_stops_interface wtsi,
1384: wsh_del_legs_interface wdli
1385: where wtsi.trip_interface_id = l_del_wti_tab(i)
1386: and wtsi.stop_interface_id = wdli.pick_up_stop_interface_id
1387: and wtsi.interface_action_code = G_TMS_RELEASE_CODE

Line 1396: from wsh_trip_stops_interface wtsi,

1392: FORALL i in l_del_wti_tab.FIRST..l_del_wti_tab.LAST
1393: DELETE from WSH_EXCEPTIONS we
1394: WHERE we.delivery_id in (
1395: select wdli.delivery_id
1396: from wsh_trip_stops_interface wtsi,
1397: wsh_del_legs_interface wdli
1398: where wtsi.trip_interface_id = l_del_wti_tab(i)
1399: and wtsi.stop_interface_id = wdli.pick_up_stop_interface_id
1400: and wtsi.interface_action_code = G_TMS_RELEASE_CODE

Line 1496: wsh_trip_stops_pvt.lock_trip_stop_no_compare(

1492: BEGIN--{
1493: FOR rec in c_get_stops(l_trip_info_tab(i).trip_id)
1494: LOOP
1495: l_stop_id := rec.stop_id;
1496: wsh_trip_stops_pvt.lock_trip_stop_no_compare(
1497: p_stop_id => rec.stop_id);
1498: END LOOP;
1499:
1500: EXCEPTION

Line 1503: FND_MESSAGE.SET_TOKEN('STOP_NAME',WSH_TRIP_STOPS_PVT.get_name(l_stop_id,'FTE_TMS_INTEGRATION'));

1499:
1500: EXCEPTION
1501: WHEN OTHERS THEN
1502: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_STOP');
1503: FND_MESSAGE.SET_TOKEN('STOP_NAME',WSH_TRIP_STOPS_PVT.get_name(l_stop_id,'FTE_TMS_INTEGRATION'));
1504: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1505: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1506: IF l_debug_on THEN
1507: WSH_DEBUG_SV.log(l_module_name, 'trip stop not locked: l_return_status', l_return_status);

Line 1934: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;

1930: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
1931: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
1932: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
1933:
1934: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
1935: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
1936: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
1937: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
1938: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;

Line 1935: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;

1931: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
1932: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
1933:
1934: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
1935: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
1936: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
1937: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
1938: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
1939: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;

Line 1936: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;

1932: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
1933:
1934: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
1935: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
1936: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
1937: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
1938: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
1939: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
1940: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.stop_wt_vol_tab_type;

Line 1937: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;

1933:
1934: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
1935: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
1936: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
1937: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
1938: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
1939: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
1940: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.stop_wt_vol_tab_type;
1941:

Line 1938: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;

1934: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
1935: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
1936: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
1937: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
1938: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
1939: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
1940: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.stop_wt_vol_tab_type;
1941:
1942: l_del_count NUMBER;

Line 1939: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;

1935: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
1936: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
1937: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
1938: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
1939: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
1940: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.stop_wt_vol_tab_type;
1941:
1942: l_del_count NUMBER;
1943: l_stop_count NUMBER;

Line 1940: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.stop_wt_vol_tab_type;

1936: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
1937: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
1938: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
1939: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
1940: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.stop_wt_vol_tab_type;
1941:
1942: l_del_count NUMBER;
1943: l_stop_count NUMBER;
1944:

Line 2271: -- ii. Call WSH_TRIP_STOPS_GRP.Stop_Action() to DELETE

2267: GOTO trip_error;
2268: END IF;
2269: END IF;--}
2270:
2271: -- ii. Call WSH_TRIP_STOPS_GRP.Stop_Action() to DELETE
2272: l_stop_action_prms.caller := 'FTE_TMS_INTEGRATION';
2273: l_stop_action_prms.action_code := 'DELETE';
2274: l_stop_attrs(1).stop_id := rec.stop_id;
2275: l_stop_attrs(1).trip_id := l_trip_info_tab(i).trip_id;

Line 2277: WSH_TRIP_STOPS_GRP.stop_action(

2273: l_stop_action_prms.action_code := 'DELETE';
2274: l_stop_attrs(1).stop_id := rec.stop_id;
2275: l_stop_attrs(1).trip_id := l_trip_info_tab(i).trip_id;
2276:
2277: WSH_TRIP_STOPS_GRP.stop_action(
2278: p_api_version_number => 1.0,
2279: p_init_msg_list => FND_API.G_TRUE,
2280: p_commit => FND_API.G_FALSE,
2281: p_action_prms => l_stop_action_prms,

Line 2537: wsh_trip_stops_grp.Create_Update_Stop(

2533: WSH_DEBUG_SV.logmsg(l_module_name,'Stop Vol UOM:'||l_stop_local_tab(stop_rec).volume_uom_code);
2534: WSH_DEBUG_SV.logmsg(l_module_name,'Before Calling Create_update_Stop,count:'||l_stop_attrs.count);
2535: END IF;
2536:
2537: wsh_trip_stops_grp.Create_Update_Stop(
2538: p_api_version_number => 1.0,
2539: p_init_msg_list => FND_API.G_FALSE,
2540: p_commit => FND_API.G_FALSE,
2541: p_in_rec => l_stop_in_rec,

Line 2577: wsh_trip_stops_interface wtsi,

2573: SELECT wtsi.dock_name, wnd.organization_id, wtsi.start_time, wtsi.end_time
2574: FROM wsh_del_legs_interface wdli,
2575: wsh_new_del_interface wndi,
2576: wsh_new_deliveries wnd,
2577: wsh_trip_stops_interface wtsi,
2578: wsh_trips_interface wti
2579: WHERE wti.group_id = c_group_id
2580: AND wti.interface_action_code = G_TMS_RELEASE_CODE
2581: AND wtsi.trip_interface_id = wti.trip_interface_id

Line 2691: from wsh_trip_stops

2687: DECLARE
2688: CURSOR c_1 IS
2689: select stop_id,stop_location_id,stop_sequence_number,
2690: physical_stop_id,physical_location_id
2691: from wsh_trip_stops
2692: where stop_id = l_stop_local_tab(stop_rec).stop_id;
2693: BEGIN
2694: FOR st in c_1
2695: LOOP

Line 3564: wsh_trip_stops wts

3560: DECLARE
3561: CURSOR c_stops (c_trip_id IN number) IS
3562: SELECT wts.stop_id stop_id
3563: FROM wsh_trips wt,
3564: wsh_trip_stops wts
3565: WHERE wt.trip_id = c_trip_id
3566: AND wt.trip_id = wts.trip_id
3567: ORDER BY wts.stop_sequence_number DESC;
3568:

Line 4180: -- Purge records in wsh_trip_stops_interface

4176: -- Corrections Form)
4177: -- Purge any records in wsh_interface_errors
4178: -- Purge records in wsh_new_del_interface
4179: -- Purge records in wsh_del_legs_interface
4180: -- Purge records in wsh_trip_stops_interface
4181: -- Purge records in wsh_trips_interface
4182: -- Index exists on group_id and trip_interface_id of wsh_trips_interface,
4183: -- so use trip_interface_id.
4184: --

Line 4262: from wsh_trip_stops_interface wtsi,

4258: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST
4259: Delete from wsh_freight_costs_interface wfci
4260: where wfci.delivery_interface_id in (
4261: select wdli.delivery_interface_id
4262: from wsh_trip_stops_interface wtsi,
4263: wsh_del_legs_interface wdli
4264: where wtsi.trip_interface_id = l_trip_interface_id_tab(i)
4265: and wtsi.stop_interface_id = wdli.pick_up_stop_interface_id
4266: and wtsi.interface_action_code = G_TMS_RELEASE_CODE

Line 4280: from wsh_trip_stops_interface wtsi,

4276: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST
4277: DELETE from WSH_EXCEPTIONS we
4278: WHERE we.delivery_id in (
4279: select wdli.delivery_id
4280: from wsh_trip_stops_interface wtsi,
4281: wsh_del_legs_interface wdli
4282: where wtsi.trip_interface_id = l_trip_interface_id_tab(i)
4283: and wtsi.stop_interface_id = wdli.pick_up_stop_interface_id
4284: and wtsi.interface_action_code = G_TMS_RELEASE_CODE

Line 4299: from wsh_trip_stops_interface wtsi,

4295: UPDATE WSH_EXCEPTIONS we
4296: SET status = 'CLOSED'
4297: WHERE we.delivery_id in (
4298: select wdli.delivery_id
4299: from wsh_trip_stops_interface wtsi,
4300: wsh_del_legs_interface wdli
4301: where wtsi.trip_interface_id = l_trip_interface_id_tab(i)
4302: and wtsi.stop_interface_id = wdli.pick_up_stop_interface_id
4303: and wtsi.interface_action_code = G_TMS_RELEASE_CODE

Line 4311: -- table_name can be WSH_NEW_DEL_INTERFACE, WSH_TRIP_STOPS_INTERFACE,

4307: END IF;--}
4308:
4309: -- Purge wsh_interface_errors
4310: -- for each of the above entity, there could be errors logged in wsh_interface_errors
4311: -- table_name can be WSH_NEW_DEL_INTERFACE, WSH_TRIP_STOPS_INTERFACE,
4312: -- WSH_TRIPS_INTERFACE
4313:
4314: IF l_debug_on THEN
4315: WSH_DEBUG_SV.logmsg(l_module_name,'Start Purging Interface Errors Data for delivery');

Line 4323: from wsh_trip_stops_interface wtsi,

4319: Delete from wsh_interface_errors wie
4320: where wie.interface_table_name = 'WSH_NEW_DEL_INTERFACE'
4321: and wie.interface_id in (
4322: select wdli.delivery_interface_id
4323: from wsh_trip_stops_interface wtsi,
4324: wsh_del_legs_interface wdli
4325: where wtsi.trip_interface_id = l_trip_interface_id_tab(i)
4326: and wtsi.stop_interface_id = wdli.pick_up_stop_interface_id
4327: and wtsi.interface_action_code = G_TMS_RELEASE_CODE

Line 4337: where wie.interface_table_name = 'WSH_TRIP_STOPS_INTERFACE'

4333: END IF;
4334: -- Delete errors logged for trip stops
4335: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST
4336: Delete from wsh_interface_errors wie
4337: where wie.interface_table_name = 'WSH_TRIP_STOPS_INTERFACE'
4338: and wie.interface_id in (
4339: select wtsi.stop_interface_id
4340: from wsh_trip_stops_interface wtsi
4341: where wtsi.trip_interface_id = l_trip_interface_id_tab(i)

Line 4340: from wsh_trip_stops_interface wtsi

4336: Delete from wsh_interface_errors wie
4337: where wie.interface_table_name = 'WSH_TRIP_STOPS_INTERFACE'
4338: and wie.interface_id in (
4339: select wtsi.stop_interface_id
4340: from wsh_trip_stops_interface wtsi
4341: where wtsi.trip_interface_id = l_trip_interface_id_tab(i)
4342: and wtsi.interface_action_code = G_TMS_RELEASE_CODE)
4343: and wie.interface_action_code = G_TMS_RELEASE_CODE;
4344:

Line 4363: from wsh_trip_stops_interface wtsi,

4359: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST
4360: Delete from wsh_new_del_interface wndi
4361: where wndi.delivery_interface_id in (
4362: select wdli.delivery_interface_id
4363: from wsh_trip_stops_interface wtsi,
4364: wsh_del_legs_interface wdli
4365: where wtsi.trip_interface_id = l_trip_interface_id_tab(i)
4366: and wtsi.stop_interface_id = wdli.pick_up_stop_interface_id
4367: and wtsi.interface_action_code = G_TMS_RELEASE_CODE

Line 4379: from wsh_trip_stops_interface wtsi

4375: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST
4376: Delete from wsh_del_legs_interface wdli
4377: where wdli.pick_up_stop_interface_id in (
4378: select wtsi.stop_interface_id
4379: from wsh_trip_stops_interface wtsi
4380: where wtsi.trip_interface_id = l_trip_interface_id_tab(i)
4381: and wtsi.interface_action_code = G_TMS_RELEASE_CODE)
4382: and wdli.interface_action_code = G_TMS_RELEASE_CODE;
4383:

Line 4384: -- Purge wsh_trip_stops_interface

4380: where wtsi.trip_interface_id = l_trip_interface_id_tab(i)
4381: and wtsi.interface_action_code = G_TMS_RELEASE_CODE)
4382: and wdli.interface_action_code = G_TMS_RELEASE_CODE;
4383:
4384: -- Purge wsh_trip_stops_interface
4385: IF l_debug_on THEN
4386: WSH_DEBUG_SV.logmsg(l_module_name,'Start Purging Trip Stops Interface Data');
4387: END IF;
4388: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST

Line 4389: Delete from wsh_trip_stops_interface wtsi

4385: IF l_debug_on THEN
4386: WSH_DEBUG_SV.logmsg(l_module_name,'Start Purging Trip Stops Interface Data');
4387: END IF;
4388: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST
4389: Delete from wsh_trip_stops_interface wtsi
4390: where wtsi.trip_interface_id = l_trip_interface_id_tab(i)
4391: and wtsi.interface_action_code = G_TMS_RELEASE_CODE;
4392:
4393: -- Purge wsh_trips_interface

Line 4688: wsh_trip_stops wts,

4684: wnd.organization_id,
4685: wnd.name,
4686: wnd.status_code
4687: FROM wsh_delivery_legs wdl,
4688: wsh_trip_stops wts,
4689: wsh_new_deliveries wnd
4690: WHERE wdl.pick_up_stop_id = wts.stop_id
4691: AND wts.trip_id = p_trip_id
4692: AND wdl.delivery_id = wnd.delivery_id(+);

Line 4702: wsh_trip_stops wts,

4698: wnd.organization_id,
4699: wnd.name,
4700: wnd.status_code
4701: FROM wsh_delivery_legs wdl,
4702: wsh_trip_stops wts,
4703: wsh_trips wt,
4704: wsh_new_deliveries wnd
4705: WHERE wdl.pick_up_stop_id = wts.stop_id
4706: AND wts.trip_id = wt.trip_id

Line 4810: wsh_trip_stops wts_pu,

4806: wts_do.stop_location_id dropoff_stop_location_id,
4807: wts_do.stop_sequence_number dropoff_stop_sequence,
4808: wts_pu.trip_id trip_id
4809: FROM wsh_delivery_legs wdl,
4810: wsh_trip_stops wts_pu,
4811: wsh_trip_stops wts_do
4812: WHERE wdl.delivery_id = p_delivery_id
4813: AND wdl.pick_up_stop_id = wts_pu.stop_id
4814: AND wdl.drop_off_stop_id = wts_do.stop_id ;

Line 4811: wsh_trip_stops wts_do

4807: wts_do.stop_sequence_number dropoff_stop_sequence,
4808: wts_pu.trip_id trip_id
4809: FROM wsh_delivery_legs wdl,
4810: wsh_trip_stops wts_pu,
4811: wsh_trip_stops wts_do
4812: WHERE wdl.delivery_id = p_delivery_id
4813: AND wdl.pick_up_stop_id = wts_pu.stop_id
4814: AND wdl.drop_off_stop_id = wts_do.stop_id ;
4815: