Product: | WMS - Warehouse Management |
---|---|
Description: | This view represents the MLS database entity WMS_DEVICES. |
Implementation/DBA Data: | APPS.WMS_DEVICES_VL |
SELECT B.ROWID ROW_ID
, B.DEVICE_ID
, T.NAME
, T.DESCRIPTION
, B.DEVICE_TYPE_ID
, ML1.MEANING DEVICE_TYPE
, B.ENABLED_FLAG
, B.LOT_SERIAL_CAPABLE
, B.INPUT_METHOD_ID
, ML2.MEANING INPUT_METHOD
, B.OUTPUT_METHOD_ID
, ML3.MEANING OUTPUT_METHOD
, B.SUBINVENTORY_CODE
, B.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, B.BATCH_LIMIT
, B.OUT_DIRECTORY
, B.OUT_FILE_PREFIX
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.DEVICE_MODEL
, B.NOTIFICATION_FLAG
, B.LOCATOR_ID
, B.FORCE_SIGN_ON_FLAG
, B.MULTI_SIGN_ON
, B.MESSAGE_TEMPLATE_ID
, WMT.TEMPLATE_NAME
FROM WMS_DEVICES_TL T
, MTL_PARAMETERS MP
, WMS_DEVICES_B B
, MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, WMS_MSG_TEMPLATES WMT
WHERE B.DEVICE_ID = T.DEVICE_ID
AND T.LANGUAGE = USERENV('LANG')
AND ML1.LOOKUP_TYPE = 'WMS_DEVICE_TYPES'
AND ML1.LOOKUP_CODE = B.DEVICE_TYPE_ID
AND ML2.LOOKUP_TYPE(+) = 'WMS_DEVICE_IO_TYPES'
AND ML2.LOOKUP_CODE(+) = B.INPUT_METHOD_ID
AND ML3.LOOKUP_TYPE(+) = 'WMS_DEVICE_IO_TYPES'
AND ML3.LOOKUP_CODE(+) = B.OUTPUT_METHOD_ID
AND MP.ORGANIZATION_ID(+) = B.ORGANIZATION_ID
AND WMT.TEMPLATE_ID(+) = B.MESSAGE_TEMPLATE_ID