APPS.WMS_WAVE_PLANNING_PVT dependencies on WMS_DEVICES_B

Line 15152: l_force_sign_on wms_devices_b.force_sign_on_flag%TYPE;

15148:
15149: FUNCTION getforcesignonflagvalue(p_transaction_temp_id IN mtl_material_transactions_temp.transaction_temp_id%TYPE,
15150: p_device_id OUT NOCOPY NUMBER)
15151: RETURN VARCHAR2 IS
15152: l_force_sign_on wms_devices_b.force_sign_on_flag%TYPE;
15153: BEGIN
15154: SELECT wms_task_dispatch_device.get_eligible_device(mmtt.organization_id,
15155: mmtt.subinventory_code,
15156: mmtt.locator_id)

Line 15163: FROM wms_devices_b

15159: WHERE mmtt.transaction_temp_id = p_transaction_temp_id;
15160:
15161: SELECT force_sign_on_flag
15162: INTO l_force_sign_on
15163: FROM wms_devices_b
15164: WHERE device_id = p_device_id;
15165:
15166: RETURN l_force_sign_on;
15167: EXCEPTION