APPS.FTE_FREIGHT_PRICING dependencies on FTE_LANES

Line 7362: FROM fte_lanes fl, fte_lane_rate_charts flrc

7358: CURSOR c_get_lane_info(c_lane_id IN NUMBER) IS
7359: SELECT fl.lane_id,fl.carrier_id,flrc.list_header_id pricelist_id,
7360: fl.mode_of_transportation_code,fl.origin_id,fl.destination_id,
7361: fl.basis,fl.commodity_catg_id,fl.service_type_code,fl.comm_fc_class_code
7362: FROM fte_lanes fl, fte_lane_rate_charts flrc
7363: WHERE fl.lane_id = c_lane_id
7364: AND fl.lane_id = flrc.lane_id
7365: AND (flrc.start_date_active is null OR flrc.start_date_active <= p_ship_date)
7366: AND (flrc.end_date_active is null OR flrc.end_date_active > p_ship_date);

Line 7372: FROM fte_lanes fl, wsh_trips wt, fte_lane_rate_charts flrc

7368: CURSOR c_get_lane_info_from_trip(c_wsh_trip_id IN NUMBER) IS
7369: SELECT fl.lane_id,fl.carrier_id,flrc.list_header_id pricelist_id,
7370: fl.mode_of_transportation_code,fl.origin_id,fl.destination_id,
7371: fl.basis,fl.commodity_catg_id,fl.service_type_code,fl.comm_fc_class_code
7372: FROM fte_lanes fl, wsh_trips wt, fte_lane_rate_charts flrc
7373: WHERE fl.lane_id = wt.lane_id
7374: AND wt.trip_id = c_wsh_trip_id
7375: AND fl.lane_id = flrc.lane_id
7376: AND (flrc.start_date_active is null OR flrc.start_date_active <= p_ship_date)

Line 7383: FROM fte_lanes fl, fte_schedules fs, fte_lane_rate_charts flrc

7379: CURSOR c_get_lane_info_from_schedule(c_schedule_id IN NUMBER) IS
7380: SELECT fl.lane_id,fl.carrier_id,flrc.list_header_id pricelist_id,
7381: fl.mode_of_transportation_code,fl.origin_id,fl.destination_id,
7382: fl.basis,fl.commodity_catg_id,fl.service_type_code,fl.comm_fc_class_code
7383: FROM fte_lanes fl, fte_schedules fs, fte_lane_rate_charts flrc
7384: WHERE fl.lane_id = fs.lane_id
7385: AND fs.schedules_id = c_schedule_id
7386: AND fl.lane_id = flrc.lane_id
7387: AND (flrc.start_date_active is null OR flrc.start_date_active <= p_ship_date)

Line 11549: FROM fte_lanes

11545:
11546: CURSOR c_get_lane_mode(c_lane_id IN NUMBER)
11547: IS
11548: SELECT mode_of_transportation_code
11549: FROM fte_lanes
11550: WHERE lane_id = c_lane_id;
11551:
11552:
11553: CURSOR c_get_sched_mode(c_schedule_id IN NUMBER)

Line 11556: FROM fte_lanes l, fte_schedules s

11552:
11553: CURSOR c_get_sched_mode(c_schedule_id IN NUMBER)
11554: IS
11555: SELECT mode_of_transportation_code
11556: FROM fte_lanes l, fte_schedules s
11557: WHERE l.lane_id = s.lane_id
11558: AND s.schedules_id = c_schedule_id;
11559:
11560: l_mode VARCHAR2(30);

Line 12605: FROM fte_lanes

12601: FROM sys.dual;
12602:
12603: CURSOR c_get_carrier_for_lane(c_lane_id IN NUMBER) IS
12604: SELECT carrier_id
12605: FROM fte_lanes
12606: WHERE lane_id = c_lane_id;
12607:
12608: l_return_status VARCHAR2(1);
12609: l_return_code NUMBER;