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

Line 565: wsh_delivery_legs wdl,

561: wnd.status_code,
562: wnd.planned_flag,
563: wnd.delivery_id
564: from wsh_new_deliveries wnd,
565: wsh_delivery_legs wdl,
566: wsh_trip_stops wts1,
567: wsh_trip_stops wts2,
568: wsh_trips wt
569: where wnd.delivery_id = wdl.delivery_id

Line 583: wsh_delivery_legs wdl

579: wnd.status_code,
580: wnd.planned_flag,
581: wnd.delivery_id
582: from wsh_new_deliveries wnd,
583: wsh_delivery_legs wdl
584: where wnd.delivery_id = wdl.delivery_id
585: and wdl.pick_up_stop_id = p_stop_id
586: and rownum = 1;
587:

Line 631: wsh_delivery_legs wdl

627: cursor stop_to_det_cur( p_stop_id IN NUMBER ) is
628: select 'X'
629: from wsh_delivery_details wdd,
630: wsh_delivery_assignments_v wda,
631: wsh_delivery_legs wdl
632: where wdl.pick_up_stop_id = p_stop_id
633: and wda.delivery_id is not null
634: and wda.delivery_id = wdl.delivery_id
635: and wdd.delivery_detail_id = wda.delivery_detail_id

Line 645: wsh_delivery_legs wdl,

641: select distinct 'X'
642: from wsh_delivery_details wdd,
643: wsh_new_deliveries wnd,
644: wsh_delivery_assignments_v wda,
645: wsh_delivery_legs wdl,
646: wsh_trip_stops wts1,
647: wsh_trip_stops wts2,
648: wsh_trips wt
649: where wt.trip_id = p_trip_id