HWR_ENDORSEMENT_VL

Details

• Schema: FUSION

• Object owner: HWR

• Object type: VIEW

Columns

Name
ENDORSEMENT_ID ENDORSEMENT_TEXT ENDORSEMENT_DATE TOPIC_ID RECOMMENDER_ID RECOMMENDER_GBL_PRFL_ID RECOMMENDER_NAME RECOMMENDER_TITLE RECOMMENDER_EMAIL RECOMMENDER_RELATION RECOMMENDER_IMAGE_URL GBL_PRFL_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.ENDORSEMENT_ID , B.ENDORSEMENT_TEXT , B.ENDORSEMENT_DATE , B.TOPIC_ID , B.RECOMMENDER_ID , B.RECOMMENDER_GBL_PRFL_ID , B.RECOMMENDER_NAME , B.RECOMMENDER_TITLE , B.RECOMMENDER_EMAIL , B.RECOMMENDER_RELATION , B.RECOMMENDER_IMAGE_URL , X.GBL_PRFL_ID , B.CREATED_BY , B.CREATION_DATE , B.LAST_UPDATED_BY , B.LAST_UPDATE_DATE , B.LAST_UPDATE_LOGIN FROM HWR_ENDORSEMENT_B B LEFT JOIN HWR_ENDORSE_GBL_PRFL_X X ON (B.ENDORSEMENT_ID = X.ENDORSEMENT_ID)