Product: | AMS - Marketing |
---|---|
Description: | This public view returns the registration contact details of the participants to a marketing event. |
Implementation/DBA Data: | APPS.AMS_P_EVENT_REG_CONTACTS_V |
SELECT REG.EVENT_OFFER_ID
, EVO.EVENT_OFFER_NAME
, REG.EVENT_REGISTRATION_ID
, REG.CONFIRMATION_CODE
, REG.CANCELLATION_CODE
, REG.REGISTRANT_PARTY_ID
, HZP.CUSTOMER_NAME
, REG.REGISTRANT_ACCOUNT_ID
, REG.REGISTRANT_CONTACT_ID
, NULL
, REG.DATE_REGISTRATION_PLACED
, AUS.USER_STATUS_ID
, AUS.NAME
FROM AMS_EVENT_REGISTRATIONS REG
, AMS_EVENT_OFFERS_VL EVO
, AMS_USER_STATUSES_VL AUS
, AMS_PARTY_CUSTOMERS_V HZP
WHERE REG.EVENT_OFFER_ID=EVO.EVENT_OFFER_ID
AND EVO.USER_STATUS_ID=AUS.USER_STATUS_ID
AND REG.REGISTRANT_PARTY_ID=HZP.PARTY_ID