APPS.WSH_TRIP_STOPS_ACTIONS dependencies on MTL_PARAMETERS

Line 3225: FROM mtl_parameters mtlp

3221: WHERE wts.trip_id = p_trip_id
3222: AND wts.stop_id = wdl.pick_up_stop_id
3223: AND wdl.delivery_id = wnd.delivery_id
3224: AND ( EXISTS ( SELECT 1
3225: FROM mtl_parameters mtlp
3226: WHERE mtlp.organization_id = wnd.organization_id
3227: AND mtlp.distributed_organization_flag = 'Y')
3228: OR wnd.delivery_type = 'CONSOLIDATION'))
3229: AND ROWNUM = 1;