APPS.WSH_TRIP_STOPS_ACTIONS dependencies on MTL_PARAMETERS

Line 3230: FROM mtl_parameters mtlp

3226: WHERE wts.trip_id = p_trip_id
3227: AND wts.stop_id = wdl.pick_up_stop_id
3228: AND wdl.delivery_id = wnd.delivery_id
3229: AND ( EXISTS ( SELECT 1
3230: FROM mtl_parameters mtlp
3231: WHERE mtlp.organization_id = wnd.organization_id
3232: AND mtlp.distributed_organization_flag = 'Y')
3233: OR wnd.delivery_type = 'CONSOLIDATION'))
3234: AND ROWNUM = 1;