APPS.WMS_PICKING_PKG dependencies on WMS_DEVICES_B

Line 2808: FROM wms_device_assignment_temp wdat, wms_devices_b wdb

2804: CURSOR following_device_list(p_emp_id NUMBER, p_current_device_temp_id NUMBER) IS
2805: SELECT wdat.device_id,
2806: wdat.assignment_temp_id,
2807: wdb.subinventory_code
2808: FROM wms_device_assignment_temp wdat, wms_devices_b wdb
2809: WHERE wdat.assignment_temp_id >= p_current_device_temp_id
2810: AND wdat.employee_id = p_emp_id
2811: AND wdb.device_type_id <> 100
2812: AND wdat.device_id = wdb.device_id

Line 2819: FROM wms_device_assignment_temp wdat, wms_devices_b wdb

2815: CURSOR preceding_device_list(p_emp_id NUMBER, p_current_device_temp_id NUMBER) IS
2816: SELECT wdat.device_id,
2817: wdat.assignment_temp_id,
2818: wdb.subinventory_code
2819: FROM wms_device_assignment_temp wdat, wms_devices_b wdb
2820: WHERE wdat.assignment_temp_id < p_current_device_temp_id
2821: AND wdat.employee_id = p_emp_id
2822: AND wdb.device_type_id <> 100
2823: AND wdat.device_id = wdb.device_id

Line 3261: FROM wms_device_assignment_temp wdat, wms_devices_b wd

3257: IF l_device_id IS NOT NULL THEN
3258: -- Get the subinventory and the assignment temp ID
3259: SELECT wdat.assignment_temp_id, wd.subinventory_code
3260: INTO l_assignment_temp_id, l_subinventory_code
3261: FROM wms_device_assignment_temp wdat, wms_devices_b wd
3262: WHERE wdat.device_id = l_device_id
3263: AND wdat.device_id = wd.device_id
3264: AND wdat.employee_id = p_employee_id;
3265: