HWM_PROCESSES_VL

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name
PROCESS_ID ENTERPRISE_ID LANGUAGE SOURCE_LANG NAME DESCRIPTION MODULE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN PROCESS_CD SGUID

Query

SQL_Statement

SELECT PROCESS.PROCESS_ID PROCESS_ID, PROCESS.ENTERPRISE_ID ENTERPRISE_ID, PROCESS_LANG.LANGUAGE LANGUAGE, PROCESS_LANG.SOURCE_LANG SOURCE_LANG, PROCESS_LANG.NAME NAME, PROCESS_LANG.DESCRIPTION DESCRIPTION, PROCESS.MODULE_ID, PROCESS.OBJECT_VERSION_NUMBER, PROCESS.CREATED_BY, PROCESS.CREATION_DATE, PROCESS.LAST_UPDATED_BY, PROCESS.LAST_UPDATE_DATE, PROCESS.LAST_UPDATE_LOGIN, PROCESS.PROCESS_CD PROCESS_CD, PROCESS.SGUID SGUID FROM HWM_PROCESSES_B PROCESS, HWM_PROCESSES_TL PROCESS_LANG WHERE PROCESS.PROCESS_ID = PROCESS_LANG.PROCESS_ID AND PROCESS_LANG.LANGUAGE = USERENV('LANG')