APPS.WSH_TRIP_STOPS_ACTIONS dependencies on WSH_SHIPPING_PARAMETERS
Line 3213: FROM wsh_shipping_parameters wsp
3209: WHERE wts.trip_id = p_trip_id
3210: AND wts.stop_id = wdl.pick_up_stop_id
3211: AND wdl.delivery_id = wnd.delivery_id
3212: AND EXISTS ( SELECT 1 3213: FROM wsh_shipping_parameters wsp 3214: WHERE wnd.organization_id = wsp.organization_id
3215: AND wsp.otm_enabled = 'Y'
3216: )
3217: AND NOT EXISTS ( SELECT 1