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_LANES

Line 137: FTE_LANES l

133: --Gets the default vehicle for the lane through the carrier service level.
134: CURSOR get_lane_def_vehicle (c_lane_id IN NUMBER) IS
135: SELECT c.default_vehicle_type_id
136: FROM WSH_CARRIER_SERVICES c ,
137: FTE_LANES l
138: WHERE c.carrier_id=l.carrier_id and
139: c.service_level=l.service_type_code and
140: l.lane_id=c_lane_id;
141:

Line 146: FTE_LANES l,

142: --Gets the default vehicle for the schedule through the carrier service level.
143: CURSOR get_schedule_def_vehicle(c_schedule_id IN NUMBER) IS
144: SELECT c.default_vehicle_type_id
145: FROM WSH_CARRIER_SERVICES c ,
146: FTE_LANES l,
147: FTE_SCHEDULES s
148: WHERE c.carrier_id=l.carrier_id and
149: c.service_level=l.service_type_code and
150: s.schedules_id=c_schedule_id and

Line 159: fte_lanes l

155: CURSOR get_lane_carrier_vehicles(c_lane_id IN NUMBER) IS
156: SELECT wcvt.vehicle_type_id,
157: l.carrier_id
158: FROM wsh_carrier_vehicle_types wcvt,
159: fte_lanes l
160: WHERE l.lane_id=c_lane_id
161: and l.carrier_id=wcvt.carrier_id
162: and wcvt.assigned_flag='Y';
163:

Line 170: fte_lanes l ,

166: CURSOR get_schedule_carrier_vehicles(c_schedule_id IN NUMBER) IS
167: SELECT wcvt.vehicle_type_id,
168: l.carrier_id
169: FROM wsh_carrier_vehicle_types wcvt,
170: fte_lanes l ,
171: fte_schedules s
172: WHERE s.schedules_id=c_schedule_id
173: and l.lane_id=s.lane_id
174: and l.carrier_id=wcvt.carrier_id