APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on WSH_CARRIERS

Line 3355: wsh_carriers wcv,

3351: wsh_delivery_legs dg,
3352: wsh_new_deliveries dl,
3353: wsh_trip_stops st,
3354: wsh_trips tr,
3355: wsh_carriers wcv,
3356: wsh_delivery_details dd1,
3357: wsh_delivery_assignments_v da1
3358: WHERE st.stop_id = dg.pick_up_stop_id
3359: AND st.batch_id = p_batch_id

Line 3397: wsh_carriers_v wcv

3393: p_organization_id number) is
3394: SELECT wcv.freight_code freight_code
3395: FROM wsh_carrier_services wcs,
3396: wsh_org_carrier_services wocs,
3397: wsh_carriers_v wcv
3398: WHERE wcs.carrier_service_id = wocs.carrier_service_id AND
3399: wcs.carrier_id = wcv.carrier_id AND
3400: wcs.ship_method_code = p_ship_method_code AND
3401: wocs.organization_id = p_organization_id;

Line 3407: wsh_carriers wc

3403: -- FP bug 4166635: cursor to look up delivery's freight carrier
3404: CURSOR c_freight_code_del(p_delivery_id number) is
3405: SELECT wc.freight_code
3406: FROM wsh_new_deliveries wnd,
3407: wsh_carriers wc
3408: WHERE wnd.delivery_id = p_delivery_id AND
3409: wc.carrier_id = wnd.carrier_id;
3410:
3411: -- FP bug 4166635: cache single records for the default freight code

Line 3414: l_cache_trip_fc WSH_CARRIERS.FREIGHT_CODE%TYPE;

3410:
3411: -- FP bug 4166635: cache single records for the default freight code
3412: l_cache_trip_sm WSH_TRIPS.SHIP_METHOD_CODE%TYPE;
3413: l_cache_trip_org_id NUMBER;
3414: l_cache_trip_fc WSH_CARRIERS.FREIGHT_CODE%TYPE;
3415: l_cache_del_id NUMBER;
3416: l_cache_del_fc WSH_CARRIERS.FREIGHT_CODE%TYPE;
3417:
3418:

Line 3416: l_cache_del_fc WSH_CARRIERS.FREIGHT_CODE%TYPE;

3412: l_cache_trip_sm WSH_TRIPS.SHIP_METHOD_CODE%TYPE;
3413: l_cache_trip_org_id NUMBER;
3414: l_cache_trip_fc WSH_CARRIERS.FREIGHT_CODE%TYPE;
3415: l_cache_del_id NUMBER;
3416: l_cache_del_fc WSH_CARRIERS.FREIGHT_CODE%TYPE;
3417:
3418:
3419:
3420: -- Define this recode type to pass to GMI_Shipping_Util.GMI_UPDATE_SHIPMENT_TXN api.