APPS.WMS_TASK_DISPATCH_DEVICE dependencies on WMS_DEVICES_VL

Line 385: FROM wms_devices_vl wdv

381: IF is_org_wcs_enabled = 'Y' THEN
382:
383: SELECT nvl(device_type_id, -1)
384: INTO l_device_type_id
385: FROM wms_devices_vl wdv
386: WHERE wdv.organization_id = p_organization_id
387: AND wdv.name = p_device_name;
388:
389: IF (l_debug = 1) THEN

Line 403: WMS_DEVICES_VL wvl

399: BEGIN
400: SELECT 1
401: INTO l_signed_onto_wrk_stn
402: FROM WMS_DEVICE_ASSIGNMENT_TEMP wda,
403: WMS_DEVICES_VL wvl
404: WHERE wda.device_id = wvl.device_id
405: AND wvl.organization_id = p_organization_id
406: AND wda.employee_id = p_emp_id
407: AND device_type_id = 100;

Line 424: , WMS_DEVICES_VL wvl

420: , wvl.description
421: INTO l_is_device_signed
422: , x_device_desc
423: FROM WMS_DEVICE_ASSIGNMENT_TEMP wda
424: , WMS_DEVICES_VL wvl
425: WHERE wda.device_id = wvl.device_id
426: AND (wvl.subinventory_code IS NOT NULL OR device_type_id = 100)
427: AND l_is_multi_signon_dev <> 'Y'
428: AND wvl.organization_id = p_organization_id

Line 447: FROM WMS_DEVICES_VL

443: INTO x_device_type
444: , x_device_desc
445: , x_device_id
446: , x_subinventory
447: FROM WMS_DEVICES_VL
448: WHERE (subinventory_code IS NOT NULL OR device_type_id = 100)
449: AND organization_id = p_organization_id
450: AND name = p_device_name
451: AND device_type_id <> 7 ;