APPS.WMS_TASK_DISPATCH_GEN dependencies on WMS_DEVICES_B

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 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;