APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on WSH_CARRIERS

Line 298: wsh_carriers wc

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

Line 3179: l_freight_code wsh_carriers.freight_code%TYPE;

3175:
3176: -- Start of fix for 4629955
3177: FUNCTION GET_FREIGHT_CODE(p_carrier_id IN NUMBER)
3178: RETURN VARCHAR2 IS
3179: l_freight_code wsh_carriers.freight_code%TYPE;
3180: BEGIN
3181: if p_carrier_id is null then
3182: return null;
3183: else

Line 3186: from wsh_carriers

3182: return null;
3183: else
3184: select freight_code
3185: into l_freight_code
3186: from wsh_carriers
3187: where carrier_id=p_carrier_id;
3188: end if;
3189: return l_freight_code;
3190: EXCEPTION