Product: | WMS - Warehouse Management |
---|---|
Description: | WMS strategy MLS view |
Implementation/DBA Data: | APPS.WMS_STRATEGIES_VL |
SELECT WSB.STRATEGY_ID
, WSB.LAST_UPDATED_BY
, WSB.LAST_UPDATE_DATE
, WSB.CREATED_BY
, WSB.CREATION_DATE
, WSB.LAST_UPDATE_LOGIN
, WSB.ORGANIZATION_ID
, WSB.TYPE_CODE
, WSTL.NAME
, WSTL.DESCRIPTION
, WSB.ENABLED_FLAG
, WSB.USER_DEFINED_FLAG
, WSB.ATTRIBUTE_CATEGORY
, WSB.ATTRIBUTE1
, WSB.ATTRIBUTE2
, WSB.ATTRIBUTE3
, WSB.ATTRIBUTE4
, WSB.ATTRIBUTE5
, WSB.ATTRIBUTE6
, WSB.ATTRIBUTE7
, WSB.ATTRIBUTE8
, WSB.ATTRIBUTE9
, WSB.ATTRIBUTE10
, WSB.ATTRIBUTE11
, WSB.ATTRIBUTE12
, WSB.ATTRIBUTE13
, WSB.ATTRIBUTE14
, WSB.ATTRIBUTE15
, WSB.ROWID ROW_ID
, WSB.WMS_ENABLED_FLAG
, WSB.OVER_ALLOCATION_MODE
, WSB.TOLERANCE_VALUE
FROM WMS_STRATEGIES_TL WSTL
, WMS_STRATEGIES_B WSB
WHERE WSTL.STRATEGY_ID = WSB.STRATEGY_ID
AND WSTL.LANGUAGE = USERENV('LANG')