DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_GEN dependencies on WMS_DEVICES_VL

Line 530: FROM wms_device_assignment_temp wdat, wms_devices_vl wd

526: SELECT wdat.assignment_temp_id
527: , wd.subinventory_code
528: INTO l_assignment_temp_id
529: , l_zone
530: FROM wms_device_assignment_temp wdat, wms_devices_vl wd
531: WHERE wdat.device_id = l_device_id
532: AND wdat.device_id = wd.device_id
533: AND employee_id = l_emp_id;
534: END IF;

Line 1117: FROM wms_device_assignment_temp wdat, wms_devices_vl wd

1113: SELECT wdat.assignment_temp_id
1114: , wd.subinventory_code
1115: INTO l_assignment_temp_id
1116: , l_zone
1117: FROM wms_device_assignment_temp wdat, wms_devices_vl wd
1118: WHERE wdat.device_id = l_device_id
1119: AND wdat.device_id = wd.device_id
1120: AND employee_id = l_emp_id;
1121: END IF;