VIEW: APPS.WMS_STRATEGIES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'