1. Tables and Views for SCM
  2. EGP_ITEM_ATTRIBUTES_VL

EGP_ITEM_ATTRIBUTES_VL

Details

  • Schema: FUSION

  • Object owner: EGP

  • Object type: VIEW

Columns

Name

ATTR_GROUP_NAME

ATTR_GROUP_DISP_NAME

ATTR_NAME

ATTR_DISP_NAME

CONTROL_LEVEL

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

PROGRAM_NAME

PROGRAM_APP_NAME

REQUEST_ID

OBJECT_VERSION_NUMBER

INTERFACE_TABLE_NAME

MAX_DECIMAL_DIGITS

ATTR_DATA_TYPE

ES_INDEX_NAME

ES_OBJECT_NAME

Query

SQL_Statement

SELECT

B.ATTR_GROUP_NAME ATTR_GROUP_NAME,

ATTR_GROUP_DISP_NAME,

B.ATTR_NAME ATTR_NAME,

ATTR_DISP_NAME,

B.CONTROL_LEVEL CONTROL_LEVEL,

B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

B.LAST_UPDATED_BY LAST_UPDATED_BY,

B.CREATION_DATE CREATION_DATE,

B.CREATED_BY CREATED_BY,

B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

PROGRAM_NAME,

PROGRAM_APP_NAME,

REQUEST_ID,

B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

B.INTERFACE_TABLE_NAME INTERFACE_TABLE_NAME ,

B.MAX_DECIMAL_DIGITS MAX_DECIMAL_DIGITS,

B.ATTR_DATA_TYPE ATTR_DATA_TYPE,

B.ES_INDEX_NAME ES_INDEX_NAME,

B.ES_OBJECT_NAME ES_OBJECT_NAME

FROM

EGP_ITEM_ATTRIBUTES_TL TL,

EGP_ITEM_ATTRIBUTES_B B

WHERE

LANGUAGE = USERENV('LANG') AND TL.ATTR_GROUP_NAME = B.ATTR_GROUP_NAME AND TL.ATTR_NAME = B.ATTR_NAME