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

Line 1766: wsh_delivery_legs l1,

1762:
1763: cursor c_parent_info(p_del_id in NUMBER) is
1764: select s.trip_id, l2.delivery_id
1765: from wsh_trip_stops s,
1766: wsh_delivery_legs l1,
1767: wsh_delivery_legs l2,
1768: wsh_new_deliveries d
1769: where d.initial_pickup_location_id = s.stop_location_id
1770: and l1.delivery_id = d.delivery_id

Line 1767: wsh_delivery_legs l2,

1763: cursor c_parent_info(p_del_id in NUMBER) is
1764: select s.trip_id, l2.delivery_id
1765: from wsh_trip_stops s,
1766: wsh_delivery_legs l1,
1767: wsh_delivery_legs l2,
1768: wsh_new_deliveries d
1769: where d.initial_pickup_location_id = s.stop_location_id
1770: and l1.delivery_id = d.delivery_id
1771: and l1.pick_up_stop_id = s.stop_id

Line 1778: wsh_delivery_legs l,

1774:
1775: cursor c_pickup_trip(p_del_id in NUMBER) is
1776: select s.trip_id
1777: from wsh_trip_stops s,
1778: wsh_delivery_legs l,
1779: wsh_new_deliveries d
1780: where d.initial_pickup_location_id = s.stop_location_id
1781: and l.delivery_id = d.delivery_id
1782: and l.pick_up_stop_id = s.stop_id