HRT_OBJ_RATING_DIST_VL

Details

• Schema: FUSION

• Object owner: HRT

• Object type: VIEW

Columns

Name
OBJ_RATING_DIST_ID OBJECT_ID OBJECT_TYPE_CODE RATING_MODEL_ID RATING_DIST_NAME RATING_DIST_DESCR DATE_FROM DATE_TO OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN BUSINESS_GROUP_ID

Query

SQL_Statement

SELECT B.OBJ_RATING_DIST_ID OBJ_RATING_DIST_ID, B.OBJECT_ID OBJECT_ID, B.OBJECT_TYPE_CODE OBJECT_TYPE_CODE, B.RATING_MODEL_ID RATING_MODEL_ID, TL.RATING_DIST_NAME RATING_DIST_NAME, TL.RATING_DIST_DESCR RATING_DIST_DESCR, B.DATE_FROM DATE_FROM, B.DATE_TO DATE_TO, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , B.BUSINESS_GROUP_ID BUSINESS_GROUP_ID FROM HRT_OBJ_RATING_DIST_B B, HRT_OBJ_RATING_DIST_TL TL WHERE B.OBJ_RATING_DIST_ID = TL.OBJ_RATING_DIST_ID AND TL.LANGUAGE = USERENV('LANG')