1. Tables and Views for SCM
  2. EGO_RL_ENTITIES_VL

EGO_RL_ENTITIES_VL

Details

  • Schema: FUSION

  • Object owner: EGO

  • Object type: VIEW

Columns

Name

INTERNAL_NAME

DATA_LEVEL_NAME

PARENT_ENTITY

DISPLAY_NAME

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

OBJECT_VERSION_NUMBER

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

EGO_RL_ENTITIES_B.INTERNAL_NAME INTERNAL_NAME,

EGO_RL_ENTITIES_B.DATA_LEVEL_NAME DATA_LEVEL_NAME,

EGO_RL_ENTITIES_B.PARENT_ENTITY PARENT_ENTITY,

EGO_RL_ENTITIES_TL.DISPLAY_NAME DISPLAY_NAME,

EGO_RL_ENTITIES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

EGO_RL_ENTITIES_B.LAST_UPDATED_BY LAST_UPDATED_BY,

EGO_RL_ENTITIES_B.CREATION_DATE CREATION_DATE,

EGO_RL_ENTITIES_B.CREATED_BY CREATED_BY,

EGO_RL_ENTITIES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

EGO_RL_ENTITIES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN

FROM

EGO_RL_ENTITIES_B,

EGO_RL_ENTITIES_TL

WHERE

EGO_RL_ENTITIES_B.INTERNAL_NAME = EGO_RL_ENTITIES_TL.INTERNAL_NAME AND EGO_RL_ENTITIES_TL.LANGUAGE = USERENV('LANG')