VIEW: APPS.WMS_DEVICES_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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