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 |