APPS.FTE_TL_CACHE dependencies on FTE_SCHEDULES

Line 6996: FTE_SCHEDULES s

6992: c.dim_dimension_uom,
6993: c.dim_min_pack_vol
6994: FROM WSH_CARRIERS c ,
6995: FTE_LANES l,
6996: FTE_SCHEDULES s
6997: WHERE c.carrier_id=l.carrier_id and
6998: s.schedules_id=c_schedule_id and
6999: s.lane_id=l.lane_id;
7000:

Line 7031: FTE_SCHEDULES s

7027: c.dim_dimension_uom,
7028: c.dim_min_pack_vol
7029: FROM WSH_CARRIER_SERVICES c ,
7030: FTE_LANES l,
7031: FTE_SCHEDULES s
7032: WHERE c.carrier_id=l.carrier_id and
7033: c.service_level=l.service_type_code and
7034: s.schedules_id=c_schedule_id and
7035: s.lane_id=l.lane_id;

Line 7383: fte_schedules s,

7379: l.service_type_code,
7380: s.schedules_id,
7381: flrc.list_header_id
7382: FROM fte_lanes l,
7383: fte_schedules s,
7384: fte_lane_rate_charts flrc
7385: WHERE l.lane_id=s.lane_id
7386: AND (l.lane_id = flrc.lane_id )
7387: AND (flrc.start_date_active is null

Line 7708: FTE_SCHEDULES s

7704: l.service_type_code,
7705: l.mode_of_transportation_code,
7706: l.pricelist_id
7707: FROM FTE_LANES l,
7708: FTE_SCHEDULES s
7709: WHERE l.lane_id=s.lane_id and
7710: s.schedules_id=c_schedule_id;
7711:
7712: l_dleg_rec TL_delivery_leg_rec_type;

Line 8665: fte_schedules s

8661: l.carrier_id,
8662: l.service_type_code,
8663: l.mode_of_transportation_code
8664: FROM fte_lanes l,
8665: fte_schedules s
8666: WHERE s.schedules_id=c_schedule_id and
8667: s.lane_id=l.lane_id;
8668:
8669:

Line 12329: fte_schedules s

12325: l.carrier_id,
12326: l.service_type_code,
12327: l.mode_of_transportation_code
12328: FROM fte_lanes l,
12329: fte_schedules s
12330: WHERE s.schedules_id=c_schedule_id and
12331: s.lane_id=l.lane_id;
12332:
12333: