HRC_MESSAGE_CATEGORIES_VL

Details

• Schema: FUSION

• Object owner: HRC

• Object type: VIEW

Columns

Name
CATEGORY_ID CATEGORY_CODE PARENT_CATEGORY_CODE IS_SUB_CATEGORY_MANDATORY IS_ACTIVE ENTERPRISE_ID MODULE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER NAME CATEGORY_NAME_MODIFIED

Query

SQL_Statement

SELECT HMCB.CATEGORY_ID CATEGORY_ID, HMCB.CATEGORY_CODE CATEGORY_CODE, HMCB.PARENT_CATEGORY_CODE PARENT_CATEGORY_CODE, HMCB.IS_SUB_CATEGORY_MANDATORY, HMCB.IS_ACTIVE IS_ACTIVE, HMCB.ENTERPRISE_ID ENTERPRISE_ID, HMCB.MODULE_ID MODULE_ID, HMCB.CREATED_BY CREATED_BY, HMCB.CREATION_DATE CREATION_DATE, HMCB.LAST_UPDATED_BY LAST_UPDATED_BY, HMCB.LAST_UPDATE_DATE LAST_UPDATE_DATE, HMCB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, HMCB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, HMCTL.NAME NAME, HMCTL.CATEGORY_NAME_MODIFIED CATEGORY_NAME_MODIFIED FROM HRC_MESSAGE_CATEGORIES_B HMCB, HRC_MESSAGE_CATEGORIES_TL HMCTL WHERE HMCB.CATEGORY_ID = HMCTL.CATEGORY_ID AND HMCTL.LANGUAGE = USERENV('LANG')