APPS.FTE_TL_CACHE dependencies on WSH_CARRIER_SERVICES

Line 5391: --Gets info from wsh_carrier_services

5387:
5388:
5389: ----
5390:
5391: --Gets info from wsh_carrier_services
5392:
5393: CURSOR get_carrier_service_pref(c_carrier_id IN NUMBER,c_service_level IN
5394: VARCHAR2) RETURN TL_CARRIER_PREF_REC_TYPE IS
5395: SELECT c.carrier_id,

Line 5419: FROM WSH_CARRIER_SERVICES c

5415: c.dim_weight_uom,
5416: c.dim_volume_uom,
5417: c.dim_dimension_uom,
5418: c.dim_min_pack_vol
5419: FROM WSH_CARRIER_SERVICES c
5420: WHERE c.carrier_id=c_carrier_id and
5421: c.service_level=c_service_level;
5422:
5423: --Gets all the stops for a given trip ,ordered by sequence number

Line 7029: FROM WSH_CARRIER_SERVICES c ,

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

Line 7193: FROM WSH_CARRIER_SERVICES c ,

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

Line 11521: --Gets info from wsh_carrier_services

11517:
11518:
11519: ----
11520:
11521: --Gets info from wsh_carrier_services
11522:
11523: CURSOR get_carrier_service_pref(c_carrier_id IN NUMBER,c_service_level IN
11524: VARCHAR2) RETURN TL_CARRIER_PREF_REC_TYPE IS
11525: SELECT c.carrier_id,

Line 11549: FROM WSH_CARRIER_SERVICES c

11545: c.dim_weight_uom,
11546: c.dim_volume_uom,
11547: c.dim_dimension_uom,
11548: c.dim_min_pack_vol
11549: FROM WSH_CARRIER_SERVICES c
11550: WHERE c.carrier_id=c_carrier_id and
11551: c.service_level=c_service_level;
11552:
11553: