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_LANE_SEARCH dependencies on FTE_LANE_VEHICLES

Line 262: (select 1 from fte_lane_vehicles

258: where carrier_id = p_carrier_id
259: and vehicle_type_id = p_vehicle_id
260: and assigned_flag = 'Y'
261: and not exists
262: (select 1 from fte_lane_vehicles
263: where quantity = 0
264: and origin_id = p_origin_id
265: and destination_id = p_dest_id
266: and carrier_id = p_carrier_id

Line 270: select 1 from fte_lane_group_components c, fte_lane_vehicles l

266: and carrier_id = p_carrier_id
267: and nvl(effective_start_date, nvl(p_date, sysdate)) <= nvl(p_date, sysdate)
268: and nvl(effective_end_date, nvl(p_date, sysdate)) >= nvl(p_date, sysdate)
269: UNION
270: select 1 from fte_lane_group_components c, fte_lane_vehicles l
271: where l.quantity = 0
272: and c.lane_group_id = l.lane_group_id
273: and c.origin_id = p_origin_id
274: and c.destination_id = p_dest_id

Line 303: --with zero quantity in fte_lane_vehicles, then the vehicle is available

299: l_available := c_vehicle_available%FOUND;
300: close c_vehicle_available;
301:
302: --If we don't find a row for the carrier, origin and destination
303: --with zero quantity in fte_lane_vehicles, then the vehicle is available
304: --only if it is assigned to the carrier. This means that the vehicle HAS
305: --to be assigned to the carrier in order for the lane to be used.
306: IF (NOT l_available) THEN
307: x_return_message := 'The vehicle is either not assigned to the carrier ' ||