CJM_USER_STATUSES_VL

Details

• Schema: FUSION

• Object owner: CJM

• Object type: VIEW

Columns

Name
USER_STATUS_ID USER_STATUS_CODE USER_STATUS_NAME DESCRIPTION BUY_SIDE_FLAG SELL_SIDE_FLAG ENABLED_FLAG START_DATE_ACTIVE END_DATE_ACTIVE OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN SYSTEM_STATUS_TYPE SYSTEM_STATUS_CODE SEEDED_FLAG DEFAULT_FLAG USER_STATUS_GUID SELL_SIDE_DEFAULT_FLAG

Query

SQL_Statement

SELECT B.USER_STATUS_ID, B.USER_STATUS_CODE, TL.USER_STATUS_NAME, TL.DESCRIPTION, B.BUY_SIDE_FLAG, B.SELL_SIDE_FLAG, B.ENABLED_FLAG, B.START_DATE_ACTIVE, B.END_DATE_ACTIVE, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.SYSTEM_STATUS_TYPE, B.SYSTEM_STATUS_CODE, B.SEEDED_FLAG, B.DEFAULT_FLAG, B.USER_STATUS_GUID, B.SELL_SIDE_DEFAULT_FLAG FROM CJM_USER_STATUSES_B B, CJM_USER_STATUSES_TL TL WHERE B.USER_STATUS_ID = TL.USER_STATUS_ID AND TL.LANGUAGE = USERENV('LANG')