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.FTE_TL_RATING dependencies on FTE_TRIP_MOVES

Line 627: WHERE wts1.trip_id IN (SELECT m.trip_id from fte_trip_moves m where m.move_id= c_move_id)

623: (SELECT wdl.delivery_id
624: FROM wsh_delivery_legs wdl,
625: wsh_trip_stops wts1,
626: wsh_trip_stops wts2
627: WHERE wts1.trip_id IN (SELECT m.trip_id from fte_trip_moves m where m.move_id= c_move_id)
628: AND wts2.trip_id = wts1.trip_id
629: AND wts1.stop_id = wdl.pick_up_stop_id
630: AND wts2.stop_id = wdl.drop_off_stop_id
631: );

Line 650: WHERE wts1.trip_id IN (SELECT m.trip_id from fte_trip_moves m where m.move_id=c_move_id)

646: (SELECT wdl.delivery_id
647: FROM wsh_delivery_legs wdl,
648: wsh_trip_stops wts1,
649: wsh_trip_stops wts2
650: WHERE wts1.trip_id IN (SELECT m.trip_id from fte_trip_moves m where m.move_id=c_move_id)
651: AND wts2.trip_id = wts1.trip_id
652: AND wts1.stop_id = wdl.pick_up_stop_id
653: AND wts2.stop_id = wdl.drop_off_stop_id
654: );

Line 1710: SELECT m.trip_id from fte_trip_moves m where m.move_id=c_move_id

1706: FROM wsh_delivery_legs dl ,
1707: wsh_trip_stops s
1708: WHERE
1709: s.trip_id IN (
1710: SELECT m.trip_id from fte_trip_moves m where m.move_id=c_move_id
1711: )
1712: and dl.pick_up_stop_id = s.stop_id
1713: and ( NVL(dl.reprice_required,'Y') = 'Y');
1714:

Line 2977: FROM FTE_TRIP_MOVES tm

2973: x_return_status OUT NOCOPY VARCHAR2) IS
2974:
2975: CURSOR get_move_id(c_trip_id IN NUMBER) IS
2976: SELECT tm.move_id
2977: FROM FTE_TRIP_MOVES tm
2978: WHERE tm.trip_id=c_trip_id;
2979:
2980: l_move_id NUMBER;
2981: l_output_cost_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;