Product: | WMS - Warehouse Management |
---|---|
Description: | WMS strategy view |
Implementation/DBA Data: | APPS.WMS_STRATEGIES_V |
SELECT WSVL.ROW_ID
, WSVL.STRATEGY_ID
, WSVL.ORGANIZATION_ID
, WSVL.TYPE_CODE
, ML.MEANING
, ML.DESCRIPTION
, WSVL.NAME
, WSVL.DESCRIPTION
, WSVL.ENABLED_FLAG
, WSVL.USER_DEFINED_FLAG
, WSVL.CREATED_BY
, WSVL.CREATION_DATE
, WSVL.LAST_UPDATED_BY
, WSVL.LAST_UPDATE_DATE
, WSVL.LAST_UPDATE_LOGIN
, WSVL.ATTRIBUTE1
, WSVL.ATTRIBUTE2
, WSVL.ATTRIBUTE3
, WSVL.ATTRIBUTE4
, WSVL.ATTRIBUTE5
, WSVL.ATTRIBUTE6
, WSVL.ATTRIBUTE7
, WSVL.ATTRIBUTE8
, WSVL.ATTRIBUTE9
, WSVL.ATTRIBUTE10
, WSVL.ATTRIBUTE11
, WSVL.ATTRIBUTE12
, WSVL.ATTRIBUTE13
, WSVL.ATTRIBUTE14
, WSVL.ATTRIBUTE15
, WSVL.ATTRIBUTE_CATEGORY
, WSVL.OVER_ALLOCATION_MODE
, WSVL.TOLERANCE_VALUE
FROM MFG_LOOKUPS ML
, WMS_STRATEGIES_VL WSVL
WHERE ML.LOOKUP_TYPE = 'WMS_ACTION_TYPE'
AND ML.LOOKUP_CODE = WSVL.TYPE_CODE
AND NVL(WSVL.WMS_ENABLED_FLAG
, 'Y') = 'Y'