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

Line 88: wsh_trip_stops wts1,

84: wts1.Departure_Seal_Code,
85: --Bug 3458160
86: wt.operator
87: FROM wsh_delivery_legs wdl,
88: wsh_trip_stops wts1,
89: wsh_trip_stops wts2,
90: wsh_trips wt
91: WHERE wts1.trip_id = wt.trip_id
92: AND wts2.trip_id = wt.trip_id

Line 89: wsh_trip_stops wts2,

85: --Bug 3458160
86: wt.operator
87: FROM wsh_delivery_legs wdl,
88: wsh_trip_stops wts1,
89: wsh_trip_stops wts2,
90: wsh_trips wt
91: WHERE wts1.trip_id = wt.trip_id
92: AND wts2.trip_id = wt.trip_id
93: AND wts1.stop_id = wdl.pick_up_stop_id

Line 1364: wsh_trip_stops wts1,

1360: wt.Routing_Instructions,
1361: wts1.Departure_Seal_Code,
1362: wt.operator
1363: FROM wsh_delivery_legs wdl,
1364: wsh_trip_stops wts1,
1365: wsh_trip_stops wts2,
1366: wsh_trips wt
1367: WHERE wts1.trip_id = wt.trip_id
1368: AND wts2.trip_id = wt.trip_id

Line 1365: wsh_trip_stops wts2,

1361: wts1.Departure_Seal_Code,
1362: wt.operator
1363: FROM wsh_delivery_legs wdl,
1364: wsh_trip_stops wts1,
1365: wsh_trip_stops wts2,
1366: wsh_trips wt
1367: WHERE wts1.trip_id = wt.trip_id
1368: AND wts2.trip_id = wt.trip_id
1369: AND wts1.stop_id = wdl.pick_up_stop_id

Line 1601: wsh_trip_stops wts,

1597: SELECT wdi.sequence_number
1598: INTO x_bill_of_lading_num
1599: FROM wsh_new_deliveries wnd,
1600: wsh_delivery_legs wdl,
1601: wsh_trip_stops wts,
1602: wsh_document_instances wdi
1603: WHERE wnd.delivery_id = p_delivery_id
1604: AND wnd.delivery_id = wdl.delivery_id
1605: AND wdl.pick_up_stop_id = wts.stop_id