View: WMS_STRATEGY_ASSIGNMENTS_V

Product:	WMS - Warehouse Management
Description:	WMS strategy assignment view
Implementation/DBA Data:	APPS.WMS_STRATEGY_ASSIGNMENTS_V

View Text

SELECT WSA.ROWID
, WSA.ORGANIZATION_ID
, WSA.OBJECT_TYPE_CODE
, MLO.MEANING
, MLO.DESCRIPTION
, DECODE(WSA.OBJECT_TYPE_CODE
, 1
, WOVL.NAME
, WSA.OBJECT_NAME)
, DECODE(WSA.OBJECT_TYPE_CODE
, 1
, WOVL.DESCRIPTION
, TO_CHAR(NULL))
, WSA.OBJECT_ID
, WSA.PK1_VALUE
, WSA.PK2_VALUE
, WSA.PK3_VALUE
, WSA.PK4_VALUE
, WSA.PK5_VALUE
, WMS_ASSIGNMENT_PVT.GETOBJECTVALUENAME ( WSA.OBJECT_TYPE_CODE
, WSA.OBJECT_ID
, WSA.PK1_VALUE
, WSA.PK2_VALUE
, WSA.PK3_VALUE
, WSA.PK4_VALUE
, WSA.PK5_VALUE )
, WSA.STRATEGY_ID
, WSA.STRATEGY_TYPE_CODE
, MLS.MEANING
, MLS.DESCRIPTION
, WSVL.NAME
, WSVL.DESCRIPTION
, WSA.EFFECTIVE_FROM
, WSA.EFFECTIVE_TO
, WSA.CREATED_BY
, WSA.CREATION_DATE
, WSA.LAST_UPDATED_BY
, WSA.LAST_UPDATE_DATE
, WSA.LAST_UPDATE_LOGIN
, WSA.ATTRIBUTE1
, WSA.ATTRIBUTE2
, WSA.ATTRIBUTE3
, WSA.ATTRIBUTE4
, WSA.ATTRIBUTE5
, WSA.ATTRIBUTE6
, WSA.ATTRIBUTE7
, WSA.ATTRIBUTE8
, WSA.ATTRIBUTE9
, WSA.ATTRIBUTE10
, WSA.ATTRIBUTE11
, WSA.ATTRIBUTE12
, WSA.ATTRIBUTE13
, WSA.ATTRIBUTE14
, WSA.ATTRIBUTE15
, WSA.ATTRIBUTE_CATEGORY
, WSA.DATE_TYPE_CODE
, WSA.DATE_TYPE_LOOKUP_TYPE
, WSA.DATE_TYPE_FROM
, WSA.DATE_TYPE_TO
, WSA.SEQUENCE_NUMBER
FROM WMS_STRATEGIES_VL WSVL
, WMS_OBJECTS_VL WOVL
, MFG_LOOKUPS MLS
, MFG_LOOKUPS MLO
, WMS_STRATEGY_ASSIGNMENTS WSA
WHERE MLO.LOOKUP_TYPE = 'WMS_OBJECT_TYPE'
AND MLO.LOOKUP_CODE = WSA.OBJECT_TYPE_CODE
AND MLS.LOOKUP_TYPE = 'WMS_ACTION_TYPE'
AND MLS.LOOKUP_CODE = WSA.STRATEGY_TYPE_CODE
AND WOVL.OBJECT_ID = WSA.OBJECT_ID
AND WSVL.STRATEGY_ID = WSA.STRATEGY_ID

Columns