DBA Data[Home] [Help]

APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on WSH_TRIPS

Line 2745: wsh_trips tr,

2741: wsh_delivery_assignments_v da,
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

Line 2802: l_cache_trip_sm WSH_TRIPS.SHIP_METHOD_CODE%TYPE;

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
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;