HWM_TCSMR_CONFIG_SETS_VL

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name
TCSMR_CONFIG_SET_ID TCSMR_CONFIG_SET_CODE OBJECT_VERSION_NUMBER ENTERPRISE_ID MODULE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN NAME DESCRIPTION WRKFLW_NTFN_ENABLED ABS_APPROVAL_USAGE_CD SGUID WRK_APPROVAL_ENABLED

Query

SQL_Statement

SELECT HWM_TCSMR_CONFIG_SETS_B.TCSMR_CONFIG_SET_ID, HWM_TCSMR_CONFIG_SETS_B.TCSMR_CONFIG_SET_CODE, HWM_TCSMR_CONFIG_SETS_B.OBJECT_VERSION_NUMBER, HWM_TCSMR_CONFIG_SETS_B.ENTERPRISE_ID, HWM_TCSMR_CONFIG_SETS_B.MODULE_ID, HWM_TCSMR_CONFIG_SETS_B.CREATED_BY, HWM_TCSMR_CONFIG_SETS_B.CREATION_DATE, HWM_TCSMR_CONFIG_SETS_B.LAST_UPDATED_BY, HWM_TCSMR_CONFIG_SETS_B.LAST_UPDATE_DATE, HWM_TCSMR_CONFIG_SETS_B.LAST_UPDATE_LOGIN, HWM_TCSMR_CONFIG_SETS_TL.NAME, HWM_TCSMR_CONFIG_SETS_TL.DESCRIPTION, HWM_TCSMR_CONFIG_SETS_B.WRKFLW_NTFN_ENABLED, HWM_TCSMR_CONFIG_SETS_B.ABS_APPROVAL_USAGE_CD, HWM_TCSMR_CONFIG_SETS_B.SGUID SGUID, HWM_TCSMR_CONFIG_SETS_B.WRK_APPROVAL_ENABLED FROM HWM_TCSMR_CONFIG_SETS_B, HWM_TCSMR_CONFIG_SETS_TL WHERE HWM_TCSMR_CONFIG_SETS_B.TCSMR_CONFIG_SET_ID = HWM_TCSMR_CONFIG_SETS_TL.TCSMR_CONFIG_SET_ID AND HWM_TCSMR_CONFIG_SETS_TL.LANGUAGE = USERENV('LANG')