Product: | WMS - Warehouse Management |
---|---|
Description: | WMS strategy member view |
Implementation/DBA Data: | APPS.WMS_STRATEGY_MEMBERS_V |
SELECT WSM.ROWID
, WSM.STRATEGY_ID
, WSVL.NAME
, WSVL.DESCRIPTION
, WSVL.ORGANIZATION_ID
, WSVL.USER_DEFINED_FLAG
, WSVL.TYPE_CODE
, MLS.MEANING
, MLS.DESCRIPTION
, WSM.SEQUENCE_NUMBER
, WSM.RULE_ID
, WRVL.NAME
, WRVL.DESCRIPTION
, WRVL.ORGANIZATION_ID
, WRVL.USER_DEFINED_FLAG
, WRVL.TYPE_CODE
, MLR.MEANING
, MLR.DESCRIPTION
, WSM.PARTIAL_SUCCESS_ALLOWED_FLAG
, WSM.EFFECTIVE_FROM
, WSM.EFFECTIVE_TO
, WSM.CREATED_BY
, WSM.CREATION_DATE
, WSM.LAST_UPDATED_BY
, WSM.LAST_UPDATE_DATE
, WSM.LAST_UPDATE_LOGIN
, WSM.ATTRIBUTE1
, WSM.ATTRIBUTE2
, WSM.ATTRIBUTE3
, WSM.ATTRIBUTE4
, WSM.ATTRIBUTE5
, WSM.ATTRIBUTE6
, WSM.ATTRIBUTE7
, WSM.ATTRIBUTE8
, WSM.ATTRIBUTE9
, WSM.ATTRIBUTE10
, WSM.ATTRIBUTE11
, WSM.ATTRIBUTE12
, WSM.ATTRIBUTE13
, WSM.ATTRIBUTE14
, WSM.ATTRIBUTE15
, WSM.ATTRIBUTE_CATEGORY
, WSM.DATE_TYPE_CODE
, WSM.DATE_TYPE_LOOKUP_TYPE
, WSM.DATE_TYPE_FROM
, WSM.DATE_TYPE_TO
FROM MFG_LOOKUPS MLR
, MFG_LOOKUPS MLS
, WMS_RULES_VL WRVL
, WMS_STRATEGIES_VL WSVL
, WMS_STRATEGY_MEMBERS WSM
WHERE WSVL.STRATEGY_ID = WSM.STRATEGY_ID
AND WRVL.RULE_ID = WSM.RULE_ID
AND MLS.LOOKUP_TYPE = 'WMS_ACTION_TYPE'
AND MLS.LOOKUP_CODE = WSVL.TYPE_CODE
AND MLR.LOOKUP_TYPE = 'WMS_ACTION_TYPE'
AND MLR.LOOKUP_CODE = WRVL.TYPE_CODE