eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WMS_BUS_EVENT_DEVICES_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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