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

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 224: wsh_trips wt

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
228: ORDER BY wti.trip_interface_id;

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 284: wsh_trips wt

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)
288: AND wt.tp_plan_name(+) = wti.tp_plan_name

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 345: wsh_trips wt

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
349: (SELECT wti.group_id FROM wsh_new_del_interface wndi,

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 420: wsh_trips wt

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;
424:

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 1469: WSH_TRIPS_PVT.lock_trip_no_compare

1465: END IF;
1466:
1467: BEGIN
1468: -- Lock Trip
1469: WSH_TRIPS_PVT.lock_trip_no_compare
1470: (p_trip_id => l_trip_info_tab(i).trip_id);
1471: EXCEPTION
1472: WHEN OTHERS THEN
1473: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_TRIP');

Line 1474: FND_MESSAGE.SET_TOKEN('TRIP_NAME',WSH_TRIPS_PVT.get_name(l_trip_info_tab(i).trip_id));

1470: (p_trip_id => l_trip_info_tab(i).trip_id);
1471: EXCEPTION
1472: WHEN OTHERS THEN
1473: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_TRIP');
1474: FND_MESSAGE.SET_TOKEN('TRIP_NAME',WSH_TRIPS_PVT.get_name(l_trip_info_tab(i).trip_id));
1475: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1476: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1477: IF l_debug_on THEN
1478: WSH_DEBUG_SV.log(l_module_name, 'trip not locked: l_return_status', l_return_status);

Line 1576: l_trip_input_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

1572: l_rs VARCHAR2(1);
1573: l_msg_count NUMBER;
1574: l_msg_data VARCHAR2(32767);
1575:
1576: l_trip_input_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1577: l_in_rec WSH_TRIPS_GRP.tripInRecType;
1578: l_trip_output_tab WSH_TRIPS_GRP.trip_Out_Tab_Type;
1579:
1580: l_stop_location_id NUMBER;

Line 1577: l_in_rec WSH_TRIPS_GRP.tripInRecType;

1573: l_msg_count NUMBER;
1574: l_msg_data VARCHAR2(32767);
1575:
1576: l_trip_input_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1577: l_in_rec WSH_TRIPS_GRP.tripInRecType;
1578: l_trip_output_tab WSH_TRIPS_GRP.trip_Out_Tab_Type;
1579:
1580: l_stop_location_id NUMBER;
1581: l_organization_tab WSH_UTIL_CORE.id_tab_type;

Line 1578: l_trip_output_tab WSH_TRIPS_GRP.trip_Out_Tab_Type;

1574: l_msg_data VARCHAR2(32767);
1575:
1576: l_trip_input_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1577: l_in_rec WSH_TRIPS_GRP.tripInRecType;
1578: l_trip_output_tab WSH_TRIPS_GRP.trip_Out_Tab_Type;
1579:
1580: l_stop_location_id NUMBER;
1581: l_organization_tab WSH_UTIL_CORE.id_tab_type;
1582:

Line 1867: l_trip_input_tab(1).NAME := WSH_TRIPS_PVT.get_name(l_trip_info_tab(i).trip_id);

1863:
1864: IF l_trip_info_tab(i).trip_id IS NOT NULL THEN--{
1865: --trip already exists in EBS
1866: l_in_rec.action_code := 'UPDATE';
1867: l_trip_input_tab(1).NAME := WSH_TRIPS_PVT.get_name(l_trip_info_tab(i).trip_id);
1868: ELSE -- trip doesnot exist in EBS
1869: l_in_rec.action_code := 'CREATE';
1870: l_trip_input_tab(1).NAME := l_trip_info_tab(i).name;
1871: END IF; --}

Line 1876: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_TRIPS_GRP.Create_Update_Trip:'||l_in_rec.action_code);

1872:
1873: l_in_rec.caller := 'FTE_TMS_INTEGRATION';
1874:
1875: IF l_debug_on THEN
1876: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_TRIPS_GRP.Create_Update_Trip:'||l_in_rec.action_code);
1877: END IF;
1878:
1879: WSH_TRIPS_GRP.Create_Update_Trip(
1880: p_api_version_number => 1.0,

Line 1879: WSH_TRIPS_GRP.Create_Update_Trip(

1875: IF l_debug_on THEN
1876: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_TRIPS_GRP.Create_Update_Trip:'||l_in_rec.action_code);
1877: END IF;
1878:
1879: WSH_TRIPS_GRP.Create_Update_Trip(
1880: p_api_version_number => 1.0,
1881: p_init_msg_list => FND_API.G_TRUE,
1882: p_commit => FND_API.G_FALSE,
1883: x_return_status => l_rs,

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 3563: FROM wsh_trips wt,

3559: -- 4h. Stamping the Loading Sequence Number for OTM enabled WMS organization
3560: DECLARE
3561: CURSOR c_stops (c_trip_id IN number) IS
3562: SELECT wts.stop_id stop_id
3563: FROM wsh_trips wt,
3564: wsh_trip_stops wts
3565: WHERE wt.trip_id = c_trip_id
3566: AND wt.trip_id = wts.trip_id
3567: ORDER BY wts.stop_sequence_number DESC;

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

Line 4703: wsh_trips wt,

4699: wnd.name,
4700: wnd.status_code
4701: FROM wsh_delivery_legs wdl,
4702: wsh_trip_stops wts,
4703: wsh_trips wt,
4704: wsh_new_deliveries wnd
4705: WHERE wdl.pick_up_stop_id = wts.stop_id
4706: AND wts.trip_id = wt.trip_id
4707: AND wt.tp_plan_name = p_tp_plan_name