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_DEL_LEGS_INTERFACE

Line 350: wsh_del_legs_interface wdli,

346: WHERE wti.interface_action_code IN (G_TMS_RELEASE_CODE,G_TMS_DELETE_CODE)
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)

Line 612: wsh_del_legs_interface wdli,

608: AND wtsi.interface_action_code = G_TMS_RELEASE_CODE
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)

Line 712: FROM wsh_del_legs_interface wdli,

708: wnd.initial_pickup_location_id,-- used while logging exceptions
709: wnd.ultimate_dropoff_location_id,-- used for internal Locations
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,

Line 759: FROM wsh_del_legs_interface wdli,

755: wnd.initial_pickup_location_id,-- used while logging exceptions
756: wnd.ultimate_dropoff_location_id,-- used for internal Locations
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,

Line 807: FROM wsh_del_legs_interface wdli,

803: wnd.initial_pickup_location_id,-- used while logging exceptions
804: wnd.ultimate_dropoff_location_id,-- used for internal Locations
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,

Line 826: wsh_del_legs_interface wdli,

822: AND wndi.delivery_id = wdli.delivery_id
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)

Line 864: FROM wsh_del_legs_interface wdli,

860: wnd.initial_pickup_location_id,-- used while logging exceptions
861: wnd.ultimate_dropoff_location_id,-- used for internal Locations
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,

Line 1004: wsh_del_legs_interface wdli ,

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
1008: and wdli.delivery_interface_id = wndi.delivery_interface_id

Line 1384: wsh_del_legs_interface wdli

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
1388: and wdli.interface_action_code = G_TMS_RELEASE_CODE)

Line 1397: wsh_del_legs_interface wdli

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
1401: and wdli.interface_action_code = G_TMS_RELEASE_CODE)

Line 2574: FROM wsh_del_legs_interface wdli,

2570: -- OTM Dock Door App Sched Proj
2571: DECLARE
2572: CURSOR c_dock_appt_rec(c_stop_interface_id IN NUMBER, c_group_id IN NUMBER) IS
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

Line 4179: -- Purge records in wsh_del_legs_interface

4175: -- for WSH_OTM_SHIPMENT_ERROR(used for reprocessing from Interface Mesg
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.

Line 4263: wsh_del_legs_interface wdli

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
4267: and wdli.interface_action_code = G_TMS_RELEASE_CODE)

Line 4281: wsh_del_legs_interface wdli

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
4285: and wdli.interface_action_code = G_TMS_RELEASE_CODE)

Line 4300: wsh_del_legs_interface wdli

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
4304: and wdli.interface_action_code = G_TMS_RELEASE_CODE)

Line 4324: wsh_del_legs_interface wdli

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
4328: and wdli.interface_action_code = G_TMS_RELEASE_CODE)

Line 4364: wsh_del_legs_interface wdli

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
4368: and wdli.interface_action_code = G_TMS_RELEASE_CODE)

Line 4371: -- Purge wsh_del_legs_interface

4367: and wtsi.interface_action_code = G_TMS_RELEASE_CODE
4368: and wdli.interface_action_code = G_TMS_RELEASE_CODE)
4369: and wndi.interface_action_code = G_TMS_RELEASE_CODE;
4370:
4371: -- Purge wsh_del_legs_interface
4372: IF l_debug_on THEN
4373: WSH_DEBUG_SV.logmsg(l_module_name,'Start Purging Delivery Legs Interface Data');
4374: END IF;
4375: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST

Line 4376: Delete from wsh_del_legs_interface wdli

4372: IF l_debug_on THEN
4373: WSH_DEBUG_SV.logmsg(l_module_name,'Start Purging Delivery Legs Interface Data');
4374: END IF;
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)