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_INBOUND_UTIL_PKG dependencies on WSH_TRIP_STOPS

Line 1830: wsh_trip_stops wts,

1826: IS
1827: SELECT wt.trip_id, wt.name, wt.lane_id,
1828: NVL(wdl.reprice_Required,'N') reprice_required
1829: FROM wsh_trips wt,
1830: wsh_trip_stops wts,
1831: wsh_delivery_legs wdl
1832: WHERE wdl.delivery_id = p_delivery_id
1833: AND wdl.pick_up_stop_id = wts.stop_id
1834: AND wt.trip_id = wts.trip_id

Line 2235: FROM wsh_trip_stops wts1,

2231: --
2232: CURSOR linked_stop_csr (p_stop_id IN NUMBER)
2233: IS
2234: SELECT 1
2235: FROM wsh_trip_stops wts1,
2236: wsh_trip_stops wts2
2237: WHERE wts2.stop_id = p_stop_id
2238: AND wts2.trip_id = wts1.trip_id
2239: AND wts1.physical_stop_id = p_stop_id

Line 2236: wsh_trip_stops wts2

2232: CURSOR linked_stop_csr (p_stop_id IN NUMBER)
2233: IS
2234: SELECT 1
2235: FROM wsh_trip_stops wts1,
2236: wsh_trip_stops wts2
2237: WHERE wts2.stop_id = p_stop_id
2238: AND wts2.trip_id = wts1.trip_id
2239: AND wts1.physical_stop_id = p_stop_id
2240: AND wts1.status_code IN ('OP','AR')

Line 2246: l_stop_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;

2242: --
2243: --
2244: l_dummy NUMBER;
2245: l_stop_id NUMBER;
2246: l_stop_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;
2247: --
2248: l_debug_on BOOLEAN;
2249: l_reopen_flag BOOLEAN;
2250: --

Line 2358: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_ACTIONS.autoCLOSE',WSH_DEBUG_SV.C_PROC_LEVEL);

2354: l_stop_in_rec.actual_date := SYSDATE;
2355: --
2356: --
2357: IF l_debug_on THEN
2358: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_ACTIONS.autoCLOSE',WSH_DEBUG_SV.C_PROC_LEVEL);
2359: END IF;
2360: --
2361: WSH_TRIP_STOPS_ACTIONS.autoCloseOpen
2362: (

Line 2361: WSH_TRIP_STOPS_ACTIONS.autoCloseOpen

2357: IF l_debug_on THEN
2358: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_ACTIONS.autoCLOSE',WSH_DEBUG_SV.C_PROC_LEVEL);
2359: END IF;
2360: --
2361: WSH_TRIP_STOPS_ACTIONS.autoCloseOpen
2362: (
2363: p_in_rec => l_stop_in_rec,
2364: p_reopenStop => l_reopen_flag,
2365: x_stop_processed => x_processed,

Line 2480: FROM wsh_trip_stops pu_stop,

2476: do_stop.stop_location_id do_stop_locationId,
2477: do_Stop.status_code do_stop_statusCode,
2478: NVL(do_stop.shipments_type_flag,'O') do_stop_shipTypeFlag,
2479: pu_stop.trip_id trip_id
2480: FROM wsh_trip_stops pu_stop,
2481: wsh_trip_stops do_stop,
2482: wsh_delivery_legs wdl,
2483: wsh_new_deliveries wnd
2484: WHERE wnd.delivery_id = p_delivery_id

Line 2481: wsh_trip_stops do_stop,

2477: do_Stop.status_code do_stop_statusCode,
2478: NVL(do_stop.shipments_type_flag,'O') do_stop_shipTypeFlag,
2479: pu_stop.trip_id trip_id
2480: FROM wsh_trip_stops pu_stop,
2481: wsh_trip_stops do_stop,
2482: wsh_delivery_legs wdl,
2483: wsh_new_deliveries wnd
2484: WHERE wnd.delivery_id = p_delivery_id
2485: AND wdl.delivery_id = wnd.delivery_id

Line 2504: FROM wsh_trip_stops next_leg_do_stop,

2500: NVL(wnd.shipment_direction,'O') shipment_direction,
2501: wnd.status_code dlvy_status_code,
2502: wnd.ultimatE_dropoff_location_id dlvy_ultimate_doLocationId,
2503: next_leg_pu_stop.trip_id trip_id --3410681
2504: FROM wsh_trip_stops next_leg_do_stop,
2505: wsh_trip_stops next_leg_pu_stop,
2506: wsh_trip_stops curr_leg_do_stop,
2507: wsh_delivery_legs next_leg,
2508: wsh_delivery_legs curr_leg,

Line 2505: wsh_trip_stops next_leg_pu_stop,

2501: wnd.status_code dlvy_status_code,
2502: wnd.ultimatE_dropoff_location_id dlvy_ultimate_doLocationId,
2503: next_leg_pu_stop.trip_id trip_id --3410681
2504: FROM wsh_trip_stops next_leg_do_stop,
2505: wsh_trip_stops next_leg_pu_stop,
2506: wsh_trip_stops curr_leg_do_stop,
2507: wsh_delivery_legs next_leg,
2508: wsh_delivery_legs curr_leg,
2509: wsh_new_deliveries wnd

Line 2506: wsh_trip_stops curr_leg_do_stop,

2502: wnd.ultimatE_dropoff_location_id dlvy_ultimate_doLocationId,
2503: next_leg_pu_stop.trip_id trip_id --3410681
2504: FROM wsh_trip_stops next_leg_do_stop,
2505: wsh_trip_stops next_leg_pu_stop,
2506: wsh_trip_stops curr_leg_do_stop,
2507: wsh_delivery_legs next_leg,
2508: wsh_delivery_legs curr_leg,
2509: wsh_new_deliveries wnd
2510: WHERE next_leg.drop_off_stop_id = next_leg_do_stop.stop_id

Line 2535: FROM wsh_trip_stops

2531: --Bug 3410681 fixed.
2532: --Cursor to find any stops not closed for a trip.
2533: CURSOR stop_csr (p_trip_id IN NUMBER) IS
2534: SELECT count(stop_id)
2535: FROM wsh_trip_stops
2536: WHERE trip_id = p_trip_id
2537: AND status_code <> 'CL';
2538:
2539: l_trip_tbl wsh_util_core.key_value_tab_type;

Line 2566: l_stop_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;

2562: l_stop_processed VARCHAR2(10);
2563: l_allowed VARCHAR2(10);
2564: --
2565: --l_trip_in_rec WSH_TRIP_VALIDATIONS.ChgStatus_in_rec_type;
2566: l_stop_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;
2567:
2568:
2569: --
2570: l_debug_on BOOLEAN;