DBA Data[Home] [Help]

APPS.WSH_TRIP_STOPS_ACTIONS dependencies on STANDARD

Line 56: AND dl.delivery_type = 'STANDARD' --sperera, MDC

52: and dg.delivery_id = dl.delivery_id
53: and st.stop_location_id = dl.initial_pickup_location_id
54: and st.stop_id = dg.pick_up_stop_id
55: AND nvl(dl.shipment_direction,'O') IN ('O','IO') -- J-IB-NPARIKH
56: AND dl.delivery_type = 'STANDARD' --sperera, MDC
57: and dl.status_code IN ( 'OP', 'PA', 'SA') ;
58:
59: del_ids wsh_util_core.id_tab_type;
60: stop_ids wsh_util_core.id_tab_type;