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 11548: FROM fte_lanes

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

Line 11555: FROM fte_lanes l, fte_schedules s

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

Line 12604: FROM fte_lanes

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