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.FTE_TRACKING_WRAPPER dependencies on WSH_TRIP_STOPS

Line 1003: FROM wsh_trips, wsh_trip_stops, wsh_delivery_legs , wsh_new_deliveries

999: SELECT /*+ first_rows ordered */
1000: wsh_delivery_legs.delivery_id, wsh_trips.carrier_id, wsh_new_deliveries.waybill,
1001: wsh_delivery_legs.delivery_leg_id
1002: INTO l_delivery_id, l_carrier_id, l_waybill, l_delivery_leg_id
1003: FROM wsh_trips, wsh_trip_stops, wsh_delivery_legs , wsh_new_deliveries
1004: WHERE wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1005: AND wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1006: AND wsh_trip_stops.trip_id = wsh_trips.trip_id
1007: AND wsh_trips.carrier_id = l_carrier_id

Line 1005: AND wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id

1001: wsh_delivery_legs.delivery_leg_id
1002: INTO l_delivery_id, l_carrier_id, l_waybill, l_delivery_leg_id
1003: FROM wsh_trips, wsh_trip_stops, wsh_delivery_legs , wsh_new_deliveries
1004: WHERE wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1005: AND wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1006: AND wsh_trip_stops.trip_id = wsh_trips.trip_id
1007: AND wsh_trips.carrier_id = l_carrier_id
1008: AND wsh_new_deliveries.waybill = l_tracking_id
1009: AND wsh_delivery_legs.parent_delivery_leg_id is null;--Rel 12 MDC Changes

Line 1006: AND wsh_trip_stops.trip_id = wsh_trips.trip_id

1002: INTO l_delivery_id, l_carrier_id, l_waybill, l_delivery_leg_id
1003: FROM wsh_trips, wsh_trip_stops, wsh_delivery_legs , wsh_new_deliveries
1004: WHERE wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1005: AND wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1006: AND wsh_trip_stops.trip_id = wsh_trips.trip_id
1007: AND wsh_trips.carrier_id = l_carrier_id
1008: AND wsh_new_deliveries.waybill = l_tracking_id
1009: AND wsh_delivery_legs.parent_delivery_leg_id is null;--Rel 12 MDC Changes
1010:

Line 1096: FROM wsh_trips, wsh_trip_stops, wsh_delivery_legs , wsh_new_deliveries

1092: SELECT /*+ first_rows ordered */
1093: wsh_delivery_legs.delivery_id, wsh_trips.carrier_id,
1094: wsh_delivery_legs.booking_number, wsh_delivery_legs.delivery_leg_id
1095: INTO l_delivery_id, l_carrier_id, l_booking_number, l_delivery_leg_id
1096: FROM wsh_trips, wsh_trip_stops, wsh_delivery_legs , wsh_new_deliveries
1097: WHERE wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1098: AND wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1099: AND wsh_trip_stops.trip_id = wsh_trips.trip_id
1100: AND wsh_trips.carrier_id = l_carrier_id

Line 1098: AND wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id

1094: wsh_delivery_legs.booking_number, wsh_delivery_legs.delivery_leg_id
1095: INTO l_delivery_id, l_carrier_id, l_booking_number, l_delivery_leg_id
1096: FROM wsh_trips, wsh_trip_stops, wsh_delivery_legs , wsh_new_deliveries
1097: WHERE wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1098: AND wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1099: AND wsh_trip_stops.trip_id = wsh_trips.trip_id
1100: AND wsh_trips.carrier_id = l_carrier_id
1101: AND wsh_delivery_legs.booking_number = l_tracking_id
1102: AND wsh_delivery_legs.parent_delivery_leg_id is null;--Rel 12 MDC Changes

Line 1099: AND wsh_trip_stops.trip_id = wsh_trips.trip_id

1095: INTO l_delivery_id, l_carrier_id, l_booking_number, l_delivery_leg_id
1096: FROM wsh_trips, wsh_trip_stops, wsh_delivery_legs , wsh_new_deliveries
1097: WHERE wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1098: AND wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1099: AND wsh_trip_stops.trip_id = wsh_trips.trip_id
1100: AND wsh_trips.carrier_id = l_carrier_id
1101: AND wsh_delivery_legs.booking_number = l_tracking_id
1102: AND wsh_delivery_legs.parent_delivery_leg_id is null;--Rel 12 MDC Changes
1103:

Line 1185: from wsh_new_deliveries, wsh_bols_rd_v, wsh_delivery_legs, wsh_trips, wsh_trip_stops

1181: then
1182: select wsh_new_deliveries.delivery_id, wsh_delivery_legs.delivery_leg_id,
1183: wsh_trips.carrier_id
1184: into l_delivery_id, l_delivery_leg_id, l_carrier_id
1185: from wsh_new_deliveries, wsh_bols_rd_v, wsh_delivery_legs, wsh_trips, wsh_trip_stops
1186: where wsh_bols_rd_v.delivery_leg_id = wsh_delivery_legs.delivery_leg_id
1187: and wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1188: and wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1189: and wsh_trip_stops.trip_Id = wsh_trips.trip_id

Line 1188: and wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id

1184: into l_delivery_id, l_delivery_leg_id, l_carrier_id
1185: from wsh_new_deliveries, wsh_bols_rd_v, wsh_delivery_legs, wsh_trips, wsh_trip_stops
1186: where wsh_bols_rd_v.delivery_leg_id = wsh_delivery_legs.delivery_leg_id
1187: and wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1188: and wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1189: and wsh_trip_stops.trip_Id = wsh_trips.trip_id
1190: and wsh_trips.carrier_id = l_carrier_id
1191: and wsh_bols_rd_v.bill_of_lading_number = l_tracking_id
1192: and wsh_delivery_legs.parent_delivery_leg_id is null;--Rel 12 MDC Changes

Line 1189: and wsh_trip_stops.trip_Id = wsh_trips.trip_id

1185: from wsh_new_deliveries, wsh_bols_rd_v, wsh_delivery_legs, wsh_trips, wsh_trip_stops
1186: where wsh_bols_rd_v.delivery_leg_id = wsh_delivery_legs.delivery_leg_id
1187: and wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1188: and wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1189: and wsh_trip_stops.trip_Id = wsh_trips.trip_id
1190: and wsh_trips.carrier_id = l_carrier_id
1191: and wsh_bols_rd_v.bill_of_lading_number = l_tracking_id
1192: and wsh_delivery_legs.parent_delivery_leg_id is null;--Rel 12 MDC Changes
1193:

Line 1280: from wsh_new_deliveries, wsh_delivery_legs, wsh_trips, wsh_trip_stops,

1276: wsh_trips.carrier_id, wsh_delivery_details.container_name,
1277: wsh_delivery_details.delivery_detail_id
1278: into l_delivery_id, l_delivery_leg_id, l_carrier_id, l_container_name,
1279: l_delivery_detail_id
1280: from wsh_new_deliveries, wsh_delivery_legs, wsh_trips, wsh_trip_stops,
1281: wsh_delivery_details, wsh_delivery_assignments
1282: where wsh_delivery_assignments.DELIVERY_ID = wsh_new_deliveries.DELIVERY_ID
1283: and wsh_delivery_assignments.DELIVERY_DETAIL_ID =
1284: wsh_delivery_details.DELIVERY_DETAIL_ID

Line 1286: and wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id

1282: where wsh_delivery_assignments.DELIVERY_ID = wsh_new_deliveries.DELIVERY_ID
1283: and wsh_delivery_assignments.DELIVERY_DETAIL_ID =
1284: wsh_delivery_details.DELIVERY_DETAIL_ID
1285: and wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1286: and wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1287: and wsh_trip_stops.trip_Id = wsh_trips.trip_id
1288: and wsh_trips.carrier_id = l_carrier_id
1289: and wsh_delivery_details.container_name = l_tracking_id
1290: and wsh_delivery_legs.parent_delivery_leg_id is null;--Rel 12 MDC Changes

Line 1287: and wsh_trip_stops.trip_Id = wsh_trips.trip_id

1283: and wsh_delivery_assignments.DELIVERY_DETAIL_ID =
1284: wsh_delivery_details.DELIVERY_DETAIL_ID
1285: and wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1286: and wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1287: and wsh_trip_stops.trip_Id = wsh_trips.trip_id
1288: and wsh_trips.carrier_id = l_carrier_id
1289: and wsh_delivery_details.container_name = l_tracking_id
1290: and wsh_delivery_legs.parent_delivery_leg_id is null;--Rel 12 MDC Changes
1291:

Line 1348: wsh_trip_stops wts,

1344: into l_delivery_id, l_delivery_leg_id, l_carrier_id, l_seal_code,
1345: l_delivery_detail_id
1346: from
1347: wsh_trips wt,
1348: wsh_trip_stops wts,
1349: wsh_delivery_legs wdl,
1350: wsh_new_deliveries wnd,
1351: wsh_delivery_assignments wda,
1352: wsh_delivery_details wdd

Line 1431: wsh_trip_stops, wsh_delivery_details, wsh_delivery_assignments

1427: wsh_delivery_details.delivery_detail_id
1428: into l_delivery_id, l_delivery_leg_id, l_carrier_id, l_tracking_number,
1429: l_delivery_detail_id
1430: from wsh_new_deliveries, wsh_delivery_legs, wsh_trips,
1431: wsh_trip_stops, wsh_delivery_details, wsh_delivery_assignments
1432: where wsh_delivery_assignments.DELIVERY_ID = wsh_new_deliveries.DELIVERY_ID
1433: and wsh_delivery_assignments.DELIVERY_DETAIL_ID =
1434: wsh_delivery_details.DELIVERY_DETAIL_ID
1435: and wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id

Line 1436: and wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id

1432: where wsh_delivery_assignments.DELIVERY_ID = wsh_new_deliveries.DELIVERY_ID
1433: and wsh_delivery_assignments.DELIVERY_DETAIL_ID =
1434: wsh_delivery_details.DELIVERY_DETAIL_ID
1435: and wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1436: and wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1437: and wsh_trip_stops.trip_Id = wsh_trips.trip_id
1438: and wsh_trips.carrier_id = l_carrier_id
1439: and wsh_delivery_details.tracking_number = l_tracking_id
1440: and wsh_delivery_legs.parent_delivery_leg_id is null;--Rel 12 MDC Changes

Line 1437: and wsh_trip_stops.trip_Id = wsh_trips.trip_id

1433: and wsh_delivery_assignments.DELIVERY_DETAIL_ID =
1434: wsh_delivery_details.DELIVERY_DETAIL_ID
1435: and wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id
1436: and wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id
1437: and wsh_trip_stops.trip_Id = wsh_trips.trip_id
1438: and wsh_trips.carrier_id = l_carrier_id
1439: and wsh_delivery_details.tracking_number = l_tracking_id
1440: and wsh_delivery_legs.parent_delivery_leg_id is null;--Rel 12 MDC Changes
1441:

Line 1527: update wsh_trip_stops

1523: end if;
1524:
1525:
1526:
1527: update wsh_trip_stops
1528: set actual_departure_date = l_departure_date,
1529: carrier_est_departure_date = l_estimated_departure_date,
1530: loading_start_datetime = l_begin_loading_date,
1531: loading_end_datetime = l_end_loading_date

Line 1532: where wsh_trip_stops.stop_id =

1528: set actual_departure_date = l_departure_date,
1529: carrier_est_departure_date = l_estimated_departure_date,
1530: loading_start_datetime = l_begin_loading_date,
1531: loading_end_datetime = l_end_loading_date
1532: where wsh_trip_stops.stop_id =
1533: (select pick_up_stop_id
1534: from wsh_delivery_legs
1535: where delivery_leg_id = l_delivery_leg_id);
1536:

Line 1537: update wsh_trip_stops

1533: (select pick_up_stop_id
1534: from wsh_delivery_legs
1535: where delivery_leg_id = l_delivery_leg_id);
1536:
1537: update wsh_trip_stops
1538: set actual_arrival_date = l_arrival_date,
1539: carrier_est_arrival_date = l_estimated_arrival_date,
1540: unloading_start_datetime = l_begin_unloading_date,
1541: unloading_end_datetime = l_end_unloading_date

Line 1542: where wsh_trip_stops.stop_id =

1538: set actual_arrival_date = l_arrival_date,
1539: carrier_est_arrival_date = l_estimated_arrival_date,
1540: unloading_start_datetime = l_begin_unloading_date,
1541: unloading_end_datetime = l_end_unloading_date
1542: where wsh_trip_stops.stop_id =
1543: (select drop_off_stop_id
1544: from wsh_delivery_legs
1545: where delivery_leg_id = l_delivery_leg_id);
1546:

Line 1992: x_stop_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;

1988: l_stop_id_tab FTE_ID_TAB_TYPE;
1989: l_stop_action_params FTE_STOP_ACTION_PARAM_REC;
1990:
1991:
1992: x_stop_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;
1993:
1994: p_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
1995: p_entity_id_tab WSH_UTIL_CORE.id_tab_type;
1996:

Line 1994: p_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;

1990:
1991:
1992: x_stop_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;
1993:
1994: p_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
1995: p_entity_id_tab WSH_UTIL_CORE.id_tab_type;
1996:
1997: --For Workflow Impact on ITM
1998: l_parameter_list wf_parameter_list_t;

Line 2015: WSH_TRIP_STOPS WTL

2011: WTL.STOP_LOCATION_ID, WND.ORGANIZATION_ID, WND.DELIVERY_ID
2012: FROM
2013: WSH_DELIVERY_LEGS WDL ,
2014: WSH_NEW_DELIVERIES WND,
2015: WSH_TRIP_STOPS WTL
2016: WHERE
2017: WND.DELIVERY_ID= WDL.DELIVERY_ID AND
2018: WDL.DROP_OFF_STOP_ID=WTL.STOP_ID AND
2019: WDL.delivery_leg_id = l_delivery_leg_id;