1. Tables and Views for HCM
  2. HWR_ENDORSER_ENDORSEE_VL

HWR_ENDORSER_ENDORSEE_VL

Details

  • Schema: FUSION

  • Object owner: HWR

  • Object type: VIEW

Columns

Name

DISPLAY_TEXT

ENDORSER_PRFL_ID

ENDORSEE_PRFL_ID

LAST_UPDATE_DATE

Query

SQL_Statement

SELECT NVL(TL.DISPLAY_TEXT,

(SELECT DISPLAY_TEXT

FROM HWR_CAT_TOPIC_TL TL1

WHERE TL1.TOPIC_ID = T.TOPIC_ID

AND ROWNUM =1

)) AS DISPLAY_TEXT,

B.RECOMMENDER_FUS_PRFL_ID ENDORSER_PRFL_ID,

B.ENDORSEE_FUS_PRFL_ID ENDORSEE_PRFL_ID,

B.LAST_UPDATE_DATE

FROM HWR_CAT_TOPIC_TL TL,

HWR_ENDORSEMENT_B B,

HWR_CAT_TOPIC_B T

WHERE TL.LANGUAGE(+) = 'US'

AND TL.TOPIC_ID(+) = T.TOPIC_ID

AND T.TOPIC_ID = B.TOPIC_ID