HWM_TM_STATUS_DEFINITIONS_VL

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name
TM_STATUS_DEF_ID TM_STATUS_TYPE DEFINITIONCODE TM_STATUS_NAME DESCRIPTION SCOPE REPOSITORY_TYPE ALLOWABLE_VALUES VALUE_IF_TRUE VALUE_IF_FALSE VALUE_DERIVED_FLAG TRUE_VALUE FALSE_VALUE TCSMRS_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER ENTERPRISE_ID MODULE_ID STATUS_DEF_CD VISIBILITY

Query

SQL_Statement

SELECT STATUS_DEFINITIONS.TM_STATUS_DEF_ID, STATUS_DEFINITIONS.TM_STATUS_TYPE, STATUS_DEFINITIONS.DEFINITIONCODE, STATUS_DEFINITIONS_TL.TM_STATUS_NAME, STATUS_DEFINITIONS_TL.DESCRIPTION, STATUS_DEFINITIONS.SCOPE, STATUS_DEFINITIONS.REPOSITORY_TYPE, STATUS_DEFINITIONS.ALLOWABLE_VALUES, STATUS_DEFINITIONS.VALUE_IF_TRUE, STATUS_DEFINITIONS.VALUE_IF_FALSE, STATUS_DEFINITIONS.VALUE_DERIVED_FLAG, STATUS_DEFINITIONS.TRUE_VALUE, STATUS_DEFINITIONS.FALSE_VALUE, STATUS_DEFINITIONS.TCSMRS_ID, STATUS_DEFINITIONS.CREATED_BY, STATUS_DEFINITIONS.CREATION_DATE, STATUS_DEFINITIONS.LAST_UPDATED_BY, STATUS_DEFINITIONS.LAST_UPDATE_DATE, STATUS_DEFINITIONS.LAST_UPDATE_LOGIN, STATUS_DEFINITIONS.OBJECT_VERSION_NUMBER, STATUS_DEFINITIONS.ENTERPRISE_ID, STATUS_DEFINITIONS.MODULE_ID, STATUS_DEFINITIONS.STATUS_DEF_CD, STATUS_DEFINITIONS.VISIBILITY FROM HWM_TM_STATUS_DEF_B STATUS_DEFINITIONS, HWM_TM_STATUS_DEF_TL STATUS_DEFINITIONS_TL WHERE STATUS_DEFINITIONS.TM_STATUS_DEF_ID = STATUS_DEFINITIONS_TL.TM_STATUS_DEF_ID AND STATUS_DEFINITIONS_TL.LANGUAGE = USERENV('LANG')