WIE_WS_REASON_CODES_VL

Details

• Schema: FUSION

• Object owner: WIE

• Object type: VIEW

Columns

Name
WS_REASON_CODE_ID OBJECT_VERSION_NUMBER REASON_CODE REASON_CODE_NAME WORKSTATION_STATUS_CODE LOSS_CATEGORY_CODE SEEDED_FLAG INACTIVE_DATE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT WSRCB.WS_REASON_CODE_ID WS_REASON_CODE_ID, WSRCB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, WSRCB.REASON_CODE REASON_CODE, WSRCBTL.REASON_CODE_NAME REASON_CODE_NAME, WSRCB.WORKSTATION_STATUS_CODE WORKSTATION_STATUS_CODE, WSRCB.LOSS_CATEGORY_CODE LOSS_CATEGORY_CODE, WSRCB.SEEDED_FLAG SEEDED_FLAG, WSRCB.INACTIVE_DATE INACTIVE_DATE, WSRCB.CREATED_BY CREATED_BY, WSRCB.CREATION_DATE CREATION_DATE, WSRCB.LAST_UPDATED_BY LAST_UPDATED_BY, WSRCB.LAST_UPDATE_DATE LAST_UPDATE_DATE, WSRCB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM WIE_WS_REASON_CODES_B WSRCB, WIE_WS_REASON_CODES_TL WSRCBTL WHERE WSRCB.WS_REASON_CODE_ID = WSRCBTL.WS_REASON_CODE_ID AND WSRCBTL.LANGUAGE = USERENV('LANG')