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 352: wsh_del_legs_interface wdli,

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

Line 616: wsh_del_legs_interface wdli,

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

Line 717: FROM wsh_del_legs_interface wdli,

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

Line 764: FROM wsh_del_legs_interface wdli,

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

Line 812: FROM wsh_del_legs_interface wdli,

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

Line 831: wsh_del_legs_interface wdli,

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

Line 871: FROM wsh_del_legs_interface wdli,

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

Line 1011: wsh_del_legs_interface wdli ,

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

Line 1392: wsh_del_legs_interface wdli

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

Line 1405: wsh_del_legs_interface wdli

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

Line 2582: FROM wsh_del_legs_interface wdli,

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

Line 4187: -- Purge records in wsh_del_legs_interface

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

Line 4271: wsh_del_legs_interface wdli

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

Line 4289: wsh_del_legs_interface wdli

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

Line 4308: wsh_del_legs_interface wdli

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

Line 4332: wsh_del_legs_interface wdli

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

Line 4372: wsh_del_legs_interface wdli

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

Line 4379: -- Purge wsh_del_legs_interface

4375: and wtsi.interface_action_code = G_TMS_RELEASE_CODE
4376: and wdli.interface_action_code = G_TMS_RELEASE_CODE)
4377: and wndi.interface_action_code = G_TMS_RELEASE_CODE;
4378:
4379: -- Purge wsh_del_legs_interface
4380: IF l_debug_on THEN
4381: WSH_DEBUG_SV.logmsg(l_module_name,'Start Purging Delivery Legs Interface Data');
4382: END IF;
4383: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST

Line 4384: Delete from wsh_del_legs_interface wdli

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