HWR_RECOGNITION_VL

Details

• Schema: FUSION

• Object owner: HWR

• Object type: VIEW

Columns

Name
RECOGNITION_ID RECOGNITION_TEXT RECOGNITION_DATE 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.RECOGNITION_ID , B.RECOGNITION_TEXT , B.RECOGNITION_DATE , 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_RECOGNITION_B B LEFT JOIN HWR_RECOGN_GBL_PRFL_X X ON (B.RECOGNITION_ID = X.RECOGNITION_ID)