DBA Data[Home] [Help]

APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on WSH_TRIPS

Line 3354: wsh_trips tr,

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

Line 3412: l_cache_trip_sm WSH_TRIPS.SHIP_METHOD_CODE%TYPE;

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