APPS.WMS_DEVICE_INTEGRATION_PVT dependencies on WMS_DEVICES_B

Line 683: wms_devices_b wd

679: begin
680: seLECT DEVICE_ID INTO dev_ID FROM
681: ( SELECT wbed.DEVICE_ID FROM
682: wms_bus_event_devices wbed,
683: wms_devices_b wd
684: WHERE
685: wd.device_id = wbed.device_id
686: AND WBED.organization_id = WD.organization_id
687: and wd.ENABLED_FLAG = 'Y'

Line 705: FROM wms_devices_b

701: IF (dev_id <> 0 ) THEN
702: BEGIN
703: SELECT force_sign_on_flag
704: INTO l_force_sign_on_flag
705: FROM wms_devices_b
706: WHERE device_id = dev_id;
707: IF(l_force_sign_on_flag='Y') THEN
708: BEGIN
709: SELECT device_id

Line 747: wms_devices_b wd

743: BEGIN
744: SELECT DEVICE_ID INTO dev_ID FROM
745: ( SELECT wbed.DEVICE_ID FROM
746: wms_bus_event_devices wbed,
747: wms_devices_b wd
748: WHERE
749: wd.device_id = wbed.device_id
750: AND WBED.organization_id = WD.organization_id
751: and wd.ENABLED_FLAG = 'Y'

Line 769: FROM wms_devices_b

765: IF (dev_id <> 0 ) THEN
766: BEGIN
767: SELECT force_sign_on_flag
768: INTO l_force_sign_on_flag
769: FROM wms_devices_b
770: WHERE device_id = dev_id;
771: IF(l_force_sign_on_flag='Y') THEN
772: BEGIN
773: SELECT device_id

Line 816: from wms_devices_b

812: IF wdrrec.business_event_id in (wms_be_task_complete) THEN
813: BEGIN
814: select nvl(notification_flag, 'N')
815: into l_notification_flag
816: from wms_devices_b
817: where device_id = dev_id;
818: EXCEPTION
819: WHEN no_data_found THEN
820: IF (l_debug = 1) THEN

Line 846: from WMS_DEVICES_B

842: --allocation bus event
843: IF wdrrec.business_event_id IN (wms_be_pick_release, wms_be_mo_task_alloc,WMS_BE_WIP_PICK_RELEASE) then BEGIN --Added WMS_BE_WIP_PICK_RELEASE for Bug 13702075
844: select Nvl(lot_serial_capable,'N')
845: into l_lot_ser_ok
846: from WMS_DEVICES_B
847: where device_id = dev_id;
848: EXCEPTION
849: WHEN no_data_found THEN
850: l_lot_ser_ok := 'N';

Line 1836: from WMS_DEVICES_B

1832: -- consider this record for further processing
1833: if (l_seldev <> 0) then
1834: select Nvl(lot_serial_capable,'N')
1835: into l_lot_ser_ok
1836: from WMS_DEVICES_B
1837: where device_id = l_seldev;
1838: -- If Details enabled for device, retrieve the Lot/Serialdetails
1839: IF (l_lot_ser_ok = 'Y') THEN
1840: retrieve_Lot_Serial_Details(l_wdr, x_return_status);

Line 1866: from WMS_DEVICES_B

1862: -- update the request records' RELATION_ID with the parent_request_id
1863: IF(p_bus_event in (wms_be_task_complete, wms_be_task_skip, wms_be_task_cancel)) THEN
1864: select nvl(notification_flag, 'N')
1865: into l_notification_flag
1866: from WMS_DEVICES_B
1867: where device_id = l_cur_dev.device_id;
1868:
1869: IF (l_debug = 1) THEN
1870: trace('Event is task complete/skip/cancel, check whether need to update relation_id, notification_flag='||l_notification_flag);

Line 1897: from WMS_DEVICES_B d, mtl_parameters p

1893: END IF;
1894:
1895: select d.OUTPUT_METHOD_ID, p.WCS_ENABLED
1896: into l_deviotype, l_wcs_enabled
1897: from WMS_DEVICES_B d, mtl_parameters p
1898: where d.device_id = l_cur_dev.device_id
1899: and p.organization_id = d.organization_id;
1900:
1901:

Line 2373: from WMS_DEVICES_B

2369: -- consider this record for further processing
2370: if (l_seldev <> 0) then
2371: select Nvl(lot_serial_capable,'N')
2372: into l_lot_ser_ok
2373: from WMS_DEVICES_B
2374: where device_id = l_seldev;
2375: -- If Details enabled for device, retrieve the Lot/Serialdetails
2376: IF (l_lot_ser_ok = 'Y') THEN
2377: retrieve_Lot_Serial_Details(l_wdr, x_return_status);

Line 2403: from WMS_DEVICES_B

2399: -- update the request records' RELATION_ID with the parent_request_id
2400: IF(p_bus_event in (wms_be_task_complete, wms_be_task_skip, wms_be_task_cancel)) THEN
2401: select nvl(notification_flag, 'N')
2402: into l_notification_flag
2403: from WMS_DEVICES_B
2404: where device_id = l_cur_dev.device_id;
2405:
2406: IF (l_debug = 1) THEN
2407: trace('Event is task complete/skip/cancel, check whether need to update relation_id, notification_flag='||l_notification_flag);

Line 2434: from WMS_DEVICES_B d, mtl_parameters p

2430: END IF;
2431:
2432: select d.OUTPUT_METHOD_ID, p.WCS_ENABLED
2433: into l_deviotype, l_wcs_enabled
2434: from WMS_DEVICES_B d, mtl_parameters p
2435: where d.device_id = l_cur_dev.device_id
2436: and p.organization_id = d.organization_id;
2437:
2438:

Line 2790: FROM wms_devices_b

2786: BEGIN
2787: --Check whether any device exist
2788: SELECT 1 INTO l_device_cnt FROM DUAL WHERE exists
2789: (SELECT 1
2790: FROM wms_devices_b
2791: WHERE ORGANIZATION_ID= p_org_id);
2792: EXCEPTION
2793: WHEN NO_DATA_FOUND THEN
2794: l_device_cnt:=0;