EGO_CHANGE_STATUSES_VL

Details

• Schema: FUSION

• Object owner: EGO

• Object type: VIEW

Columns

Name
STATUS_CODE OBJECT_VERSION_NUMBER STATUS_TYPE OBJECT_NAME STATUS_INTERNAL_NAME STATUS_NAME DESCRIPTION SORT_SEQUENCE_NUM DISABLE_DATE APPLICATION_ID SEEDED_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN LAST_UPDATE_DATE

Query

SQL_Statement

SELECT EGO_CHANGE_STATUSES_B.STATUS_CODE STATUS_CODE, EGO_CHANGE_STATUSES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, EGO_CHANGE_STATUSES_B.STATUS_TYPE STATUS_TYPE, EGO_CHANGE_STATUSES_B.OBJECT_NAME OBJECT_NAME, EGO_CHANGE_STATUSES_B.STATUS_INTERNAL_NAME STATUS_INTERNAL_NAME, EGO_CHANGE_STATUSES_TL.STATUS_NAME STATUS_NAME, EGO_CHANGE_STATUSES_TL.DESCRIPTION DESCRIPTION, EGO_CHANGE_STATUSES_B.SORT_SEQUENCE_NUM SORT_SEQUENCE_NUM, EGO_CHANGE_STATUSES_B.DISABLE_DATE DISABLE_DATE, EGO_CHANGE_STATUSES_B.APPLICATION_ID APPLICATION_ID, EGO_CHANGE_STATUSES_B.SEEDED_FLAG SEEDED_FLAG, EGO_CHANGE_STATUSES_B.CREATED_BY CREATED_BY, EGO_CHANGE_STATUSES_B.CREATION_DATE CREATION_DATE, EGO_CHANGE_STATUSES_B.LAST_UPDATED_BY LAST_UPDATED_BY, EGO_CHANGE_STATUSES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, EGO_CHANGE_STATUSES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM EGO_CHANGE_STATUSES_B, EGO_CHANGE_STATUSES_TL WHERE EGO_CHANGE_STATUSES_B.STATUS_CODE = EGO_CHANGE_STATUSES_TL.STATUS_CODE AND EGO_CHANGE_STATUSES_TL.LANGUAGE = USERENV('LANG')