APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on WSH_CARRIERS

Line 297: wsh_carriers wc

293: AND enabled_flag = 'Y'
294: AND meaning like ( p_ship_method_name)
295: AND lookup_code in (select ship_method_code
296: from wsh_carrier_services wcs, wsh_org_carrier_services wocs,
297: wsh_carriers wc
298: where wocs.organization_id = p_organization_id
299: AND wcs.ship_method_code = flv.lookup_code
300: AND wcs.enabled_flag = 'Y'
301: AND wocs.enabled_flag = 'Y'

Line 3024: l_freight_code wsh_carriers.freight_code%TYPE;

3020:
3021: -- Start of fix for 4629955
3022: FUNCTION GET_FREIGHT_CODE(p_carrier_id IN NUMBER)
3023: RETURN VARCHAR2 IS
3024: l_freight_code wsh_carriers.freight_code%TYPE;
3025: BEGIN
3026: if p_carrier_id is null then
3027: return null;
3028: else

Line 3031: from wsh_carriers

3027: return null;
3028: else
3029: select freight_code
3030: into l_freight_code
3031: from wsh_carriers
3032: where carrier_id=p_carrier_id;
3033: end if;
3034: return l_freight_code;
3035: EXCEPTION