APPS.WMS_TASK_DISPATCH_GEN dependencies on WMS_DEVICE_ASSIGNMENT_TEMP

Line 264: FROM wms_device_assignment_temp wdat, wms_devices_b wdb

260: CURSOR following_device_list(p_emp_id NUMBER, p_current_device_temp_id NUMBER) IS
261: SELECT wdat.device_id
262: , wdat.assignment_temp_id
263: , wdb.subinventory_code
264: FROM wms_device_assignment_temp wdat, wms_devices_b wdb
265: WHERE wdat.assignment_temp_id >= p_current_device_temp_id
266: AND wdat.employee_id = p_emp_id
267: AND wdat.device_id = wdb.device_id
268: ORDER BY wdat.assignment_temp_id;

Line 274: FROM wms_device_assignment_temp wdat, wms_devices_b wdb

270: CURSOR front_device_list(p_emp_id NUMBER, p_current_device_temp_id NUMBER) IS
271: SELECT wdat.device_id
272: , wdat.assignment_temp_id
273: , wdb.subinventory_code
274: FROM wms_device_assignment_temp wdat, wms_devices_b wdb
275: WHERE wdat.assignment_temp_id < p_current_device_temp_id
276: AND wdat.employee_id = p_emp_id
277: AND wdat.device_id = wdb.device_id
278: ORDER BY wdat.assignment_temp_id;

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 1035: FROM wms_device_assignment_temp wdat, wms_devices_b wdb

1031: CURSOR following_device_list(p_emp_id NUMBER, p_current_device_temp_id NUMBER) IS
1032: SELECT wdat.device_id
1033: , wdat.assignment_temp_id
1034: , wdb.subinventory_code
1035: FROM wms_device_assignment_temp wdat, wms_devices_b wdb
1036: WHERE wdat.assignment_temp_id >= p_current_device_temp_id
1037: AND wdat.employee_id = p_emp_id
1038: AND wdat.device_id = wdb.device_id
1039: ORDER BY wdat.assignment_temp_id;

Line 1045: FROM wms_device_assignment_temp wdat, wms_devices_b wdb

1041: CURSOR front_device_list(p_emp_id NUMBER, p_current_device_temp_id NUMBER) IS
1042: SELECT wdat.device_id
1043: , wdat.assignment_temp_id
1044: , wdb.subinventory_code
1045: FROM wms_device_assignment_temp wdat, wms_devices_b wdb
1046: WHERE wdat.assignment_temp_id < p_current_device_temp_id
1047: AND wdat.employee_id = p_emp_id
1048: AND wdat.device_id = wdb.device_id
1049: ORDER BY wdat.assignment_temp_id;

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;