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

Line 3835: FROM wsh_delivery_legs l, wsh_trip_stops s1, wsh_new_deliveries d

3831:
3832: CURSOR c_trip_info(p_delivery_id IN NUMBER) IS
3833: SELECT s1.trip_id,
3834: NVL(d.ignore_for_planning, 'N') --OTM R12, delivery ignore same as trip's
3835: FROM wsh_delivery_legs l, wsh_trip_stops s1, wsh_new_deliveries d
3836: WHERE l.delivery_id = p_delivery_id
3837: AND d.delivery_id = l.delivery_id
3838: AND s1.stop_id = l.pick_up_stop_id
3839: AND s1.stop_location_id = d.initial_pickup_location_id;

Line 3847: FROM wsh_delivery_legs wdl

3843: FROM wsh_trip_stops wts
3844: WHERE wts.trip_id = p_trip_id
3845: AND NOT EXISTS (
3846: SELECT wdl.delivery_leg_id
3847: FROM wsh_delivery_legs wdl
3848: WHERE wdl.pick_up_stop_id = wts.stop_id
3849: OR wdl.drop_off_stop_id = wts.stop_id
3850: AND rownum = 1);
3851: