View: WMS_BUS_EVENT_DEVICES_V

Product:	WMS - Warehouse Management
Description:
Implementation/DBA Data:	APPS.WMS_BUS_EVENT_DEVICES_V

View Text

SELECT WBED.ROWID ROW_ID
, WBED.BUSINESS_EVENT_ID
, ML.MEANING BUSINESS_EVENT
, WBED.DEVICE_ID DEVICE_ID
, WDVL.NAME DEVICE_NAME
, WBED.LEVEL_TYPE
, WBED.LEVEL_VALUE
, WBED.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, WBED.SUBINVENTORY_CODE
, WBED.AUTO_ENABLED_FLAG
, WBED.COMMENTS
, WBED.ENABLED_FLAG
, WBED.LAST_UPDATE_DATE
, WBED.LAST_UPDATED_BY
, WBED.CREATION_DATE
, WBED.CREATED_BY
, WBED.LAST_UPDATE_LOGIN
, WBED.ATTRIBUTE_CATEGORY
, WBED.ATTRIBUTE1
, WBED.ATTRIBUTE2
, WBED.ATTRIBUTE3
, WBED.ATTRIBUTE4
, WBED.ATTRIBUTE5
, WBED.ATTRIBUTE6
, WBED.ATTRIBUTE7
, WBED.ATTRIBUTE8
, WBED.ATTRIBUTE9
, WBED.ATTRIBUTE10
, WBED.ATTRIBUTE11
, WBED.ATTRIBUTE12
, WBED.ATTRIBUTE13
, WBED.ATTRIBUTE14
, WBED.ATTRIBUTE15
, WDVL.DEVICE_TYPE_ID
, WBED.VERIFICATION_REQUIRED
FROM WMS_BUS_EVENT_DEVICES WBED
, MFG_LOOKUPS ML
, MTL_PARAMETERS MP
, WMS_DEVICES_VL WDVL
WHERE ML.LOOKUP_TYPE = 'WMS_BUS_EVENT_TYPES'
AND ML.LOOKUP_CODE = WBED.BUSINESS_EVENT_ID
AND MP.ORGANIZATION_ID = WBED.ORGANIZATION_ID
AND WBED.DEVICE_ID = WDVL.DEVICE_ID

Columns