[Home] [Help]
View: GMS_NOTIFICATIONS_V
View Text
SELECT NOTFY.ROWID
, AWARD.AWARD_ID
, AWARD.AWARD_NUMBER
, AWARD.AWARD_SHORT_NAME
, NOTFY.EVENT_TYPE
, NOTFY.USER_ID
, PPX.FULL_NAME
, FNDU.USER_NAME
FROM GMS_AWARDS_ALL AWARD
, GMS_NOTIFICATIONS NOTFY
, FND_USER FNDU
, PER_PEOPLE_X PPX
WHERE AWARD.AWARD_ID = NOTFY.AWARD_ID
AND NOTFY.USER_ID = FNDU.USER_ID
AND FNDU.EMPLOYEE_ID = PPX.PERSON_ID
Columns
Name |
ROW_ID |
AWARD_ID |
AWARD_NUMBER |
AWARD_SHORT_NAME |
EVENT_TYPE |
USER_ID |
USER_FULL_NAME |
USER_NAME |