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_NEW_DELIVERIES

Line 62: wsh_delivery_legs wdl, wsh_new_deliveries wnd

58: l_procedure_name VARCHAR2(240) := 'FTE_TRACKING_WRAPPER.populate_child_delivery_legs';
59:
60: cursor get_org_delivery_info ( c_delivery_leg_id NUMBER) IS
61: SELECT wnd.delivery_id, wnd.organization_id FROM
62: wsh_delivery_legs wdl, wsh_new_deliveries wnd
63: WHERE wdl.delivery_id = wnd.delivery_id AND
64: wdl.delivery_leg_id = c_delivery_leg_id;
65:
66: BEGIN

Line 945: wsh_delivery_legs wdl, wsh_new_deliveries wnd

941: l_return_statuswf VARCHAR2(1);
942:
943: cursor get_org_delivery_info ( c_delivery_leg_id NUMBER) IS
944: SELECT wnd.delivery_id, wnd.organization_id FROM
945: wsh_delivery_legs wdl, wsh_new_deliveries wnd
946: WHERE wdl.delivery_id = wnd.delivery_id AND
947: wdl.delivery_leg_id = c_delivery_leg_id;
948:
949:

Line 1000: wsh_delivery_legs.delivery_id, wsh_trips.carrier_id, wsh_new_deliveries.waybill,

996: IF (UPPER(l_tracking_id_type) = 'WAYBILL') THEN
997:
998:
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

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 1004: WHERE wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id

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
1008: AND wsh_new_deliveries.waybill = l_tracking_id

Line 1008: AND wsh_new_deliveries.waybill = l_tracking_id

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:
1011:
1012:

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 1097: WHERE wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id

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
1101: AND wsh_delivery_legs.booking_number = l_tracking_id

Line 1182: select wsh_new_deliveries.delivery_id, wsh_delivery_legs.delivery_leg_id,

1178:
1179:
1180: elsif (upper(l_tracking_id_type) = 'BILL OF LADING')
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

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 1187: and wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_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
1190: and wsh_trips.carrier_id = l_carrier_id
1191: and wsh_bols_rd_v.bill_of_lading_number = l_tracking_id

Line 1275: select wsh_new_deliveries.delivery_id, wsh_delivery_legs.delivery_leg_id,

1271: -- method will not be called.
1272:
1273: elsif (upper(l_tracking_id_type) = 'LICENSE PLATE NUMBER')
1274: then -- license plate number is only used by container
1275: select wsh_new_deliveries.delivery_id, wsh_delivery_legs.delivery_leg_id,
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

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 1282: where wsh_delivery_assignments.DELIVERY_ID = wsh_new_deliveries.DELIVERY_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
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

Line 1285: and wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id

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

Line 1350: wsh_new_deliveries wnd,

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
1353: where wda.DELIVERY_ID = wnd.DELIVERY_ID
1354: and wda.DELIVERY_DETAIL_ID = wdd.DELIVERY_DETAIL_ID

Line 1422: -- not in wsh_new_deliveries level

1418:
1419: elsif (upper(l_tracking_id_type) = 'CARRIER REFERENCE NUMBER')
1420: then -- tracking number is only used for container.
1421: -- It is only in wsh_delivery_details level,
1422: -- not in wsh_new_deliveries level
1423:
1424:
1425: select wsh_new_deliveries.delivery_id, wsh_delivery_legs.delivery_leg_id,
1426: wsh_trips.carrier_id, wsh_delivery_details.tracking_number,

Line 1425: select wsh_new_deliveries.delivery_id, wsh_delivery_legs.delivery_leg_id,

1421: -- It is only in wsh_delivery_details level,
1422: -- not in wsh_new_deliveries level
1423:
1424:
1425: select wsh_new_deliveries.delivery_id, wsh_delivery_legs.delivery_leg_id,
1426: wsh_trips.carrier_id, wsh_delivery_details.tracking_number,
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

Line 1430: from wsh_new_deliveries, wsh_delivery_legs, wsh_trips,

1426: wsh_trips.carrier_id, wsh_delivery_details.tracking_number,
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

Line 1432: where wsh_delivery_assignments.DELIVERY_ID = wsh_new_deliveries.DELIVERY_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
1436: and wsh_delivery_legs.pick_up_stop_id = wsh_trip_stops.stop_id

Line 1435: and wsh_delivery_legs.delivery_id = wsh_new_deliveries.delivery_id

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

Line 2014: WSH_NEW_DELIVERIES WND,

2010: WTL.STATUS_CODE,WND.ULTIMATE_DROPOFF_LOCATION_ID,
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

Line 2023: wsh_delivery_legs wdl, wsh_new_deliveries wnd

2019: WDL.delivery_leg_id = l_delivery_leg_id;
2020:
2021: cursor get_org_delivery_info ( c_delivery_leg_id NUMBER) IS
2022: SELECT wnd.delivery_id, wnd.organization_id FROM
2023: wsh_delivery_legs wdl, wsh_new_deliveries wnd
2024: WHERE wdl.delivery_id = wnd.delivery_id AND
2025: wdl.delivery_leg_id = c_delivery_leg_id;
2026:
2027: BEGIN