1. Tables and Views for SCM
  2. MSC_ATTRIBUTE_SETS_VL

MSC_ATTRIBUTE_SETS_VL

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

ATTRIBUTE_SET_ID

ATTRIBUTE_ID

ATTRIBUTE_SET_NAME

FUSION_VAL_SET

UNIQUE_IDENTIFIER

ACTIVATION_SEQUENCE

OBJECT_VERSION_NUMBER

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

b.ATTRIBUTE_SET_ID,

b.ATTRIBUTE_ID,

t.ATTRIBUTE_SET_NAME,

b.FUSION_VAL_SET,

b.UNIQUE_IDENTIFIER,

b.ACTIVATION_SEQUENCE,

b.OBJECT_VERSION_NUMBER,

b.LAST_UPDATE_DATE,

b.LAST_UPDATED_BY,

b.CREATION_DATE,

b.CREATED_BY,

b.LAST_UPDATE_LOGIN

FROM

MSC_ATTRIBUTE_SETS_B b,

MSC_ATTRIBUTE_SETS_TL t

WHERE

b.ATTRIBUTE_SET_ID = t.ATTRIBUTE_SET_ID

AND b.ATTRIBUTE_ID = t.ATTRIBUTE_ID AND t.LANGUAGE = USERENV('LANG')