APPS.WMS_TASK_DISPATCH_DEVICE dependencies on WMS_DEVICES_B

Line 487: FROM wms_bus_event_devices wbed , wms_devices_b wd

483: SELECT device_id
484: INTO l_device_id
485: FROM (
486: SELECT wbed.DEVICE_ID
487: FROM wms_bus_event_devices wbed , wms_devices_b wd
488: WHERE wd.device_id = wbed.device_id
489: AND WBED.organization_id = WD.organization_id
490: AND wd.ENABLED_FLAG = 'Y'
491: AND decode (level_type, 200,wbed.subinventory_code,level_value) =