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 353: wsh_trip_stops_interface wtsi,

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

Line 484: FROM wsh_trip_stops_interface wtsi,

480: null attribute12,
481: null attribute13,
482: null attribute14,
483: null attribute15
484: FROM wsh_trip_stops_interface wtsi,
485: wsh_trips_interface wti
486: WHERE wti.group_id = p_group_id --p_group_id is the input parameter
487: AND wtsi.trip_interface_id = wti.trip_interface_id
488: AND wtsi.interface_action_code = G_TMS_RELEASE_CODE

Line 546: FROM wsh_trip_stops_interface wtsi,

542: null attribute12,
543: null attribute13,
544: null attribute14,
545: null attribute15
546: FROM wsh_trip_stops_interface wtsi,
547: wsh_trips_interface wti
548: WHERE wti.tp_plan_name >= nvl(p_tp_plan_low,wti.tp_plan_name)
549: AND wti.tp_plan_name <= nvl(p_tp_plan_high,wti.tp_plan_name)
550: AND wtsi.trip_interface_id = wti.trip_interface_id

Line 609: FROM wsh_trip_stops_interface wtsi,

605: null attribute12,
606: null attribute13,
607: null attribute14,
608: null attribute15
609: FROM wsh_trip_stops_interface wtsi,
610: wsh_trips_interface wti
611: WHERE wtsi.trip_interface_id = wti.trip_interface_id
612: AND wtsi.interface_action_code = G_TMS_RELEASE_CODE
613: AND wti.interface_action_code = G_TMS_RELEASE_CODE

Line 617: wsh_trip_stops_interface wtsi,

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

Line 687: FROM wsh_trip_stops_interface wtsi,

683: null attribute12,
684: null attribute13,
685: null attribute14,
686: null attribute15
687: FROM wsh_trip_stops_interface wtsi,
688: wsh_trips_interface wti
689: WHERE wtsi.trip_interface_id = wti.trip_interface_id
690: AND wtsi.interface_action_code = G_TMS_RELEASE_CODE
691: AND wti.interface_action_code = G_TMS_RELEASE_CODE

Line 719: wsh_trip_stops_interface wtsi_pu,

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

Line 720: wsh_trip_stops_interface wtsi_do,

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

Line 766: wsh_trip_stops_interface wtsi_pu,

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

Line 767: wsh_trip_stops_interface wtsi_do,

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

Line 814: wsh_trip_stops_interface wtsi_pu,

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

Line 815: wsh_trip_stops_interface wtsi_do,

811: wnd.tms_interface_flag -- used to check whether tms version check can be avoided.
812: FROM wsh_del_legs_interface wdli,
813: wsh_new_del_interface wndi,
814: wsh_trip_stops_interface wtsi_pu,
815: wsh_trip_stops_interface wtsi_do,
816: wsh_trips_interface wti,
817: wsh_new_deliveries wnd
818: WHERE wti.interface_action_code = G_TMS_RELEASE_CODE
819: AND wtsi_pu.trip_interface_id = wti.trip_interface_id

Line 832: wsh_trip_stops_interface wtsi,

828: AND wdli.interface_action_code = G_TMS_RELEASE_CODE
829: AND wti.group_id in
830: (SELECT wti.group_id FROM wsh_new_del_interface wndi,
831: wsh_del_legs_interface wdli,
832: wsh_trip_stops_interface wtsi,
833: wsh_trips_interface wti,
834: wsh_new_deliveries wnd
835: where wndi.interface_action_code IN (G_TMS_RELEASE_CODE,G_TMS_DELETE_CODE)
836: AND wdli.delivery_interface_id = wndi.delivery_interface_id

Line 873: wsh_trip_stops_interface wtsi_pu,

869: 'N' processed_flag, -- used to indicate which deliveries have to be assigned
870: wnd.tms_interface_flag -- used to check whether tms version check can be avoided.
871: FROM wsh_del_legs_interface wdli,
872: wsh_new_del_interface wndi,
873: wsh_trip_stops_interface wtsi_pu,
874: wsh_trip_stops_interface wtsi_do,
875: wsh_trips_interface wti,
876: wsh_new_deliveries wnd
877: WHERE wti.interface_action_code = G_TMS_RELEASE_CODE

Line 874: wsh_trip_stops_interface wtsi_do,

870: wnd.tms_interface_flag -- used to check whether tms version check can be avoided.
871: FROM wsh_del_legs_interface wdli,
872: wsh_new_del_interface wndi,
873: wsh_trip_stops_interface wtsi_pu,
874: wsh_trip_stops_interface wtsi_do,
875: wsh_trips_interface wti,
876: wsh_new_deliveries wnd
877: WHERE wti.interface_action_code = G_TMS_RELEASE_CODE
878: AND wtsi_pu.trip_interface_id = wti.trip_interface_id

Line 932: FROM wsh_trip_stops

928: attribute12,
929: attribute13,
930: attribute14,
931: attribute15
932: FROM wsh_trip_stops
933: WHERE trip_id = p_trip_id;
934:
935: -- Find Deliveries associated to a stop
936: -- GC3 sends only physical stops back to EBS

Line 957: wsh_trip_stops wts

953: UNION
954: SELECT wdl.delivery_id, wnd.organization_id,wnd.tms_version_number
955: FROM wsh_delivery_legs wdl,
956: wsh_new_deliveries wnd,
957: wsh_trip_stops wts
958: WHERE wdl.drop_off_stop_id = wts.stop_id
959: AND wnd.delivery_id = wdl.delivery_id
960: AND wts.physical_stop_id = p_stop_id;
961:

Line 1010: wsh_trip_stops_interface wtsi ,

1006: wdli.delivery_leg_interface_id,
1007: wtsi.stop_interface_id,
1008: wfci.freight_cost_interface_id
1009: from wsh_trips_interface wti ,
1010: wsh_trip_stops_interface wtsi ,
1011: wsh_del_legs_interface wdli ,
1012: wsh_freight_costs_interface wfci,
1013: wsh_new_del_interface wndi
1014: where wti.trip_interface_id = c_trip_interface_id --Bug7717569

Line 1391: from wsh_trip_stops_interface wtsi,

1387: DELETE from wsh_interface_errors wie
1388: WHERE wie.interface_table_name = 'WSH_NEW_DEL_INTERFACE'
1389: AND wie.interface_id in (
1390: select wdli.delivery_interface_id
1391: from wsh_trip_stops_interface wtsi,
1392: wsh_del_legs_interface wdli
1393: where wtsi.trip_interface_id = l_del_wti_tab(i)
1394: and wtsi.stop_interface_id = wdli.pick_up_stop_interface_id
1395: and wtsi.interface_action_code = G_TMS_RELEASE_CODE

Line 1404: from wsh_trip_stops_interface wtsi,

1400: FORALL i in l_del_wti_tab.FIRST..l_del_wti_tab.LAST
1401: DELETE from WSH_EXCEPTIONS we
1402: WHERE we.delivery_id in (
1403: select wdli.delivery_id
1404: from wsh_trip_stops_interface wtsi,
1405: wsh_del_legs_interface wdli
1406: where wtsi.trip_interface_id = l_del_wti_tab(i)
1407: and wtsi.stop_interface_id = wdli.pick_up_stop_interface_id
1408: and wtsi.interface_action_code = G_TMS_RELEASE_CODE

Line 1504: wsh_trip_stops_pvt.lock_trip_stop_no_compare(

1500: BEGIN--{
1501: FOR rec in c_get_stops(l_trip_info_tab(i).trip_id)
1502: LOOP
1503: l_stop_id := rec.stop_id;
1504: wsh_trip_stops_pvt.lock_trip_stop_no_compare(
1505: p_stop_id => rec.stop_id);
1506: END LOOP;
1507:
1508: EXCEPTION

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

1507:
1508: EXCEPTION
1509: WHEN OTHERS THEN
1510: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_STOP');
1511: FND_MESSAGE.SET_TOKEN('STOP_NAME',WSH_TRIP_STOPS_PVT.get_name(l_stop_id,'FTE_TMS_INTEGRATION'));
1512: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1513: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1514: IF l_debug_on THEN
1515: WSH_DEBUG_SV.log(l_module_name, 'trip stop not locked: l_return_status', l_return_status);

Line 1942: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;

1938: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
1939: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
1940: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
1941:
1942: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
1943: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
1944: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
1945: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
1946: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;

Line 1943: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;

1939: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
1940: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
1941:
1942: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
1943: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
1944: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
1945: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
1946: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
1947: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;

Line 1944: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;

1940: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
1941:
1942: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
1943: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
1944: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
1945: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
1946: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
1947: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
1948: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.stop_wt_vol_tab_type;

Line 1945: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;

1941:
1942: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
1943: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
1944: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
1945: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
1946: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
1947: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
1948: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.stop_wt_vol_tab_type;
1949:

Line 1946: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;

1942: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
1943: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
1944: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
1945: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
1946: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
1947: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
1948: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.stop_wt_vol_tab_type;
1949:
1950: l_del_count NUMBER;

Line 1947: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;

1943: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
1944: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
1945: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
1946: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
1947: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
1948: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.stop_wt_vol_tab_type;
1949:
1950: l_del_count NUMBER;
1951: l_stop_count NUMBER;

Line 1948: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.stop_wt_vol_tab_type;

1944: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
1945: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
1946: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
1947: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
1948: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.stop_wt_vol_tab_type;
1949:
1950: l_del_count NUMBER;
1951: l_stop_count NUMBER;
1952:

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

2275: GOTO trip_error;
2276: END IF;
2277: END IF;--}
2278:
2279: -- ii. Call WSH_TRIP_STOPS_GRP.Stop_Action() to DELETE
2280: l_stop_action_prms.caller := 'FTE_TMS_INTEGRATION';
2281: l_stop_action_prms.action_code := 'DELETE';
2282: l_stop_attrs(1).stop_id := rec.stop_id;
2283: l_stop_attrs(1).trip_id := l_trip_info_tab(i).trip_id;

Line 2285: WSH_TRIP_STOPS_GRP.stop_action(

2281: l_stop_action_prms.action_code := 'DELETE';
2282: l_stop_attrs(1).stop_id := rec.stop_id;
2283: l_stop_attrs(1).trip_id := l_trip_info_tab(i).trip_id;
2284:
2285: WSH_TRIP_STOPS_GRP.stop_action(
2286: p_api_version_number => 1.0,
2287: p_init_msg_list => FND_API.G_TRUE,
2288: p_commit => FND_API.G_FALSE,
2289: p_action_prms => l_stop_action_prms,

Line 2545: wsh_trip_stops_grp.Create_Update_Stop(

2541: WSH_DEBUG_SV.logmsg(l_module_name,'Stop Vol UOM:'||l_stop_local_tab(stop_rec).volume_uom_code);
2542: WSH_DEBUG_SV.logmsg(l_module_name,'Before Calling Create_update_Stop,count:'||l_stop_attrs.count);
2543: END IF;
2544:
2545: wsh_trip_stops_grp.Create_Update_Stop(
2546: p_api_version_number => 1.0,
2547: p_init_msg_list => FND_API.G_FALSE,
2548: p_commit => FND_API.G_FALSE,
2549: p_in_rec => l_stop_in_rec,

Line 2585: wsh_trip_stops_interface wtsi,

2581: SELECT wtsi.dock_name, wnd.organization_id, wtsi.start_time, wtsi.end_time
2582: FROM wsh_del_legs_interface wdli,
2583: wsh_new_del_interface wndi,
2584: wsh_new_deliveries wnd,
2585: wsh_trip_stops_interface wtsi,
2586: wsh_trips_interface wti
2587: WHERE wti.group_id = c_group_id
2588: AND wti.interface_action_code = G_TMS_RELEASE_CODE
2589: AND wtsi.trip_interface_id = wti.trip_interface_id

Line 2699: from wsh_trip_stops

2695: DECLARE
2696: CURSOR c_1 IS
2697: select stop_id,stop_location_id,stop_sequence_number,
2698: physical_stop_id,physical_location_id
2699: from wsh_trip_stops
2700: where stop_id = l_stop_local_tab(stop_rec).stop_id;
2701: BEGIN
2702: FOR st in c_1
2703: LOOP

Line 3572: wsh_trip_stops wts

3568: DECLARE
3569: CURSOR c_stops (c_trip_id IN number) IS
3570: SELECT wts.stop_id stop_id
3571: FROM wsh_trips wt,
3572: wsh_trip_stops wts
3573: WHERE wt.trip_id = c_trip_id
3574: AND wt.trip_id = wts.trip_id
3575: ORDER BY wts.stop_sequence_number DESC;
3576:

Line 4188: -- Purge records in wsh_trip_stops_interface

4184: -- Corrections Form)
4185: -- Purge any records in wsh_interface_errors
4186: -- Purge records in wsh_new_del_interface
4187: -- Purge records in wsh_del_legs_interface
4188: -- Purge records in wsh_trip_stops_interface
4189: -- Purge records in wsh_trips_interface
4190: -- Index exists on group_id and trip_interface_id of wsh_trips_interface,
4191: -- so use trip_interface_id.
4192: --

Line 4270: from wsh_trip_stops_interface wtsi,

4266: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST
4267: Delete from wsh_freight_costs_interface wfci
4268: where wfci.delivery_interface_id in (
4269: select wdli.delivery_interface_id
4270: from wsh_trip_stops_interface wtsi,
4271: wsh_del_legs_interface wdli
4272: where wtsi.trip_interface_id = l_trip_interface_id_tab(i)
4273: and wtsi.stop_interface_id = wdli.pick_up_stop_interface_id
4274: and wtsi.interface_action_code = G_TMS_RELEASE_CODE

Line 4288: from wsh_trip_stops_interface wtsi,

4284: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST
4285: DELETE from WSH_EXCEPTIONS we
4286: WHERE we.delivery_id in (
4287: select wdli.delivery_id
4288: from wsh_trip_stops_interface wtsi,
4289: wsh_del_legs_interface wdli
4290: where wtsi.trip_interface_id = l_trip_interface_id_tab(i)
4291: and wtsi.stop_interface_id = wdli.pick_up_stop_interface_id
4292: and wtsi.interface_action_code = G_TMS_RELEASE_CODE

Line 4307: from wsh_trip_stops_interface wtsi,

4303: UPDATE WSH_EXCEPTIONS we
4304: SET status = 'CLOSED'
4305: WHERE we.delivery_id in (
4306: select wdli.delivery_id
4307: from wsh_trip_stops_interface wtsi,
4308: wsh_del_legs_interface wdli
4309: where wtsi.trip_interface_id = l_trip_interface_id_tab(i)
4310: and wtsi.stop_interface_id = wdli.pick_up_stop_interface_id
4311: and wtsi.interface_action_code = G_TMS_RELEASE_CODE

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

4315: END IF;--}
4316:
4317: -- Purge wsh_interface_errors
4318: -- for each of the above entity, there could be errors logged in wsh_interface_errors
4319: -- table_name can be WSH_NEW_DEL_INTERFACE, WSH_TRIP_STOPS_INTERFACE,
4320: -- WSH_TRIPS_INTERFACE
4321:
4322: IF l_debug_on THEN
4323: WSH_DEBUG_SV.logmsg(l_module_name,'Start Purging Interface Errors Data for delivery');

Line 4331: from wsh_trip_stops_interface wtsi,

4327: Delete from wsh_interface_errors wie
4328: where wie.interface_table_name = 'WSH_NEW_DEL_INTERFACE'
4329: and wie.interface_id in (
4330: select wdli.delivery_interface_id
4331: from wsh_trip_stops_interface wtsi,
4332: wsh_del_legs_interface wdli
4333: where wtsi.trip_interface_id = l_trip_interface_id_tab(i)
4334: and wtsi.stop_interface_id = wdli.pick_up_stop_interface_id
4335: and wtsi.interface_action_code = G_TMS_RELEASE_CODE

Line 4345: where wie.interface_table_name = 'WSH_TRIP_STOPS_INTERFACE'

4341: END IF;
4342: -- Delete errors logged for trip stops
4343: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST
4344: Delete from wsh_interface_errors wie
4345: where wie.interface_table_name = 'WSH_TRIP_STOPS_INTERFACE'
4346: and wie.interface_id in (
4347: select wtsi.stop_interface_id
4348: from wsh_trip_stops_interface wtsi
4349: where wtsi.trip_interface_id = l_trip_interface_id_tab(i)

Line 4348: from wsh_trip_stops_interface wtsi

4344: Delete from wsh_interface_errors wie
4345: where wie.interface_table_name = 'WSH_TRIP_STOPS_INTERFACE'
4346: and wie.interface_id in (
4347: select wtsi.stop_interface_id
4348: from wsh_trip_stops_interface wtsi
4349: where wtsi.trip_interface_id = l_trip_interface_id_tab(i)
4350: and wtsi.interface_action_code = G_TMS_RELEASE_CODE)
4351: and wie.interface_action_code = G_TMS_RELEASE_CODE;
4352:

Line 4371: from wsh_trip_stops_interface wtsi,

4367: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST
4368: Delete from wsh_new_del_interface wndi
4369: where wndi.delivery_interface_id in (
4370: select wdli.delivery_interface_id
4371: from wsh_trip_stops_interface wtsi,
4372: wsh_del_legs_interface wdli
4373: where wtsi.trip_interface_id = l_trip_interface_id_tab(i)
4374: and wtsi.stop_interface_id = wdli.pick_up_stop_interface_id
4375: and wtsi.interface_action_code = G_TMS_RELEASE_CODE

Line 4387: from wsh_trip_stops_interface wtsi

4383: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST
4384: Delete from wsh_del_legs_interface wdli
4385: where wdli.pick_up_stop_interface_id in (
4386: select wtsi.stop_interface_id
4387: from wsh_trip_stops_interface wtsi
4388: where wtsi.trip_interface_id = l_trip_interface_id_tab(i)
4389: and wtsi.interface_action_code = G_TMS_RELEASE_CODE)
4390: and wdli.interface_action_code = G_TMS_RELEASE_CODE;
4391:

Line 4392: -- Purge wsh_trip_stops_interface

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

Line 4397: Delete from wsh_trip_stops_interface wtsi

4393: IF l_debug_on THEN
4394: WSH_DEBUG_SV.logmsg(l_module_name,'Start Purging Trip Stops Interface Data');
4395: END IF;
4396: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST
4397: Delete from wsh_trip_stops_interface wtsi
4398: where wtsi.trip_interface_id = l_trip_interface_id_tab(i)
4399: and wtsi.interface_action_code = G_TMS_RELEASE_CODE;
4400:
4401: -- Purge wsh_trips_interface

Line 4696: wsh_trip_stops wts,

4692: wnd.organization_id,
4693: wnd.name,
4694: wnd.status_code
4695: FROM wsh_delivery_legs wdl,
4696: wsh_trip_stops wts,
4697: wsh_new_deliveries wnd
4698: WHERE wdl.pick_up_stop_id = wts.stop_id
4699: AND wts.trip_id = p_trip_id
4700: AND wdl.delivery_id = wnd.delivery_id(+);

Line 4710: wsh_trip_stops wts,

4706: wnd.organization_id,
4707: wnd.name,
4708: wnd.status_code
4709: FROM wsh_delivery_legs wdl,
4710: wsh_trip_stops wts,
4711: wsh_trips wt,
4712: wsh_new_deliveries wnd
4713: WHERE wdl.pick_up_stop_id = wts.stop_id
4714: AND wts.trip_id = wt.trip_id

Line 4818: wsh_trip_stops wts_pu,

4814: wts_do.stop_location_id dropoff_stop_location_id,
4815: wts_do.stop_sequence_number dropoff_stop_sequence,
4816: wts_pu.trip_id trip_id
4817: FROM wsh_delivery_legs wdl,
4818: wsh_trip_stops wts_pu,
4819: wsh_trip_stops wts_do
4820: WHERE wdl.delivery_id = p_delivery_id
4821: AND wdl.pick_up_stop_id = wts_pu.stop_id
4822: AND wdl.drop_off_stop_id = wts_do.stop_id ;

Line 4819: wsh_trip_stops wts_do

4815: wts_do.stop_sequence_number dropoff_stop_sequence,
4816: wts_pu.trip_id trip_id
4817: FROM wsh_delivery_legs wdl,
4818: wsh_trip_stops wts_pu,
4819: wsh_trip_stops wts_do
4820: WHERE wdl.delivery_id = p_delivery_id
4821: AND wdl.pick_up_stop_id = wts_pu.stop_id
4822: AND wdl.drop_off_stop_id = wts_do.stop_id ;
4823: