Product: | AMS - Marketing |
---|---|
Description: | This public view returns the registration details of the participants to a marketing event. |
Implementation/DBA Data: | APPS.AMS_P_EVENT_REG_ROSTER_V |
SELECT EVO.EVENT_OFFER_ID
, EVO.EVENT_OFFER_NAME
, EVO.EVENT_LOCATION_ID
, HZL.CITY
, HZL.STATE
, HZL.PROVINCE
, HZL.COUNTRY
, EVO.EVENT_START_DATE
, EVO.EVENT_START_DATE_TIME
, EVO.EVENT_END_DATE
, EVO.EVENT_END_DATE_TIME
, REG.REGISTRANT_PARTY_ID
, HZP.PARTY_NAME
, REG.REGISTRANT_ACCOUNT_ID
, REG.REGISTRANT_CONTACT_ID
, NULL
, REG.EVENT_REGISTRATION_ID
, REG.CONFIRMATION_CODE
, REG.CANCELLATION_CODE
, REG.WAITLISTED_PRIORITY
, REG.USER_STATUS_ID
, AUS.SYSTEM_STATUS_CODE
, AUS.NAME
, REG.REGISTRATION_GROUP_ID
, EVO.INVENTORY_ITEM_ID
, REG.ORDER_HEADER_ID
, REG.ORDER_LINE_ID
FROM AMS_EVENT_OFFERS_VL EVO
, AMS_EVENT_REGISTRATIONS REG
, HZ_LOCATIONS HZL
, AMS_USER_STATUSES_VL AUS
, HZ_PARTIES HZP
WHERE EVO.EVENT_OFFER_ID=REG.EVENT_OFFER_ID
AND EVO.USER_STATUS_ID=AUS.USER_STATUS_ID
AND EVO.EVENT_LOCATION_ID=HZL.LOCATION_ID
AND REG.REGISTRANT_PARTY_ID=HZP.PARTY_ID