APPS.WMS_PICKING_PKG dependencies on WMS_DEVICES_B

Line 2440: FROM wms_device_assignment_temp wdat, wms_devices_b wdb

2436: CURSOR following_device_list(p_emp_id NUMBER, p_current_device_temp_id NUMBER) IS
2437: SELECT wdat.device_id,
2438: wdat.assignment_temp_id,
2439: wdb.subinventory_code
2440: FROM wms_device_assignment_temp wdat, wms_devices_b wdb
2441: WHERE wdat.assignment_temp_id >= p_current_device_temp_id
2442: AND wdat.employee_id = p_emp_id
2443: AND wdb.device_type_id <> 100
2444: AND wdat.device_id = wdb.device_id

Line 2451: FROM wms_device_assignment_temp wdat, wms_devices_b wdb

2447: CURSOR preceding_device_list(p_emp_id NUMBER, p_current_device_temp_id NUMBER) IS
2448: SELECT wdat.device_id,
2449: wdat.assignment_temp_id,
2450: wdb.subinventory_code
2451: FROM wms_device_assignment_temp wdat, wms_devices_b wdb
2452: WHERE wdat.assignment_temp_id < p_current_device_temp_id
2453: AND wdat.employee_id = p_emp_id
2454: AND wdb.device_type_id <> 100
2455: AND wdat.device_id = wdb.device_id

Line 2888: FROM wms_device_assignment_temp wdat, wms_devices_b wd

2884: IF l_device_id IS NOT NULL THEN
2885: -- Get the subinventory and the assignment temp ID
2886: SELECT wdat.assignment_temp_id, wd.subinventory_code
2887: INTO l_assignment_temp_id, l_subinventory_code
2888: FROM wms_device_assignment_temp wdat, wms_devices_b wd
2889: WHERE wdat.device_id = l_device_id
2890: AND wdat.device_id = wd.device_id
2891: AND wdat.employee_id = p_employee_id;
2892: