HRT_RATING_CATEGORIES_VL

Details

• Schema: FUSION

• Object owner: HRT

• Object type: VIEW

Columns

Name
CATEGORY_ID BUSINESS_GROUP_ID RATING_MODEL_ID LOWER_BOUNDARY UPPER_BOUNDARY CATEGORY_NAME CATEGORY_DESCRIPTION OBJECT_VERSION_NUMBER MODULE_ID CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT RC.CATEGORY_ID, RC.BUSINESS_GROUP_ID, RC.RATING_MODEL_ID, RC.LOWER_BOUNDARY, RC.UPPER_BOUNDARY, RCTL.CATEGORY_NAME, RCTL.CATEGORY_DESCRIPTION, RC.OBJECT_VERSION_NUMBER, RC.MODULE_ID, RC.CREATED_BY, RC.CREATION_DATE, RC.LAST_UPDATE_DATE, RC.LAST_UPDATED_BY, RC.LAST_UPDATE_LOGIN FROM HRT_RATING_CATEGORIES_B RC, HRT_RATING_CATEGORIES_TL RCTL WHERE RC.CATEGORY_ID = RCTL.CATEGORY_ID AND RC.BUSINESS_GROUP_ID = RCTL.BUSINESS_GROUP_ID AND RCTL.LANGUAGE = USERENV('LANG')