eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_FREIGHT_RATING_DLVY_GRP dependencies on WSH_CARRIER_SERVICES

Line 216: FROM wsh_carrier_services

212: --
213: CURSOR c_carrier_services(c_shp_mthd_cd VARCHAR2)
214: IS
215: SELECT ship_method_code,carrier_id, service_level, mode_of_transport, ship_method_meaning
216: FROM wsh_carrier_services
217: WHERE ship_method_code = c_shp_mthd_cd;
218:
219: CURSOR c_get_ship_method (c_carrier_id VARCHAR2, c_mode_of_trans VARCHAR2, c_service_level VARCHAR2) IS
220: SELECT ship_method_code, ship_method_meaning

Line 221: FROM wsh_carrier_services

217: WHERE ship_method_code = c_shp_mthd_cd;
218:
219: CURSOR c_get_ship_method (c_carrier_id VARCHAR2, c_mode_of_trans VARCHAR2, c_service_level VARCHAR2) IS
220: SELECT ship_method_code, ship_method_meaning
221: FROM wsh_carrier_services
222: WHERE carrier_id = c_carrier_id
223: AND service_level = c_service_level
224: AND mode_of_transport = c_mode_of_trans;
225:

Line 228: FROM wsh_carrier_services a, wsh_org_carrier_services b

224: AND mode_of_transport = c_mode_of_trans;
225:
226: CURSOR c_get_ship_method_code (c_carrier_id VARCHAR2, c_mode_of_trans VARCHAR2, c_service_level VARCHAR2, c_org_id NUMBER) IS
227: SELECT a.ship_method_code, a.ship_method_meaning
228: FROM wsh_carrier_services a, wsh_org_carrier_services b
229: WHERE a.carrier_service_id = b.carrier_service_id
230: AND b.organization_id = c_org_id
231: AND b.enabled_flag = 'Y'
232: AND a.enabled_flag = 'Y'

Line 654: l_ship_method_code wsh_carrier_services.ship_method_code%type;

650: l_dlv_rec WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
651: c_dlv_rec c_delivery%ROWTYPE;
652:
653: c_carr_srv_rec c_carrier_services%ROWTYPE;
654: l_ship_method_code wsh_carrier_services.ship_method_code%type;
655: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
656: l_carrier_id NUMBER;
657: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
658: l_service_level wsh_carrier_services.service_level%type;

Line 655: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;

651: c_dlv_rec c_delivery%ROWTYPE;
652:
653: c_carr_srv_rec c_carrier_services%ROWTYPE;
654: l_ship_method_code wsh_carrier_services.ship_method_code%type;
655: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
656: l_carrier_id NUMBER;
657: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
658: l_service_level wsh_carrier_services.service_level%type;
659: --

Line 657: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;

653: c_carr_srv_rec c_carrier_services%ROWTYPE;
654: l_ship_method_code wsh_carrier_services.ship_method_code%type;
655: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
656: l_carrier_id NUMBER;
657: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
658: l_service_level wsh_carrier_services.service_level%type;
659: --
660: l_leg_id NUMBER;
661: l_trip_id NUMBER;

Line 658: l_service_level wsh_carrier_services.service_level%type;

654: l_ship_method_code wsh_carrier_services.ship_method_code%type;
655: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
656: l_carrier_id NUMBER;
657: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
658: l_service_level wsh_carrier_services.service_level%type;
659: --
660: l_leg_id NUMBER;
661: l_trip_id NUMBER;
662: i NUMBER := 0;

Line 2567: l_ship_method_code wsh_carrier_services.ship_method_code%type;

2563: l_leg_trip_det_rec c_leg_trip_det%ROWTYPE;
2564: l_count NUMBER;
2565:
2566: c_carr_srv_rec c_carrier_services%ROWTYPE;
2567: l_ship_method_code wsh_carrier_services.ship_method_code%type;
2568: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
2569: l_carrier_id NUMBER;
2570: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
2571: l_service_level wsh_carrier_services.service_level%type;

Line 2568: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;

2564: l_count NUMBER;
2565:
2566: c_carr_srv_rec c_carrier_services%ROWTYPE;
2567: l_ship_method_code wsh_carrier_services.ship_method_code%type;
2568: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
2569: l_carrier_id NUMBER;
2570: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
2571: l_service_level wsh_carrier_services.service_level%type;
2572: BEGIN

Line 2570: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;

2566: c_carr_srv_rec c_carrier_services%ROWTYPE;
2567: l_ship_method_code wsh_carrier_services.ship_method_code%type;
2568: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
2569: l_carrier_id NUMBER;
2570: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
2571: l_service_level wsh_carrier_services.service_level%type;
2572: BEGIN
2573:
2574: x_return_code := G_RC_SUCCESS;

Line 2571: l_service_level wsh_carrier_services.service_level%type;

2567: l_ship_method_code wsh_carrier_services.ship_method_code%type;
2568: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
2569: l_carrier_id NUMBER;
2570: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
2571: l_service_level wsh_carrier_services.service_level%type;
2572: BEGIN
2573:
2574: x_return_code := G_RC_SUCCESS;
2575:

Line 2798: l_ship_method_code wsh_carrier_services.ship_method_code%type;

2794: l_leg_trip_det_rec c_leg_trip_det%ROWTYPE;
2795: l_count NUMBER;
2796:
2797: c_carr_srv_rec c_carrier_services%ROWTYPE;
2798: l_ship_method_code wsh_carrier_services.ship_method_code%type;
2799: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
2800: l_carrier_id NUMBER;
2801: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
2802: l_service_level wsh_carrier_services.service_level%type;

Line 2799: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;

2795: l_count NUMBER;
2796:
2797: c_carr_srv_rec c_carrier_services%ROWTYPE;
2798: l_ship_method_code wsh_carrier_services.ship_method_code%type;
2799: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
2800: l_carrier_id NUMBER;
2801: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
2802: l_service_level wsh_carrier_services.service_level%type;
2803: BEGIN

Line 2801: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;

2797: c_carr_srv_rec c_carrier_services%ROWTYPE;
2798: l_ship_method_code wsh_carrier_services.ship_method_code%type;
2799: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
2800: l_carrier_id NUMBER;
2801: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
2802: l_service_level wsh_carrier_services.service_level%type;
2803: BEGIN
2804:
2805: x_return_code := G_RC_SUCCESS;

Line 2802: l_service_level wsh_carrier_services.service_level%type;

2798: l_ship_method_code wsh_carrier_services.ship_method_code%type;
2799: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
2800: l_carrier_id NUMBER;
2801: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
2802: l_service_level wsh_carrier_services.service_level%type;
2803: BEGIN
2804:
2805: x_return_code := G_RC_SUCCESS;
2806:

Line 2914: l_ship_method_code wsh_carrier_services.ship_method_code%type;

2910: l_delivery_id NUMBER;
2911: l_trip_id NUMBER;
2912:
2913: c_carr_srv_rec c_carrier_services%ROWTYPE;
2914: l_ship_method_code wsh_carrier_services.ship_method_code%type;
2915: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
2916: l_carrier_id NUMBER;
2917: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
2918: l_service_level wsh_carrier_services.service_level%type;

Line 2915: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;

2911: l_trip_id NUMBER;
2912:
2913: c_carr_srv_rec c_carrier_services%ROWTYPE;
2914: l_ship_method_code wsh_carrier_services.ship_method_code%type;
2915: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
2916: l_carrier_id NUMBER;
2917: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
2918: l_service_level wsh_carrier_services.service_level%type;
2919:

Line 2917: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;

2913: c_carr_srv_rec c_carrier_services%ROWTYPE;
2914: l_ship_method_code wsh_carrier_services.ship_method_code%type;
2915: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
2916: l_carrier_id NUMBER;
2917: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
2918: l_service_level wsh_carrier_services.service_level%type;
2919:
2920: l_generic_carrier VARCHAR2(1);
2921: l_initial_pickup_location_id NUMBER;

Line 2918: l_service_level wsh_carrier_services.service_level%type;

2914: l_ship_method_code wsh_carrier_services.ship_method_code%type;
2915: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
2916: l_carrier_id NUMBER;
2917: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
2918: l_service_level wsh_carrier_services.service_level%type;
2919:
2920: l_generic_carrier VARCHAR2(1);
2921: l_initial_pickup_location_id NUMBER;
2922: l_ultimate_dropoff_location_id NUMBER;

Line 3903: l_ship_method_code wsh_carrier_services.ship_method_code%type;

3899: l_trip_dleg_cnt NUMBER;
3900: l_lane_ids dbms_utility.number_array;
3901:
3902: c_carr_srv_rec c_carrier_services%ROWTYPE;
3903: l_ship_method_code wsh_carrier_services.ship_method_code%type;
3904: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
3905: l_carrier_id NUMBER;
3906: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
3907: l_service_level wsh_carrier_services.service_level%type;

Line 3904: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;

3900: l_lane_ids dbms_utility.number_array;
3901:
3902: c_carr_srv_rec c_carrier_services%ROWTYPE;
3903: l_ship_method_code wsh_carrier_services.ship_method_code%type;
3904: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
3905: l_carrier_id NUMBER;
3906: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
3907: l_service_level wsh_carrier_services.service_level%type;
3908: l_rank_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;

Line 3906: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;

3902: c_carr_srv_rec c_carrier_services%ROWTYPE;
3903: l_ship_method_code wsh_carrier_services.ship_method_code%type;
3904: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
3905: l_carrier_id NUMBER;
3906: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
3907: l_service_level wsh_carrier_services.service_level%type;
3908: l_rank_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
3909:
3910: BEGIN

Line 3907: l_service_level wsh_carrier_services.service_level%type;

3903: l_ship_method_code wsh_carrier_services.ship_method_code%type;
3904: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
3905: l_carrier_id NUMBER;
3906: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
3907: l_service_level wsh_carrier_services.service_level%type;
3908: l_rank_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
3909:
3910: BEGIN
3911:

Line 4191: l_ship_method_code wsh_carrier_services.ship_method_code%type;

4187: l_currency_code VARCHAR2(30);
4188:
4189: l_tl_rating_flag VARCHAR2(1);
4190: c_carr_srv_rec c_carrier_services%ROWTYPE;
4191: l_ship_method_code wsh_carrier_services.ship_method_code%type;
4192: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
4193: l_carrier_id NUMBER;
4194: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
4195: l_service_level wsh_carrier_services.service_level%type;

Line 4192: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;

4188:
4189: l_tl_rating_flag VARCHAR2(1);
4190: c_carr_srv_rec c_carrier_services%ROWTYPE;
4191: l_ship_method_code wsh_carrier_services.ship_method_code%type;
4192: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
4193: l_carrier_id NUMBER;
4194: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
4195: l_service_level wsh_carrier_services.service_level%type;
4196:

Line 4194: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;

4190: c_carr_srv_rec c_carrier_services%ROWTYPE;
4191: l_ship_method_code wsh_carrier_services.ship_method_code%type;
4192: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
4193: l_carrier_id NUMBER;
4194: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
4195: l_service_level wsh_carrier_services.service_level%type;
4196:
4197: l_org_manifest_enabled VARCHAR2(1);
4198: l_carrier_manifest_enabled VARCHAR2(1);

Line 4195: l_service_level wsh_carrier_services.service_level%type;

4191: l_ship_method_code wsh_carrier_services.ship_method_code%type;
4192: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
4193: l_carrier_id NUMBER;
4194: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
4195: l_service_level wsh_carrier_services.service_level%type;
4196:
4197: l_org_manifest_enabled VARCHAR2(1);
4198: l_carrier_manifest_enabled VARCHAR2(1);
4199: l_rank_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;

Line 4815: l_ship_method_code wsh_carrier_services.ship_method_code%type;

4811: l_rank_rec FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_rec;
4812:
4813:
4814: c_carr_srv_rec c_carrier_services%ROWTYPE;
4815: l_ship_method_code wsh_carrier_services.ship_method_code%type;
4816: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
4817: l_carrier_id NUMBER;
4818: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
4819: l_service_level wsh_carrier_services.service_level%type;

Line 4816: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;

4812:
4813:
4814: c_carr_srv_rec c_carrier_services%ROWTYPE;
4815: l_ship_method_code wsh_carrier_services.ship_method_code%type;
4816: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
4817: l_carrier_id NUMBER;
4818: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
4819: l_service_level wsh_carrier_services.service_level%type;
4820:

Line 4818: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;

4814: c_carr_srv_rec c_carrier_services%ROWTYPE;
4815: l_ship_method_code wsh_carrier_services.ship_method_code%type;
4816: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
4817: l_carrier_id NUMBER;
4818: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
4819: l_service_level wsh_carrier_services.service_level%type;
4820:
4821: l_carrier_name hz_parties.party_name%type;
4822: l_mode_of_transport2 fnd_lookup_values_vl.meaning%type;

Line 4819: l_service_level wsh_carrier_services.service_level%type;

4815: l_ship_method_code wsh_carrier_services.ship_method_code%type;
4816: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
4817: l_carrier_id NUMBER;
4818: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
4819: l_service_level wsh_carrier_services.service_level%type;
4820:
4821: l_carrier_name hz_parties.party_name%type;
4822: l_mode_of_transport2 fnd_lookup_values_vl.meaning%type;
4823: l_service_level2 fnd_lookup_values_vl.meaning%type;