APPS.WMS_POSTALLOC_PVT dependencies on WMS_DEVICES_B

Line 5417: , wms_devices_b wd

5413: SELECT device_id
5414: INTO l_ret_dev_id
5415: FROM ( SELECT wbed.device_id
5416: FROM wms_bus_event_devices wbed
5417: , wms_devices_b wd
5418: WHERE wd.device_id = wbed.device_id
5419: AND wbed.organization_id = wd.organization_id
5420: AND wd.ENABLED_FLAG = 'Y'
5421: AND wbed.ENABLED_FLAG = 'Y'

Line 5450: FROM wms_devices_b

5446: IF l_ret_dev_id IS NOT NULL THEN --{
5447: BEGIN
5448: SELECT force_sign_on_flag
5449: INTO l_force_sign_on_flag
5450: FROM wms_devices_b
5451: WHERE device_id = l_ret_dev_id;
5452:
5453: IF l_force_sign_on_flag = 'Y' THEN
5454: BEGIN

Line 5572: , wms_devices_b dev

5568: FROM mtl_material_transactions_temp mmtt
5569: WHERE mmtt.move_order_header_id = p_mo_hdr_id
5570: AND mmtt.parent_line_id IS NULL
5571: ) x
5572: , wms_devices_b dev
5573: WHERE x.dev_id = dev.device_id(+);
5574:
5575: -- Cursor for child task records
5576: CURSOR c_child_tasks (p_mo_hdr_id IN NUMBER) IS

Line 5649: wms_devices_b dev

5645: WHERE mmtt1.move_order_header_id = p_mo_hdr_id
5646: AND mmtt1.parent_line_id IS NOT NULL
5647: )
5648: ) x,
5649: wms_devices_b dev
5650: WHERE x.dev_id = dev.device_id(+);
5651:
5652: BEGIN
5653: x_return_status := fnd_api.g_ret_sts_success;