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_TRIPS_INTERFACE

Line 61: -- WSH_TRIPS_INTERFACE records and

57: -- tables by the BPEL Inbound process.
58: -- parameters
59: -- IN:
60: -- p_group_id list of group_ids to process their
61: -- WSH_TRIPS_INTERFACE records and
62: -- their associated table records.
63: --
64: -- p_latest_version if 'Y'/null then process only if inbound delivery
65: -- tms_version_number matches on the EBS delivery.

Line 223: FROM wsh_trips_interface wti,

219: wt.attribute12,
220: wt.attribute13,
221: wt.attribute14,
222: wt.attribute15
223: FROM wsh_trips_interface wti,
224: wsh_trips wt
225: WHERE wti.group_id = p_group_id --p_group_id is the input parameter
226: AND wti.interface_action_code IN (G_TMS_RELEASE_CODE,G_TMS_DELETE_CODE)
227: AND wt.tp_plan_name(+) = wti.tp_plan_name

Line 283: FROM wsh_trips_interface wti,

279: wt.attribute12,
280: wt.attribute13,
281: wt.attribute14,
282: wt.attribute15
283: FROM wsh_trips_interface wti,
284: wsh_trips wt
285: WHERE wti.tp_plan_name >= nvl(p_tp_plan_low,wti.tp_plan_name)
286: AND wti.tp_plan_name <= nvl(p_tp_plan_high,wti.tp_plan_name)
287: AND wti.interface_action_code IN (G_TMS_RELEASE_CODE,G_TMS_DELETE_CODE)

Line 344: FROM wsh_trips_interface wti,

340: wt.attribute12,
341: wt.attribute13,
342: wt.attribute14,
343: wt.attribute15
344: FROM wsh_trips_interface wti,
345: wsh_trips wt
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

Line 352: wsh_trips_interface wti,

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
356: AND wdli.pick_up_stop_interface_id = wtsi.stop_interface_id

Line 419: FROM wsh_trips_interface wti,

415: wt.attribute12,
416: wt.attribute13,
417: wt.attribute14,
418: wt.attribute15
419: FROM wsh_trips_interface wti,
420: wsh_trips wt
421: WHERE wti.interface_action_code IN (G_TMS_RELEASE_CODE,G_TMS_DELETE_CODE)
422: AND wt.tp_plan_name(+) = wti.tp_plan_name
423: ORDER BY wti.trip_interface_id;

Line 481: wsh_trips_interface wti

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
485: AND wti.interface_action_code = G_TMS_RELEASE_CODE

Line 543: wsh_trips_interface wti

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

Line 606: wsh_trips_interface wti

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
610: AND wti.group_id in

Line 614: wsh_trips_interface wti,

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
618: AND wdli.pick_up_stop_interface_id = wtsi.stop_interface_id

Line 683: wsh_trips_interface wti

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
687: ORDER BY wtsi.trip_interface_id,wtsi.stop_sequence_number ;

Line 716: wsh_trips_interface wti,

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
720: AND wtsi_pu.trip_interface_id = wti.trip_interface_id

Line 763: wsh_trips_interface wti,

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)
767: AND wti.interface_action_code = G_TMS_RELEASE_CODE

Line 811: wsh_trips_interface wti,

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
815: AND wtsi_pu.stop_interface_id = wdli.pick_up_stop_interface_id

Line 828: wsh_trips_interface wti,

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
832: AND wdli.pick_up_stop_interface_id = wtsi.stop_interface_id

Line 868: wsh_trips_interface wti,

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
872: AND wtsi_pu.stop_interface_id = wdli.pick_up_stop_interface_id

Line 979: FROM wsh_trips_interface wti,

975: AND interface_action_code = G_TMS_RELEASE_CODE;
976:
977: CURSOR c_get_currency_code(p_trip_interface_id IN NUMBER) IS
978: SELECT wc.currency_code, wti.carrier_id
979: FROM wsh_trips_interface wti,
980: wsh_carriers wc
981: WHERE wti.trip_interface_id = p_trip_interface_id
982: AND wti.carrier_id = wc.carrier_id;
983:

Line 1002: from wsh_trips_interface wti ,

998: wndi.delivery_interface_id,
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

Line 2578: wsh_trips_interface wti

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
2582: AND wtsi.stop_interface_id = wdli.pick_up_stop_interface_id

Line 4181: -- Purge records in wsh_trips_interface

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: --
4185: -- Usage:

Line 4182: -- Index exists on group_id and trip_interface_id of wsh_trips_interface,

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: --
4185: -- Usage:
4186: -- 1. Inbound BPEL Process calls this API to purge data based on tp_plan_name

Line 4202: FROM wsh_trips_interface wti

4198: x_return_status OUT NOCOPY VARCHAR2) IS
4199:
4200: CURSOR c_get_interface_id (p_tp_plan_name IN VARCHAR2) IS
4201: SELECT wti.trip_interface_id
4202: FROM wsh_trips_interface wti
4203: WHERE wti.tp_plan_name = p_tp_plan_name
4204: AND wti.interface_action_code = G_TMS_RELEASE_CODE;
4205:
4206: l_trip_interface_id NUMBER;

Line 4312: -- WSH_TRIPS_INTERFACE

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');
4316: END IF;

Line 4351: where wie.interface_table_name = 'WSH_TRIPS_INTERFACE'

4347: WSH_DEBUG_SV.logmsg(l_module_name,'Start Purging Interface Errors Data for Trips');
4348: END IF;
4349: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST
4350: Delete from wsh_interface_errors wie
4351: where wie.interface_table_name = 'WSH_TRIPS_INTERFACE'
4352: and wie.interface_id = l_trip_interface_id_tab(i)
4353: and wie.interface_action_code = G_TMS_RELEASE_CODE;
4354:
4355: -- Purge wsh_new_del_interface

Line 4393: -- Purge wsh_trips_interface

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
4394: -- (Trips have to be the last entity interface table purged
4395: -- because this is the only entity interface table having TP_PLAN_NAME.)
4396: IF l_debug_on THEN
4397: WSH_DEBUG_SV.logmsg(l_module_name,'Start Purging Trips Interface Data');

Line 4400: Delete from wsh_trips_interface wti

4396: IF l_debug_on THEN
4397: WSH_DEBUG_SV.logmsg(l_module_name,'Start Purging Trips Interface Data');
4398: END IF;
4399: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST
4400: Delete from wsh_trips_interface wti
4401: where wti.trip_interface_id = l_trip_interface_id_tab(i)
4402: and wti.INTERFACE_ACTION_CODE = G_TMS_RELEASE_CODE;
4403:
4404: END IF;--}