VIEW: APPS.WMS_STRATEGY_MEMBERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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