View: WMS_RESTRICTIONS_V

Product:	WMS - Warehouse Management
Description:	WMS restriction view
Implementation/DBA Data:	APPS.WMS_RESTRICTIONS_V

View Text

SELECT WR.ROWID
, WR.RULE_ID
, WRVL.NAME
, WRVL.DESCRIPTION
, WRVL.ORGANIZATION_ID
, WRVL.USER_DEFINED_FLAG
, WRVL.TYPE_CODE
, MLR.MEANING
, MLR.DESCRIPTION
, WR.SEQUENCE_NUMBER
, WR.PARAMETER_ID
, WMS_PARAMETER_PVT.GETFLEXNAME( WPVL.NAME
, WPVL.DB_OBJECT_REF_TYPE_CODE
, WPVL.PARAMETER_TYPE_CODE
, WPVL.FLEXFIELD_USAGE_CODE
, WPVL.FLEXFIELD_APPLICATION_ID
, WPVL.FLEXFIELD_NAME
, WPVL.COLUMN_NAME )
, WPVL.DESCRIPTION
, WOVL.OBJECT_ID
, WOVL.NAME
, WOVL.DESCRIPTION
, WMS_PARAMETER_PVT.GETFLEXDATATYPECODE( WPVL.DATA_TYPE_CODE
, WPVL.DB_OBJECT_REF_TYPE_CODE
, WPVL.PARAMETER_TYPE_CODE
, WPVL.FLEXFIELD_USAGE_CODE
, WPVL.FLEXFIELD_APPLICATION_ID
, WPVL.FLEXFIELD_NAME
, WPVL.COLUMN_NAME )
, WR.OPERATOR_CODE
, MLX1.MEANING
, MLX1.DESCRIPTION
, WR.OPERAND_TYPE_CODE
, MLX2.MEANING
, MLX2.DESCRIPTION
, WR.OPERAND_CONSTANT_NUMBER
, WR.OPERAND_CONSTANT_CHARACTER
, WR.OPERAND_CONSTANT_DATE
, WR.OPERAND_PARAMETER_ID
, WR.OPERAND_EXPRESSION
, WR.OPERAND_FLEX_VALUE_SET_ID
, DECODE(WR.OPERAND_TYPE_CODE
, 1
, FND_NUMBER.NUMBER_TO_CANONICAL(WR.OPERAND_CONSTANT_NUMBER)
, 2
, WR.OPERAND_CONSTANT_CHARACTER
, 3
, FND_DATE.DATE_TO_CANONICAL(WR.OPERAND_CONSTANT_DATE)
, 4
, WMS_PARAMETER_PVT.GETFLEXNAME( WPVR.NAME
, WPVR.DB_OBJECT_REF_TYPE_CODE
, WPVR.PARAMETER_TYPE_CODE
, WPVR.FLEXFIELD_USAGE_CODE
, WPVR.FLEXFIELD_APPLICATION_ID
, WPVR.FLEXFIELD_NAME
, WPVR.COLUMN_NAME )
, 5
, WR.OPERAND_EXPRESSION
, 6
, FFVS.FLEX_VALUE_SET_NAME)
, DECODE(WR.OPERAND_TYPE_CODE
, 4
, WPVR.DESCRIPTION
, 6
, FFVS.DESCRIPTION
, NULL)
, WOVR.OBJECT_ID
, DECODE(WR.OPERAND_TYPE_CODE
, 4
, WOVR.NAME
, 7
, NULL
, MLX2.MEANING)
, DECODE(WR.OPERAND_TYPE_CODE
, 4
, WOVR.DESCRIPTION
, 7
, NULL
, MLX2.DESCRIPTION)
, DECODE(WR.OPERAND_TYPE_CODE
, 1
, WR.OPERAND_TYPE_CODE
, 2
, WR.OPERAND_TYPE_CODE
, 3
, WR.OPERAND_TYPE_CODE
, 4
, WMS_PARAMETER_PVT.GETFLEXDATATYPECODE( WPVR.DATA_TYPE_CODE
, WPVR.DB_OBJECT_REF_TYPE_CODE
, WPVR.PARAMETER_TYPE_CODE
, WPVR.FLEXFIELD_USAGE_CODE
, WPVR.FLEXFIELD_APPLICATION_ID
, WPVR.FLEXFIELD_NAME
, WPVR.COLUMN_NAME )
, 5
, WMS_PARAMETER_PVT.GETFLEXDATATYPECODE( WPVL.DATA_TYPE_CODE
, WPVL.DB_OBJECT_REF_TYPE_CODE
, WPVL.PARAMETER_TYPE_CODE
, WPVL.FLEXFIELD_USAGE_CODE
, WPVL.FLEXFIELD_APPLICATION_ID
, WPVL.FLEXFIELD_NAME
, WPVL.COLUMN_NAME )
, 6
, DECODE(FFVS.FORMAT_TYPE
, 'N'
, 1
, 'C'
, 2
, 3)
, 7
, NULL)
, WR.LOGICAL_OPERATOR_CODE
, DECODE(WR.LOGICAL_OPERATOR_CODE
, 3
, NULL
, MLX3.MEANING)
, WR.BRACKET_OPEN
, WR.BRACKET_CLOSE
, WR.CREATED_BY
, WR.CREATION_DATE
, WR.LAST_UPDATED_BY
, WR.LAST_UPDATE_DATE
, WR.LAST_UPDATE_LOGIN
, WR.ATTRIBUTE1
, WR.ATTRIBUTE2
, WR.ATTRIBUTE3
, WR.ATTRIBUTE4
, WR.ATTRIBUTE5
, WR.ATTRIBUTE6
, WR.ATTRIBUTE7
, WR.ATTRIBUTE8
, WR.ATTRIBUTE9
, WR.ATTRIBUTE10
, WR.ATTRIBUTE11
, WR.ATTRIBUTE12
, WR.ATTRIBUTE13
, WR.ATTRIBUTE14
, WR.ATTRIBUTE15
, WR.ATTRIBUTE_CATEGORY
FROM FND_FLEX_VALUE_SETS FFVS
, WMS_OBJECTS_VL WOVR
, WMS_PARAMETERS_VL WPVR
, WMS_OBJECTS_VL WOVL
, WMS_PARAMETERS_VL WPVL
, MFG_LOOKUPS MLR
, WMS_RULES_VL WRVL
, MFG_LOOKUPS MLX3
, MFG_LOOKUPS MLX2
, MFG_LOOKUPS MLX1
, WMS_RESTRICTIONS WR
WHERE MLX1.LOOKUP_TYPE = 'WMS_OPERATOR'
AND MLX1.LOOKUP_CODE = WR.OPERATOR_CODE
AND MLX2.LOOKUP_TYPE = 'WMS_OPERAND_TYPE'
AND MLX2.LOOKUP_CODE = WR.OPERAND_TYPE_CODE
AND MLX3.LOOKUP_TYPE (+) = 'WMS_LOGICAL_OPERATOR'
AND MLX3.LOOKUP_CODE (+) = WR.LOGICAL_OPERATOR_CODE
AND WRVL.RULE_ID = WR.RULE_ID
AND MLR.LOOKUP_TYPE = 'WMS_ACTION_TYPE'
AND MLR.LOOKUP_CODE = WRVL.TYPE_CODE
AND WPVL.PARAMETER_ID = WR.PARAMETER_ID
AND WOVL.OBJECT_ID = WPVL.OBJECT_ID
AND WPVR.PARAMETER_ID (+) = WR.OPERAND_PARAMETER_ID
AND WOVR.OBJECT_ID (+) = WPVR.OBJECT_ID
AND FFVS.FLEX_VALUE_SET_ID (+) = WR.OPERAND_FLEX_VALUE_SET_ID

Columns