EGO_AWC_ROLE_CONFIG_VL

Details

• Schema: FUSION

• Object owner: EGO

• Object type: VIEW

Columns

Name
AWC_ROLE_CONFIG_ID CHANGE_LIFECYCLE_STATUS_ID OBJECT_VERSION_NUMBER COLUMN_SEQUENCE ROLE_CODE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN DESCRIPTION DISPLAY_LABEL ROLE_NAME

Query

SQL_Statement

SELECT EGO_AWC_ROLE_CONFIG_B.AWC_ROLE_CONFIG_ID AWC_ROLE_CONFIG_ID, EGO_AWC_ROLE_CONFIG_B.CHANGE_LIFECYCLE_STATUS_ID CHANGE_LIFECYCLE_STATUS_ID, EGO_AWC_ROLE_CONFIG_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, EGO_AWC_ROLE_CONFIG_B.COLUMN_SEQUENCE COLUMN_SEQUENCE, EGO_AWC_ROLE_CONFIG_B.ROLE_CODE ROLE_CODE, EGO_AWC_ROLE_CONFIG_B.CREATED_BY CREATED_BY, EGO_AWC_ROLE_CONFIG_B.CREATION_DATE CREATION_DATE, EGO_AWC_ROLE_CONFIG_B.LAST_UPDATED_BY LAST_UPDATED_BY, EGO_AWC_ROLE_CONFIG_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, EGO_AWC_ROLE_CONFIG_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, EGO_AWC_ROLE_CONFIG_TL.DESCRIPTION DESCRIPTION, EGO_AWC_ROLE_CONFIG_TL.DISPLAY_LABEL DISPLAY_LABEL, EGO_AWC_ROLE_CONFIG_TL.ROLE_NAME ROLE_NAME FROM EGO_AWC_ROLE_CONFIG_B, EGO_AWC_ROLE_CONFIG_TL WHERE EGO_AWC_ROLE_CONFIG_B.AWC_ROLE_CONFIG_ID = EGO_AWC_ROLE_CONFIG_TL.AWC_ROLE_CONFIG_ID AND EGO_AWC_ROLE_CONFIG_TL.LANGUAGE = USERENV('LANG')