HWM_TCD_MAPPING_SETS_VL

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name
TCD_MAPPING_SET_ID TCD_MAPPING_SET_CD OBJECT_VERSION_NUMBER ENTERPRISE_ID MODULE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN NAME DESCRIPTION

Query

SQL_Statement

SELECT HWM_TCD_MAPPING_SETS_B.TCD_MAPPING_SET_ID, HWM_TCD_MAPPING_SETS_B.TCD_MAPPING_SET_CD, HWM_TCD_MAPPING_SETS_B.OBJECT_VERSION_NUMBER, HWM_TCD_MAPPING_SETS_B.ENTERPRISE_ID, HWM_TCD_MAPPING_SETS_B.MODULE_ID, HWM_TCD_MAPPING_SETS_B.CREATED_BY, HWM_TCD_MAPPING_SETS_B.CREATION_DATE, HWM_TCD_MAPPING_SETS_B.LAST_UPDATED_BY, HWM_TCD_MAPPING_SETS_B.LAST_UPDATE_DATE, HWM_TCD_MAPPING_SETS_B.LAST_UPDATE_LOGIN, HWM_TCD_MAPPING_SETS_TL.NAME, HWM_TCD_MAPPING_SETS_TL.DESCRIPTION FROM HWM_TCD_MAPPING_SETS_B, HWM_TCD_MAPPING_SETS_TL WHERE HWM_TCD_MAPPING_SETS_TL.TCD_MAPPING_SET_ID = HWM_TCD_MAPPING_SETS_B.TCD_MAPPING_SET_ID AND HWM_TCD_MAPPING_SETS_TL.LANGUAGE = USERENV('LANG')