WIE_MA_RULE_ATTRIBUTES_VL

Details

  • Schema: FUSION

  • Object owner: WIE

  • Object type: VIEW

Columns

Name

MA_RULE_ATTRIBUTE_ID

RULE_ATTRIBUTE_CODE

RULE_ATTRIBUTE_MEANING

RULE_ATTRIBUTE_DESCRIPTION

RULE_ATTRIBUTE_GROUP

ASSIGNMENT_SEQ_FLAG

FORCE_ASSIGN_FLAG

EXCLUDE_MATERIAL_FLAG

SORT_ALLOWED_FLAG

VALUE_ALLOWED_FLAG

OBJECT_VERSION_NUMBER

DISPLAY_SEQUENCE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

B.MA_RULE_ATTRIBUTE_ID,

B.RULE_ATTRIBUTE_CODE,

T.RULE_ATTRIBUTE_MEANING,

T.RULE_ATTRIBUTE_DESCRIPTION,

B.RULE_ATTRIBUTE_GROUP,

B.ASSIGNMENT_SEQ_FLAG,

B.FORCE_ASSIGN_FLAG,

B.EXCLUDE_MATERIAL_FLAG,

B.SORT_ALLOWED_FLAG,

B.VALUE_ALLOWED_FLAG,

B.OBJECT_VERSION_NUMBER,

B.DISPLAY_SEQUENCE,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN

FROM

WIE_MA_RULE_ATTRIBUTES_B B,

WIE_MA_RULE_ATTRIBUTES_TL T

WHERE

B.MA_RULE_ATTRIBUTE_ID = T.MA_RULE_ATTRIBUTE_ID AND T.LANGUAGE = USERENV('LANG')