DBA Data[Home] [Help]

APPS.FTE_FREIGHT_PRICING dependencies on FTE_SCHEDULES

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 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);