DBA Data[Home] [Help]

APPS.FTE_TL_CACHE dependencies on FTE_LANES

Line 6995: FTE_LANES l,

6991: c.dim_volume_uom,
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;

Line 7030: FTE_LANES l,

7026: c.dim_volume_uom,
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

Line 7160: FTE_LANES l

7156: c.dim_volume_uom,
7157: c.dim_dimension_uom,
7158: c.dim_min_pack_vol
7159: FROM WSH_CARRIERS c ,
7160: FTE_LANES l
7161: WHERE c.carrier_id=l.carrier_id and
7162: l.lane_id=c_lane_id;
7163:
7164:

Line 7194: FTE_LANES l

7190: c.dim_volume_uom,
7191: c.dim_dimension_uom,
7192: c.dim_min_pack_vol
7193: FROM WSH_CARRIER_SERVICES c ,
7194: FTE_LANES l
7195: WHERE c.carrier_id=l.carrier_id and
7196: c.service_level=l.service_type_code and
7197: l.lane_id=c_lane_id;
7198:

Line 7299: FROM fte_lanes l,

7295: l.carrier_id,
7296: l.mode_of_transportation_code,
7297: l.service_type_code,
7298: flrc.list_header_id
7299: FROM fte_lanes l,
7300: fte_lane_rate_charts flrc
7301: WHERE l.lane_id=c_lane_id
7302: AND (l.lane_id = flrc.lane_id )
7303: AND (flrc.start_date_active is null

Line 7382: FROM fte_lanes l,

7378: l.mode_of_transportation_code,
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 )

Line 7695: FROM FTE_LANES l

7691: SELECT l.lane_id,
7692: l.service_type_code,
7693: l.mode_of_transportation_code,
7694: l.pricelist_id
7695: FROM FTE_LANES l
7696: WHERE l.lane_id=c_lane_id;
7697:
7698:
7699:

Line 7707: FROM FTE_LANES l,

7703: SELECT l.lane_id,
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:

Line 8655: FROM fte_lanes l

8651: SELECT null,
8652: l.carrier_id,
8653: l.service_type_code,
8654: l.mode_of_transportation_code
8655: FROM fte_lanes l
8656: WHERE l.lane_id=c_lane_id;
8657:
8658: CURSOR get_schedule_info(c_schedule_id IN NUMBER) IS
8659: SELECT l.lane_id,

Line 8664: FROM fte_lanes l,

8660: null,
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:

Line 12319: FROM fte_lanes l

12315: SELECT null,
12316: l.carrier_id,
12317: l.service_type_code,
12318: l.mode_of_transportation_code
12319: FROM fte_lanes l
12320: WHERE l.lane_id=c_lane_id;
12321:
12322: CURSOR get_schedule_info(c_schedule_id IN NUMBER) IS
12323: SELECT l.lane_id,

Line 12328: FROM fte_lanes l,

12324: null,
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: