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