DBA Data[Home] [Help]

APPS.WMS_RFID_DEVICE_PUB dependencies on WMS_BUS_EVENT_DEVICES

Line 495: SELECT business_event_id,verification_required INTO x_out_business_event_id,x_verif_req FROM wms_bus_event_devices

491: IF (p_lpn_context = wms_container_pub.lpn_context_picked OR
492: p_lpn_context = wms_container_pub.lpn_context_inv) THEN
493:
494: BEGIN
495: SELECT business_event_id,verification_required INTO x_out_business_event_id,x_verif_req FROM wms_bus_event_devices
496: WHERE device_id = p_device_id
497: AND ENABLED_FLAG = 'Y'
498: AND organization_id = p_organization_id
499: AND (business_event_id = wms_device_integration_pvt.wms_be_truck_load

Line 517: SELECT business_event_id,verification_required INTO x_out_business_event_id,X_VERIF_REQ FROM wms_bus_event_devices

513:
514: ELSIF (p_lpn_context = wms_container_pub.lpn_context_intransit OR p_lpn_context = wms_container_pub.lpn_context_vendor) THEN
515:
516: BEGIN
517: SELECT business_event_id,verification_required INTO x_out_business_event_id,X_VERIF_REQ FROM wms_bus_event_devices
518: WHERE device_id = p_device_id
519: AND ENABLED_FLAG = 'Y'
520: AND organization_id = p_organization_id
521: AND business_event_id IN