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_INTERFACE

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 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 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 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