APPS.FTE_FREIGHT_PRICING dependencies on FTE_LANE_RATE_CHARTS

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)