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') |