HWM_TE_ALT_NAME_VALS_VL

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name

TE_ALT_NAME_ID TE_ALT_NAME_VAL_ID OBJECT_VERSION_NUMBER ENTERPRISE_ID MODULE_ID NAME WFM_EVENT_IN_OUT DATE_FROM DATE_TO ENABLED_FLAG EXISTING_FLAG ALT_NAME_VALUE ATTRIBUTE1 ADDL_ATTRIBUTE1 ATTRIBUTE2 ADDL_ATTRIBUTE2 ATTRIBUTE3 ADDL_ATTRIBUTE3 ATTRIBUTE4 ADDL_ATTRIBUTE4 ATTRIBUTE5 ADDL_ATTRIBUTE5 ATTRIBUTE6 ADDL_ATTRIBUTE6 ATTRIBUTE7 ADDL_ATTRIBUTE7 ATTRIBUTE8 ADDL_ATTRIBUTE8 ATTRIBUTE9 ADDL_ATTRIBUTE9 ATTRIBUTE10 ADDL_ATTRIBUTE10 ATTRIBUTE11 ADDL_ATTRIBUTE11 ATTRIBUTE12 ADDL_ATTRIBUTE12 ATTRIBUTE13 ADDL_ATTRIBUTE13 ATTRIBUTE14 ADDL_ATTRIBUTE14 ATTRIBUTE15 ADDL_ATTRIBUTE15 ATTRIBUTE16 ADDL_ATTRIBUTE16 ATTRIBUTE17 ADDL_ATTRIBUTE17 ATTRIBUTE18 ADDL_ATTRIBUTE18 ATTRIBUTE19 ADDL_ATTRIBUTE19 ATTRIBUTE20 ADDL_ATTRIBUTE20 ATTRIBUTE21 ADDL_ATTRIBUTE21 ATTRIBUTE22 ADDL_ATTRIBUTE22 ATTRIBUTE23 ADDL_ATTRIBUTE23 ATTRIBUTE24 ADDL_ATTRIBUTE24 ATTRIBUTE25 ADDL_ATTRIBUTE25 ATTRIBUTE26 ADDL_ATTRIBUTE26 ATTRIBUTE27 ADDL_ATTRIBUTE27 ATTRIBUTE28 ADDL_ATTRIBUTE28 ATTRIBUTE29 ADDL_ATTRIBUTE29 ATTRIBUTE30 ADDL_ATTRIBUTE30 DISPLAY_SEQUENCE MANAGER_ACTION_CD WORKER_ACTION_CD TL_MGR_ACTION_CD LINE_MGR_ACTION_CD ENABLE_CO_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT HWM_TE_ALT_NAME_VALS_B.TE_ALT_NAME_ID TE_ALT_NAME_ID, HWM_TE_ALT_NAME_VALS_B.TE_ALT_NAME_VAL_ID TE_ALT_NAME_VAL_ID, HWM_TE_ALT_NAME_VALS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, HWM_TE_ALT_NAME_VALS_B.ENTERPRISE_ID ENTERPRISE_ID, HWM_TE_ALT_NAME_VALS_B.MODULE_ID MODULE_ID, HWM_TE_ALT_NAME_VALS_B.NAME NAME, HWM_TE_ALT_NAME_VALS_B.WFM_EVENT_IN_OUT WFM_EVENT_IN_OUT, HWM_TE_ALT_NAME_VALS_B.DATE_FROM DATE_FROM, HWM_TE_ALT_NAME_VALS_B.DATE_TO DATE_TO, HWM_TE_ALT_NAME_VALS_B.ENABLED_FLAG ENABLED_FLAG, HWM_TE_ALT_NAME_VALS_B.EXISTING_FLAG EXISTING_FLAG, HWM_TE_ALT_NAME_VALS_TL.ALT_NAME_VALUE ALT_NAME_VALUE, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE1 ATTRIBUTE1, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE1 ADDL_ATTRIBUTE1, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE2 ATTRIBUTE2, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE2 ADDL_ATTRIBUTE2, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE3 ATTRIBUTE3, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE3 ADDL_ATTRIBUTE3, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE4 ATTRIBUTE4, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE4 ADDL_ATTRIBUTE4, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE5 ATTRIBUTE5, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE5 ADDL_ATTRIBUTE5, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE6 ATTRIBUTE6, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE6 ADDL_ATTRIBUTE6, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE7 ATTRIBUTE7, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE7 ADDL_ATTRIBUTE7, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE8 ATTRIBUTE8, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE8 ADDL_ATTRIBUTE8, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE9 ATTRIBUTE9, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE9 ADDL_ATTRIBUTE9, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE10 ATTRIBUTE10, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE10 ADDL_ATTRIBUTE10, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE11 ATTRIBUTE11, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE11 ADDL_ATTRIBUTE11, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE12 ATTRIBUTE12, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE12 ADDL_ATTRIBUTE12, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE13 ATTRIBUTE13, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE13 ADDL_ATTRIBUTE13, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE14 ATTRIBUTE14, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE14 ADDL_ATTRIBUTE14, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE15 ATTRIBUTE15, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE15 ADDL_ATTRIBUTE15, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE16 ATTRIBUTE16, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE16 ADDL_ATTRIBUTE16, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE17 ATTRIBUTE17, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE17 ADDL_ATTRIBUTE17, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE18 ATTRIBUTE18, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE18 ADDL_ATTRIBUTE18, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE19 ATTRIBUTE19, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE19 ADDL_ATTRIBUTE19, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE20 ATTRIBUTE20, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE20 ADDL_ATTRIBUTE20, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE21 ATTRIBUTE21, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE21 ADDL_ATTRIBUTE21, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE22 ATTRIBUTE22, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE22 ADDL_ATTRIBUTE22, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE23 ATTRIBUTE23, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE23 ADDL_ATTRIBUTE23, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE24 ATTRIBUTE24, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE24 ADDL_ATTRIBUTE24, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE25 ATTRIBUTE25, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE25 ADDL_ATTRIBUTE25, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE26 ATTRIBUTE26, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE26 ADDL_ATTRIBUTE26, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE27 ATTRIBUTE27, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE27 ADDL_ATTRIBUTE27, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE28 ATTRIBUTE28, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE28 ADDL_ATTRIBUTE28, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE29 ATTRIBUTE29, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE29 ADDL_ATTRIBUTE29, HWM_TE_ALT_NAME_VALS_B.ATTRIBUTE30 ATTRIBUTE30, HWM_TE_ALT_NAME_VALS_B.ADDL_ATTRIBUTE30 ADDL_ATTRIBUTE30, HWM_TE_ALT_NAME_VALS_B.DISPLAY_SEQUENCE DISPLAY_SEQUENCE, HWM_TE_ALT_NAME_VALS_B.MANAGER_ACTION_CD MANAGER_ACTION_CD, HWM_TE_ALT_NAME_VALS_B.WORKER_ACTION_CD WORKER_ACTION_CD, HWM_TE_ALT_NAME_VALS_B.TL_MGR_ACTION_CD TL_MGR_ACTION_CD, HWM_TE_ALT_NAME_VALS_B.LINE_MGR_ACTION_CD LINE_MGR_ACTION_CD , HWM_TE_ALT_NAME_VALS_B.ENABLE_CO_FLAG ENABLE_CO_FLAG, HWM_TE_ALT_NAME_VALS_B.CREATED_BY CREATED_BY, HWM_TE_ALT_NAME_VALS_B.CREATION_DATE CREATION_DATE, HWM_TE_ALT_NAME_VALS_B.LAST_UPDATED_BY LAST_UPDATED_BY, HWM_TE_ALT_NAME_VALS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, HWM_TE_ALT_NAME_VALS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM HWM_TE_ALT_NAME_VALS_B, HWM_TE_ALT_NAME_VALS_TL WHERE HWM_TE_ALT_NAME_VALS_B.TE_ALT_NAME_VAL_ID = HWM_TE_ALT_NAME_VALS_TL.TE_ALT_NAME_VAL_ID AND HWM_TE_ALT_NAME_VALS_TL.LANGUAGE = USERENV('LANG')