1. Tables and Views for HCM
  2. HRT_RATING_LVL_DESCRS_V

HRT_RATING_LVL_DESCRS_V

Details

  • Schema: FUSION

  • Object owner: HRT

  • Object type: VIEW

Columns

Name

RATING_MODEL_ID

BUSINESS_GROUP_ID

NUM_OF_RATING_LEVELS

DESC1

DESC2

DESC3

DESC4

DESC5

DESC6

DESC7

DESC8

DESC9

DESC10

Query

SQL_Statement

SELECT RATINGS.RATING_MODEL_ID RATING_MODEL_ID,

RATINGS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID,

(SELECT COUNT(*) FROM HRT_RATING_LEVELS_VL WHERE RATING_MODEL_ID = RATINGS.RATING_MODEL_ID AND BUSINESS_GROUP_ID = RATINGS.BUSINESS_GROUP_ID AND STAR_RATING > 0) AS NUM_OF_RATING_LEVELS,

DESC1.RATING_DESCRIPTION DESC1,

DESC2.RATING_DESCRIPTION DESC2,

DESC3.RATING_DESCRIPTION DESC3,

DESC4.RATING_DESCRIPTION DESC4,

DESC5.RATING_DESCRIPTION DESC5,

DESC6.RATING_DESCRIPTION DESC6,

DESC7.RATING_DESCRIPTION DESC7,

DESC8.RATING_DESCRIPTION DESC8,

DESC9.RATING_DESCRIPTION DESC9,

DESC10.RATING_DESCRIPTION DESC10

FROM HRT_RATING_MODELS_VL RATINGS,

(SELECT RATING_MODEL_ID, BUSINESS_GROUP_ID, STAR_RATING, RATING_DESCRIPTION FROM HRT_RATING_LEVELS_VL) DESC1,

(SELECT RATING_MODEL_ID, BUSINESS_GROUP_ID, STAR_RATING, RATING_DESCRIPTION FROM HRT_RATING_LEVELS_VL) DESC2,

(SELECT RATING_MODEL_ID, BUSINESS_GROUP_ID, STAR_RATING, RATING_DESCRIPTION FROM HRT_RATING_LEVELS_VL) DESC3,

(SELECT RATING_MODEL_ID, BUSINESS_GROUP_ID, STAR_RATING, RATING_DESCRIPTION FROM HRT_RATING_LEVELS_VL) DESC4,

(SELECT RATING_MODEL_ID, BUSINESS_GROUP_ID, STAR_RATING, RATING_DESCRIPTION FROM HRT_RATING_LEVELS_VL) DESC5,

(SELECT RATING_MODEL_ID, BUSINESS_GROUP_ID, STAR_RATING, RATING_DESCRIPTION FROM HRT_RATING_LEVELS_VL) DESC6,

(SELECT RATING_MODEL_ID, BUSINESS_GROUP_ID, STAR_RATING, RATING_DESCRIPTION FROM HRT_RATING_LEVELS_VL) DESC7,

(SELECT RATING_MODEL_ID, BUSINESS_GROUP_ID, STAR_RATING, RATING_DESCRIPTION FROM HRT_RATING_LEVELS_VL) DESC8,

(SELECT RATING_MODEL_ID, BUSINESS_GROUP_ID, STAR_RATING, RATING_DESCRIPTION FROM HRT_RATING_LEVELS_VL) DESC9,

(SELECT RATING_MODEL_ID, BUSINESS_GROUP_ID, STAR_RATING, RATING_DESCRIPTION FROM HRT_RATING_LEVELS_VL) DESC10

WHERE RATINGS.RATING_MODEL_ID = DESC1.RATING_MODEL_ID(+)

AND RATINGS.BUSINESS_GROUP_ID = DESC1.BUSINESS_GROUP_ID(+)

AND RATINGS.RATING_MODEL_ID = DESC2.RATING_MODEL_ID(+)

AND RATINGS.BUSINESS_GROUP_ID = DESC2.BUSINESS_GROUP_ID(+)

AND RATINGS.RATING_MODEL_ID = DESC3.RATING_MODEL_ID(+)

AND RATINGS.BUSINESS_GROUP_ID = DESC3.BUSINESS_GROUP_ID(+)

AND RATINGS.RATING_MODEL_ID = DESC4.RATING_MODEL_ID(+)

AND RATINGS.BUSINESS_GROUP_ID = DESC4.BUSINESS_GROUP_ID(+)

AND RATINGS.RATING_MODEL_ID = DESC5.RATING_MODEL_ID(+)

AND RATINGS.BUSINESS_GROUP_ID = DESC5.BUSINESS_GROUP_ID(+)

AND RATINGS.RATING_MODEL_ID = DESC6.RATING_MODEL_ID(+)

AND RATINGS.BUSINESS_GROUP_ID = DESC6.BUSINESS_GROUP_ID(+)

AND RATINGS.RATING_MODEL_ID = DESC7.RATING_MODEL_ID(+)

AND RATINGS.BUSINESS_GROUP_ID = DESC7.BUSINESS_GROUP_ID(+)

AND RATINGS.RATING_MODEL_ID = DESC8.RATING_MODEL_ID(+)

AND RATINGS.BUSINESS_GROUP_ID = DESC8.BUSINESS_GROUP_ID(+)

AND RATINGS.RATING_MODEL_ID = DESC9.RATING_MODEL_ID(+)

AND RATINGS.BUSINESS_GROUP_ID = DESC9.BUSINESS_GROUP_ID(+)

AND RATINGS.RATING_MODEL_ID = DESC10.RATING_MODEL_ID(+)

AND RATINGS.BUSINESS_GROUP_ID = DESC10.BUSINESS_GROUP_ID(+)

AND DESC1.STAR_RATING(+) = 1

AND DESC2.STAR_RATING(+) = 2

AND DESC3.STAR_RATING(+) = 3

AND DESC4.STAR_RATING(+) = 4

AND DESC5.STAR_RATING(+) = 5

AND DESC6.STAR_RATING(+) = 6

AND DESC7.STAR_RATING(+) = 7

AND DESC8.STAR_RATING(+) = 8

AND DESC9.STAR_RATING(+) = 9

AND DESC10.STAR_RATING(+) = 10