VIEW: APPS.WMS_RESTRICTIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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