[Home] [Help]
View: AMS_DLG_EVENT_REGISTRATIONS_VL
Product: | AMS - Marketing |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT R.EVENT_REGISTRATION_ID
, R.ATTENDANT_PARTY_ID
, R.CONFIRMATION_CODE
, U.NAME
, P.PERSON_FIRST_NAME
, P.PERSON_FIRST_NAME
, P.PERSON_LAST_NAME
, P.PERSON_LAST_NAME
FROM AMS_EVENT_REGISTRATIONS R
, AMS_USER_STATUSES_VL U
, HZ_PARTIES P
WHERE U.SYSTEM_STATUS_TYPE = 'AMS_EVENT_REG_STATUS'
AND R.USER_STATUS_ID = U.USER_STATUS_ID
AND R.ATTENDANT_PARTY_ID = P.PARTY_ID
Columns
Name |
EVENT_REGISTRATION_ID |
ATTENDANT_PARTY_ID |
CONFIRMATION_CODE |
SYSTEM_STATUS_MEANING |
PERSON_FIRST_NAME |
FIRST_NAME |
PERSON_LAST_NAME |
LAST_NAME |