APPS.FTE_TL_CACHE dependencies on WSH_CARRIERS

Line 5358: --Gets info from wsh_carriers

5354: ORDER BY
5355: da.delivery_id;
5356:
5357:
5358: --Gets info from wsh_carriers
5359:
5360: CURSOR get_carrier_pref(c_carrier_id IN NUMBER) RETURN TL_CARRIER_PREF_REC_TYPE IS
5361: SELECT c.carrier_id,
5362: c.max_out_of_route,

Line 5385: FROM WSH_CARRIERS c

5381: c.dim_weight_uom,
5382: c.dim_volume_uom,
5383: c.dim_dimension_uom,
5384: c.dim_min_pack_vol
5385: FROM WSH_CARRIERS c
5386: WHERE c.carrier_id=c_carrier_id;
5387:
5388:
5389: ----

Line 6994: FROM WSH_CARRIERS c ,

6990: c.dim_weight_uom,
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

Line 7159: FROM WSH_CARRIERS c ,

7155: c.dim_weight_uom,
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:

Line 11488: --Gets info from wsh_carriers

11484: null
11485: FROM wsh_trips t
11486: WHERE t.trip_id=c_trip_id;
11487:
11488: --Gets info from wsh_carriers
11489:
11490: CURSOR get_carrier_pref(c_carrier_id IN NUMBER) RETURN TL_CARRIER_PREF_REC_TYPE IS
11491: SELECT c.carrier_id,
11492: c.max_out_of_route,

Line 11515: FROM WSH_CARRIERS c

11511: c.dim_weight_uom,
11512: c.dim_volume_uom,
11513: c.dim_dimension_uom,
11514: c.dim_min_pack_vol
11515: FROM WSH_CARRIERS c
11516: WHERE c.carrier_id=c_carrier_id;
11517:
11518:
11519: ----