DBA Data[Home] [Help]

APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on WMS_DEVICES_B

Line 10930: l_force_sign_on wms_devices_b.force_sign_on_flag%TYPE;

10926: p_device_id OUT NOCOPY NUMBER
10927: )
10928: RETURN VARCHAR2
10929: IS
10930: l_force_sign_on wms_devices_b.force_sign_on_flag%TYPE;
10931: BEGIN
10932: SELECT wms_task_dispatch_device.get_eligible_device
10933: (mmtt.organization_id,
10934: mmtt.subinventory_code,

Line 10943: FROM wms_devices_b

10939: WHERE mmtt.transaction_temp_id = p_transaction_temp_id;
10940:
10941: SELECT force_sign_on_flag
10942: INTO l_force_sign_on
10943: FROM wms_devices_b
10944: WHERE device_id = p_device_id;
10945:
10946: DEBUG ('l_force_sign_on : ' || l_force_sign_on, ' FOrce Sign On :');
10947: RETURN l_force_sign_on;