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 225: FROM wsh_trips_interface wti,

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

Line 226: wsh_trips wt

222: wt.attribute13,
223: wt.attribute14,
224: wt.attribute15
225: FROM wsh_trips_interface wti,
226: wsh_trips wt
227: WHERE wti.group_id = p_group_id --p_group_id is the input parameter
228: AND wti.interface_action_code IN (G_TMS_RELEASE_CODE,G_TMS_DELETE_CODE)
229: AND wt.tp_plan_name(+) = wti.tp_plan_name
230: ORDER BY wti.trip_interface_id;

Line 285: FROM wsh_trips_interface wti,

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

Line 286: wsh_trips wt

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

Line 346: FROM wsh_trips_interface wti,

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

Line 347: wsh_trips wt

343: wt.attribute13,
344: wt.attribute14,
345: wt.attribute15
346: FROM wsh_trips_interface wti,
347: wsh_trips wt
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,

Line 354: wsh_trips_interface wti,

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

Line 423: FROM wsh_trips_interface wti,

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

Line 424: wsh_trips wt

420: wt.attribute13,
421: wt.attribute14,
422: wt.attribute15
423: FROM wsh_trips_interface wti,
424: wsh_trips wt
425: WHERE wti.interface_action_code IN (G_TMS_RELEASE_CODE,G_TMS_DELETE_CODE)
426: AND wt.tp_plan_name(+) = wti.tp_plan_name
427: ORDER BY wti.trip_interface_id;
428:

Line 485: wsh_trips_interface wti

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

Line 547: wsh_trips_interface wti

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

Line 610: wsh_trips_interface wti

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

Line 618: wsh_trips_interface wti,

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

Line 688: wsh_trips_interface wti

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

Line 721: wsh_trips_interface wti,

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

Line 768: wsh_trips_interface wti,

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

Line 816: wsh_trips_interface wti,

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

Line 833: wsh_trips_interface wti,

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

Line 875: wsh_trips_interface wti,

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

Line 986: FROM wsh_trips_interface wti,

982: AND interface_action_code = G_TMS_RELEASE_CODE;
983:
984: CURSOR c_get_currency_code(p_trip_interface_id IN NUMBER) IS
985: SELECT wc.currency_code, wti.carrier_id
986: FROM wsh_trips_interface wti,
987: wsh_carriers wc
988: WHERE wti.trip_interface_id = p_trip_interface_id
989: AND wti.carrier_id = wc.carrier_id;
990:

Line 1009: from wsh_trips_interface wti ,

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

Line 1477: WSH_TRIPS_PVT.lock_trip_no_compare

1473: END IF;
1474:
1475: BEGIN
1476: -- Lock Trip
1477: WSH_TRIPS_PVT.lock_trip_no_compare
1478: (p_trip_id => l_trip_info_tab(i).trip_id);
1479: EXCEPTION
1480: WHEN OTHERS THEN
1481: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_TRIP');

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

1478: (p_trip_id => l_trip_info_tab(i).trip_id);
1479: EXCEPTION
1480: WHEN OTHERS THEN
1481: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_TRIP');
1482: FND_MESSAGE.SET_TOKEN('TRIP_NAME',WSH_TRIPS_PVT.get_name(l_trip_info_tab(i).trip_id));
1483: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1484: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1485: IF l_debug_on THEN
1486: WSH_DEBUG_SV.log(l_module_name, 'trip not locked: l_return_status', l_return_status);

Line 1584: l_trip_input_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

1580: l_rs VARCHAR2(1);
1581: l_msg_count NUMBER;
1582: l_msg_data VARCHAR2(32767);
1583:
1584: l_trip_input_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1585: l_in_rec WSH_TRIPS_GRP.tripInRecType;
1586: l_trip_output_tab WSH_TRIPS_GRP.trip_Out_Tab_Type;
1587:
1588: l_stop_location_id NUMBER;

Line 1585: l_in_rec WSH_TRIPS_GRP.tripInRecType;

1581: l_msg_count NUMBER;
1582: l_msg_data VARCHAR2(32767);
1583:
1584: l_trip_input_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1585: l_in_rec WSH_TRIPS_GRP.tripInRecType;
1586: l_trip_output_tab WSH_TRIPS_GRP.trip_Out_Tab_Type;
1587:
1588: l_stop_location_id NUMBER;
1589: l_organization_tab WSH_UTIL_CORE.id_tab_type;

Line 1586: l_trip_output_tab WSH_TRIPS_GRP.trip_Out_Tab_Type;

1582: l_msg_data VARCHAR2(32767);
1583:
1584: l_trip_input_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1585: l_in_rec WSH_TRIPS_GRP.tripInRecType;
1586: l_trip_output_tab WSH_TRIPS_GRP.trip_Out_Tab_Type;
1587:
1588: l_stop_location_id NUMBER;
1589: l_organization_tab WSH_UTIL_CORE.id_tab_type;
1590:

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

1871:
1872: IF l_trip_info_tab(i).trip_id IS NOT NULL THEN--{
1873: --trip already exists in EBS
1874: l_in_rec.action_code := 'UPDATE';
1875: l_trip_input_tab(1).NAME := WSH_TRIPS_PVT.get_name(l_trip_info_tab(i).trip_id);
1876: ELSE -- trip doesnot exist in EBS
1877: l_in_rec.action_code := 'CREATE';
1878: l_trip_input_tab(1).NAME := l_trip_info_tab(i).name;
1879: END IF; --}

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

1880:
1881: l_in_rec.caller := 'FTE_TMS_INTEGRATION';
1882:
1883: IF l_debug_on THEN
1884: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_TRIPS_GRP.Create_Update_Trip:'||l_in_rec.action_code);
1885: END IF;
1886:
1887: WSH_TRIPS_GRP.Create_Update_Trip(
1888: p_api_version_number => 1.0,

Line 1887: WSH_TRIPS_GRP.Create_Update_Trip(

1883: IF l_debug_on THEN
1884: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_TRIPS_GRP.Create_Update_Trip:'||l_in_rec.action_code);
1885: END IF;
1886:
1887: WSH_TRIPS_GRP.Create_Update_Trip(
1888: p_api_version_number => 1.0,
1889: p_init_msg_list => FND_API.G_TRUE,
1890: p_commit => FND_API.G_FALSE,
1891: x_return_status => l_rs,

Line 2586: wsh_trips_interface wti

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

Line 3571: FROM wsh_trips wt,

3567: -- 4h. Stamping the Loading Sequence Number for OTM enabled WMS organization
3568: DECLARE
3569: CURSOR c_stops (c_trip_id IN number) IS
3570: SELECT wts.stop_id stop_id
3571: FROM wsh_trips wt,
3572: wsh_trip_stops wts
3573: WHERE wt.trip_id = c_trip_id
3574: AND wt.trip_id = wts.trip_id
3575: ORDER BY wts.stop_sequence_number DESC;

Line 4189: -- Purge records in wsh_trips_interface

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

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

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

Line 4210: FROM wsh_trips_interface wti

4206: x_return_status OUT NOCOPY VARCHAR2) IS
4207:
4208: CURSOR c_get_interface_id (p_tp_plan_name IN VARCHAR2) IS
4209: SELECT wti.trip_interface_id
4210: FROM wsh_trips_interface wti
4211: WHERE wti.tp_plan_name = p_tp_plan_name
4212: AND wti.interface_action_code = G_TMS_RELEASE_CODE;
4213:
4214: l_trip_interface_id NUMBER;

Line 4320: -- WSH_TRIPS_INTERFACE

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

Line 4359: where wie.interface_table_name = 'WSH_TRIPS_INTERFACE'

4355: WSH_DEBUG_SV.logmsg(l_module_name,'Start Purging Interface Errors Data for Trips');
4356: END IF;
4357: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST
4358: Delete from wsh_interface_errors wie
4359: where wie.interface_table_name = 'WSH_TRIPS_INTERFACE'
4360: and wie.interface_id = l_trip_interface_id_tab(i)
4361: and wie.interface_action_code = G_TMS_RELEASE_CODE;
4362:
4363: -- Purge wsh_new_del_interface

Line 4401: -- Purge wsh_trips_interface

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

Line 4408: Delete from wsh_trips_interface wti

4404: IF l_debug_on THEN
4405: WSH_DEBUG_SV.logmsg(l_module_name,'Start Purging Trips Interface Data');
4406: END IF;
4407: FORALL i in l_trip_interface_id_tab.FIRST..l_trip_interface_id_tab.LAST
4408: Delete from wsh_trips_interface wti
4409: where wti.trip_interface_id = l_trip_interface_id_tab(i)
4410: and wti.INTERFACE_ACTION_CODE = G_TMS_RELEASE_CODE;
4411:
4412: END IF;--}

Line 4711: wsh_trips wt,

4707: wnd.name,
4708: wnd.status_code
4709: FROM wsh_delivery_legs wdl,
4710: wsh_trip_stops wts,
4711: wsh_trips wt,
4712: wsh_new_deliveries wnd
4713: WHERE wdl.pick_up_stop_id = wts.stop_id
4714: AND wts.trip_id = wt.trip_id
4715: AND wt.tp_plan_name = p_tp_plan_name