APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on WSH_CARRIERS

Line 2746: wsh_carriers wcv,

2742: wsh_delivery_legs dg,
2743: wsh_new_deliveries dl,
2744: wsh_trip_stops st,
2745: wsh_trips tr,
2746: wsh_carriers wcv,
2747: wsh_delivery_details dd1,
2748: wsh_delivery_assignments_v da1
2749: WHERE st.stop_id = dg.pick_up_stop_id
2750: AND st.batch_id = p_batch_id

Line 2787: wsh_carriers_v wcv

2783: p_organization_id number) is
2784: SELECT wcv.freight_code freight_code
2785: FROM wsh_carrier_services wcs,
2786: wsh_org_carrier_services wocs,
2787: wsh_carriers_v wcv
2788: WHERE wcs.carrier_service_id = wocs.carrier_service_id AND
2789: wcs.carrier_id = wcv.carrier_id AND
2790: wcs.ship_method_code = p_ship_method_code AND
2791: wocs.organization_id = p_organization_id;

Line 2797: wsh_carriers wc

2793: -- FP bug 4166635: cursor to look up delivery's freight carrier
2794: CURSOR c_freight_code_del(p_delivery_id number) is
2795: SELECT wc.freight_code
2796: FROM wsh_new_deliveries wnd,
2797: wsh_carriers wc
2798: WHERE wnd.delivery_id = p_delivery_id AND
2799: wc.carrier_id = wnd.carrier_id;
2800:
2801: -- FP bug 4166635: cache single records for the default freight code

Line 2804: l_cache_trip_fc WSH_CARRIERS.FREIGHT_CODE%TYPE;

2800:
2801: -- FP bug 4166635: cache single records for the default freight code
2802: l_cache_trip_sm WSH_TRIPS.SHIP_METHOD_CODE%TYPE;
2803: l_cache_trip_org_id NUMBER;
2804: l_cache_trip_fc WSH_CARRIERS.FREIGHT_CODE%TYPE;
2805: l_cache_del_id NUMBER;
2806: l_cache_del_fc WSH_CARRIERS.FREIGHT_CODE%TYPE;
2807:
2808:

Line 2806: l_cache_del_fc WSH_CARRIERS.FREIGHT_CODE%TYPE;

2802: l_cache_trip_sm WSH_TRIPS.SHIP_METHOD_CODE%TYPE;
2803: l_cache_trip_org_id NUMBER;
2804: l_cache_trip_fc WSH_CARRIERS.FREIGHT_CODE%TYPE;
2805: l_cache_del_id NUMBER;
2806: l_cache_del_fc WSH_CARRIERS.FREIGHT_CODE%TYPE;
2807:
2808:
2809:
2810: -- Define this recode type to pass to GMI_Shipping_Util.GMI_UPDATE_SHIPMENT_TXN api.