HWM_TCD_MAPPINGS_VL

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name
TCD_MAPPING_ID TCD_MAPPING_CD TCD_EVENT_CD VENDOR_CD OBJECT_VERSION_NUMBER ENTERPRISE_ID MODULE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN NAME DESCRIPTION WFM_EVENT_IN_OUT

Query

SQL_Statement

SELECT HWM_TCD_MAPPINGS_B.TCD_MAPPING_ID TCD_MAPPING_ID, HWM_TCD_MAPPINGS_B.TCD_MAPPING_CD TCD_MAPPING_CD, HWM_TCD_MAPPINGS_B.TCD_EVENT_CD TCD_EVENT_CD, HWM_TCD_MAPPINGS_B.VENDOR_CD VENDOR_CD, HWM_TCD_MAPPINGS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, HWM_TCD_MAPPINGS_B.ENTERPRISE_ID ENTERPRISE_ID, HWM_TCD_MAPPINGS_B.MODULE_ID MODULE_ID, HWM_TCD_MAPPINGS_B.CREATED_BY CREATED_BY, HWM_TCD_MAPPINGS_B.CREATION_DATE CREATION_DATE, HWM_TCD_MAPPINGS_B.LAST_UPDATED_BY LAST_UPDATED_BY, HWM_TCD_MAPPINGS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, HWM_TCD_MAPPINGS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, HWM_TCD_MAPPINGS_TL.NAME NAME, HWM_TCD_MAPPINGS_TL.DESCRIPTION DESCRIPTION, HWM_TCD_MAPPINGS_B.WFM_EVENT_IN_OUT WFM_EVENT_IN_OUT FROM HWM_TCD_MAPPINGS_B, HWM_TCD_MAPPINGS_TL WHERE HWM_TCD_MAPPINGS_B.TCD_MAPPING_ID = HWM_TCD_MAPPINGS_TL.TCD_MAPPING_ID AND HWM_TCD_MAPPINGS_TL.LANGUAGE = USERENV('LANG')