SVC_WO_STATUSES_VL

Details

• Schema: FUSION

• Object owner: SVC

• Object type: VIEW

Columns

Name
WO_STATUS_ID WO_STATUS_NUMBER WO_INTEGRATION_CD WO_STATUS_CAT_CD WO_STATUS_CD ENABLED_FLAG DISPLAY_SEQUENCE USE_CANCEL_PROCESS_FLAG STATUS_NAME DESCRIPTION RULE_DESCRIPTION CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT b.WO_STATUS_ID WO_STATUS_ID, b.WO_STATUS_NUMBER WO_STATUS_NUMBER, b.WO_INTEGRATION_CD WO_INTEGRATION_CD, b.WO_STATUS_CAT_CD WO_STATUS_CAT_CD, b.WO_STATUS_CD WO_STATUS_CD, b.ENABLED_FLAG ENABLED_FLAG, b.DISPLAY_SEQUENCE DISPLAY_SEQUENCE, b.USE_CANCEL_PROCESS_FLAG USE_CANCEL_PROCESS_FLAG, tl.STATUS_NAME STATUS_NAME, tl.DESCRIPTION DESCRIPTION, tl.RULE_DESCRIPTION RULE_DESCRIPTION, b.CREATION_DATE CREATION_DATE, b.CREATED_BY CREATED_BY, b.LAST_UPDATE_DATE LAST_UPDATE_DATE, b.LAST_UPDATED_BY LAST_UPDATED_BY, b.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, b.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM svc_wo_statuses_b b, svc_wo_statuses_tl tl WHERE b.WO_STATUS_ID= tl.WO_STATUS_ID AND tl.LANGUAGE = USERENV('LANG')