MOW_ASSESS_SCORE_RANGES_VL

Details

• Schema: FUSION

• Object owner: MOW

• Object type: VIEW

Columns

Name
SCORE_RANGE_ID ASSESS_TEMPLATE_ID START_SCORE END_SCORE GRAPH_COLOR ASSESS_RATING_ID DELETED_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER FEEDBACK DESC_TEXT SCORE_RANGE_NUMBER

Query

SQL_Statement

SELECT MOW_ASSESS_SCORE_RANGES_B.SCORE_RANGE_ID SCORE_RANGE_ID, MOW_ASSESS_SCORE_RANGES_B.ASSESS_TEMPLATE_ID ASSESS_TEMPLATE_ID, MOW_ASSESS_SCORE_RANGES_B.START_SCORE START_SCORE, MOW_ASSESS_SCORE_RANGES_B.END_SCORE END_SCORE, MOW_ASSESS_SCORE_RANGES_B.GRAPH_COLOR GRAPH_COLOR, MOW_ASSESS_SCORE_RANGES_B.ASSESS_RATING_ID ASSESS_RATING_ID, MOW_ASSESS_SCORE_RANGES_B.DELETED_FLAG DELETED_FLAG, MOW_ASSESS_SCORE_RANGES_B.CREATED_BY CREATED_BY, MOW_ASSESS_SCORE_RANGES_B.CREATION_DATE CREATION_DATE, MOW_ASSESS_SCORE_RANGES_B.LAST_UPDATED_BY LAST_UPDATED_BY, MOW_ASSESS_SCORE_RANGES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, MOW_ASSESS_SCORE_RANGES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MOW_ASSESS_SCORE_RANGES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, MOW_ASSESS_SCORE_RANGES_TL.FEEDBACK FEEDBACK, MOW_ASSESS_SCORE_RANGES_TL.DESC_TEXT DESC_TEXT, MOW_ASSESS_SCORE_RANGES_B.SCORE_RANGE_NUMBER SCORE_RANGE_NUMBER FROM MOW_ASSESS_SCORE_RANGES_B, MOW_ASSESS_SCORE_RANGES_TL WHERE MOW_ASSESS_SCORE_RANGES_B.SCORE_RANGE_ID = MOW_ASSESS_SCORE_RANGES_TL.SCORE_RANGE_ID AND MOW_ASSESS_SCORE_RANGES_TL.LANGUAGE = USERENV('LANG')