APPS.FTE_PROCESS_REQUESTS dependencies on WSH_CARRIERS

Line 582: wsh_carriers wc

578: CURSOR get_generic_sm(p_mode VARCHAR2, p_service VARCHAR2, p_org_id NUMBER) IS
579: SELECT wcs.ship_method_code
580: FROM wsh_org_carrier_services wocs,
581: wsh_carrier_services wcs,
582: wsh_carriers wc
583: WHERE wcs.service_level= p_service AND
584: wcs.mode_of_transport= p_mode AND
585: wcs.enabled_flag = 'Y' AND
586: wcs.carrier_service_id = wocs.carrier_service_id AND

Line 596: wsh_carriers wc

592: CURSOR get_generic_sm_on_mod(p_mode VARCHAR2, p_org_id NUMBER) IS
593: SELECT wcs.ship_method_code
594: FROM wsh_org_carrier_services wocs,
595: wsh_carrier_services wcs,
596: wsh_carriers wc
597: WHERE
598: wcs.mode_of_transport = p_mode AND
599: wcs.enabled_flag = 'Y' AND
600: wcs.carrier_service_id = wocs.carrier_service_id AND

Line 610: wsh_carriers wc

606: CURSOR get_generic_sm_on_ser( p_service VARCHAR2, p_org_id NUMBER) IS
607: SELECT wcs.ship_method_code
608: FROM wsh_org_carrier_services wocs,
609: wsh_carrier_services wcs,
610: wsh_carriers wc
611: WHERE wcs.service_level = p_service AND
612: wcs.enabled_flag = 'Y' AND
613: wcs.carrier_service_id = wocs.carrier_service_id AND
614: wocs.organization_id = p_org_id AND

Line 1103: WSH_CARRIERS_GRP.Get_Carrier_Name(p_source_header_tab(i).carrier_id, l_carrier_name, l_freight_code);

1099: END IF;
1100:
1101: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1102: p_source_header_tab(i).status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1103: WSH_CARRIERS_GRP.Get_Carrier_Name(p_source_header_tab(i).carrier_id, l_carrier_name, l_freight_code);
1104: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEL_INCOMPLETE_SHIP_METHOD');
1105: FND_MESSAGE.SET_TOKEN('RULE_NAME', l_rule_name);
1106: FND_MESSAGE.SET_TOKEN('CARRIER_NAME', l_carrier_name);
1107: -- p_source_header_tab(i).message_data := FND_MESSAGE.GET;