DBA Data[Home] [Help]

APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on WMS_DEVICES_B

Line 9925: l_force_sign_on wms_devices_b.force_sign_on_flag%TYPE;

9921: p_device_id OUT NOCOPY NUMBER
9922: )
9923: RETURN VARCHAR2
9924: IS
9925: l_force_sign_on wms_devices_b.force_sign_on_flag%TYPE;
9926: BEGIN
9927: SELECT wms_task_dispatch_device.get_eligible_device
9928: (mmtt.organization_id,
9929: mmtt.subinventory_code,

Line 9938: FROM wms_devices_b

9934: WHERE mmtt.transaction_temp_id = p_transaction_temp_id;
9935:
9936: SELECT force_sign_on_flag
9937: INTO l_force_sign_on
9938: FROM wms_devices_b
9939: WHERE device_id = p_device_id;
9940:
9941: DEBUG ('l_force_sign_on : ' || l_force_sign_on, ' FOrce Sign On :');
9942: RETURN l_force_sign_on;