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_TRIP_STOPS_VALIDATIONS dependencies on WSH_DELIVERY_LEGS

Line 530: FROM wsh_delivery_legs wdl

526: CURSOR c_wdl_details1 IS
527: SELECT pick_up_stop_id,
528: drop_off_stop_id,
529: wdl.delivery_id
530: FROM wsh_delivery_legs wdl
531: WHERE (pick_up_stop_id = p_stop_id
532: OR drop_off_stop_id = p_stop_id);
533:
534: CURSOR c_wdl_details2 IS

Line 538: FROM wsh_delivery_legs

534: CURSOR c_wdl_details2 IS
535: SELECT pick_up_stop_id,
536: drop_off_stop_id,
537: delivery_id
538: FROM wsh_delivery_legs
539: WHERE drop_off_stop_id = p_stop_id;
540:
541: l_rec_wdl1 WSH_TRIP_STOPS_VALIDATIONS.dleg_details_tab;
542: --l_rec_wdl2 c_wdl_details%TYPE;

Line 913: wsh_delivery_legs wdl,

909: NVL(wnd.tms_interface_flag,WSH_TRIP_STOPS_PVT.C_TMS_NOT_TO_BE_SENT) tms_interface_flag, -- OTM R12, glog proj
910: NVL(mcp.otm_enabled,wsp.otm_enabled) otm_enabled, -- LSP PROJECT : checking OTM enabled flag on client parameters.
911: wnd.client_id -- LSP PROJECT
912: from wsh_new_deliveries wnd,
913: wsh_delivery_legs wdl,
914: wsh_shipping_parameters wsp,
915: mtl_client_parameters_v mcp
916: where wnd.delivery_id = wdl.delivery_id
917: and (wdl.pick_up_stop_id = p_stop_id

Line 927: wsh_delivery_legs wdl

923: select distinct 'X'
924: from wsh_delivery_details wdd,
925: wsh_new_deliveries wnd,
926: wsh_delivery_assignments_v wda,
927: wsh_delivery_legs wdl
928: where (wdl.pick_up_stop_id = p_stop_id OR wdl.drop_off_stop_id = p_stop_id)
929: and wnd.delivery_id = wdl.delivery_id
930: and wda.delivery_id = wnd.delivery_id
931: and wdd.delivery_detail_id = wda.delivery_detail_id

Line 943: wsh_delivery_legs wdl

939: wnd.del_wf_intransit_attr,
940: wnd.del_wf_close_attr,
941: decode(p_stop_id,wdl.drop_off_stop_id,'D',wdl.pick_up_stop_id,'P','X') stop_type
942: from wsh_new_deliveries wnd,
943: wsh_delivery_legs wdl
944: where wnd.delivery_id = wdl.delivery_id
945: and (wdl.pick_up_stop_id = p_stop_id OR
946: wdl.drop_off_stop_id = p_stop_id );
947:

Line 2912: wsh_delivery_legs wdl

2908: --
2909: CURSOR open_pickup_dlvy_csr (p_stop_id NUMBER) IS
2910: SELECT nvl(shipment_direction,'O') shipment_direction
2911: FROM wsh_new_deliveries wnd,
2912: wsh_delivery_legs wdl
2913: WHERE wdl.pick_up_stop_id = p_stop_id
2914: AND wnd.delivery_id = wdl.delivery_id
2915: AND wnd.status_code IN ('OP', 'PA')
2916: ORDER BY DECODE( NVL(wnd.shipment_direction,'O'), 'O', 1, 'IO', 1, 'I', 2, 'D', 2, 2 );

Line 2938: wsh_delivery_legs wdl

2934: (DECODE(wnd.ultimate_dropoff_location_id,p_dummy_location_id,1, 2))
2935: ) last_stop,
2936: wdl.drop_off_stop_id drop_off_stop_id
2937: FROM wsh_new_deliveries wnd,
2938: wsh_delivery_legs wdl
2939: WHERE wdl.drop_off_stop_id IN (p_stop_id, p_dummy_stop_id)
2940: AND wnd.delivery_id = wdl.delivery_id
2941: AND (
2942: (

Line 2985: wsh_delivery_legs prev_leg,

2981: wt.name prev_leg_trip_name
2982: FROM wsh_trip_stops prev_leg_do_stop,
2983: wsh_trip_stops prev_leg_pu_stop,
2984: wsh_trip_stops curr_leg_pu_stop,
2985: wsh_delivery_legs prev_leg,
2986: wsh_delivery_legs curr_leg,
2987: wsh_new_deliveries wnd,
2988: wsh_trips wt
2989: WHERE prev_leg.drop_off_stop_id = prev_leg_do_stop.stop_id

Line 2986: wsh_delivery_legs curr_leg,

2982: FROM wsh_trip_stops prev_leg_do_stop,
2983: wsh_trip_stops prev_leg_pu_stop,
2984: wsh_trip_stops curr_leg_pu_stop,
2985: wsh_delivery_legs prev_leg,
2986: wsh_delivery_legs curr_leg,
2987: wsh_new_deliveries wnd,
2988: wsh_trips wt
2989: WHERE prev_leg.drop_off_stop_id = prev_leg_do_stop.stop_id
2990: --AND st1.status_code = 'OP'

Line 3043: wsh_delivery_legs prev_leg,

3039: wt.name prev_leg_trip_name
3040: FROM wsh_trip_stops prev_leg_do_stop,
3041: wsh_trip_stops prev_leg_pu_stop,
3042: wsh_trip_stops curr_leg_pu_stop,
3043: wsh_delivery_legs prev_leg,
3044: wsh_delivery_legs curr_leg,
3045: wsh_new_deliveries wnd,
3046: wsh_trips wt
3047: WHERE prev_leg.drop_off_stop_id = prev_leg_do_stop.stop_id

Line 3044: wsh_delivery_legs curr_leg,

3040: FROM wsh_trip_stops prev_leg_do_stop,
3041: wsh_trip_stops prev_leg_pu_stop,
3042: wsh_trip_stops curr_leg_pu_stop,
3043: wsh_delivery_legs prev_leg,
3044: wsh_delivery_legs curr_leg,
3045: wsh_new_deliveries wnd,
3046: wsh_trips wt
3047: WHERE prev_leg.drop_off_stop_id = prev_leg_do_stop.stop_id
3048: --AND st1.status_code = 'OP'

Line 3080: wsh_delivery_legs dl2,

3076: wnd.delivery_id delivery_id,
3077: wnd.status_code delivery_statusCode,
3078: wnd.initial_pickup_location_id dlvy_initialPULocationId
3079: FROM wsh_trip_stops st1,
3080: wsh_delivery_legs dl2,
3081: wsh_new_deliveries wnd
3082: WHERE dl2.pick_up_stop_id = st1.stop_id
3083: AND st1.status_code = 'CL'
3084: AND dl2.drop_off_stop_id IN (p_stop_id, p_linked_stop_id)

Line 3100: wsh_delivery_legs dg,

3096: DECODE(NVL(dl.shipment_direction,'O'), 'IO', dl.ultimate_dropoff_location_id, NULL) io_location_id,
3097: dl.name,
3098: dl.status_code
3099: FROM wsh_new_deliveries dl,
3100: wsh_delivery_legs dg,
3101: wsh_trip_stops st
3102: WHERE dg.delivery_id = dl.delivery_id
3103: AND st.stop_location_id = dl.initial_pickup_location_id
3104: AND st.stop_id = dg.pick_up_stop_id

Line 3123: wsh_delivery_legs dg,

3119: dl.name,
3120: dl.status_code,
3121: dg.drop_off_stop_id
3122: FROM wsh_new_deliveries dl,
3123: wsh_delivery_legs dg,
3124: wsh_trip_stops st
3125: WHERE dg.delivery_id = dl.delivery_id
3126: AND st.stop_location_id = dl.ultimate_dropoff_location_id
3127: AND st.stop_id = dg.drop_off_stop_id

Line 5064: wsh_delivery_legs wdl,

5060: IS
5061: SELECT wnd.initial_pickup_date delivery_Date,
5062: DECODE(wts.stop_location_id,wnd.initial_pickup_location_id,1,3) order_seq
5063: FROM wsh_new_deliveries wnd,
5064: wsh_delivery_legs wdl,
5065: wsh_trip_stops wts
5066: WHERE wts.stop_id = p_stop_id
5067: AND wdl.pick_up_stop_id = wts.stop_id
5068: AND wdl.delivery_id = wnd.delivery_id

Line 5073: wsh_delivery_legs wdl,

5069: UNION
5070: SELECT wnd.ultimate_dropoff_date delivery_Date,
5071: DECODE(wts.stop_location_id,wnd.ultimate_dropoff_location_id,2,4) order_seq
5072: FROM wsh_new_deliveries wnd,
5073: wsh_delivery_legs wdl,
5074: wsh_trip_stops wts
5075: WHERE wts.stop_id = p_stop_id
5076: AND wdl.drop_off_stop_id = wts.stop_id
5077: AND wdl.delivery_id = wnd.delivery_id