eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: AMS_EVENT_REGISTRATIONS

Product:	AMS - Marketing
Description:	Stores all enrollment information for an event, who got registered, who will be attending and their status.
Implementation/DBA Data:	AMS.AMS_EVENT_REGISTRATIONS

Primary Key: AMS_EVENT_REGISTRATIONS_PK

EVENT_REGISTRATION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AMS_EVENT_REGISTRATIONS	AMS_USER_STATUSES_B	AMS_EVENT_REGISTRATIONS.USER_STATUS_ID
AMS_EVENT_REGISTRATIONS	HZ_PARTIES	AMS_EVENT_REGISTRATIONS.REGISTRANT_PARTY_ID
AMS_EVENT_REGISTRATIONS	HZ_CUST_ACCOUNTS	AMS_EVENT_REGISTRATIONS.ATTENDANT_ACCOUNT_ID
AMS_EVENT_REGISTRATIONS	HZ_ORG_CONTACTS	AMS_EVENT_REGISTRATIONS.REGISTRANT_CONTACT_ID
AMS_EVENT_REGISTRATIONS	AMS_CHANNELS_B	AMS_EVENT_REGISTRATIONS.INBOUND_CHANNEL_ID
AMS_EVENT_REGISTRATIONS	HZ_ORG_CONTACTS	AMS_EVENT_REGISTRATIONS.ATTENDANT_CONTACT_ID
AMS_EVENT_REGISTRATIONS	HZ_CUST_ACCOUNTS	AMS_EVENT_REGISTRATIONS.REGISTRANT_ACCOUNT_ID
AMS_EVENT_REGISTRATIONS	HZ_ORG_CONTACTS	AMS_EVENT_REGISTRATIONS.ORIGINAL_REGISTRANT_CONTACT_ID
AMS_EVENT_REGISTRATIONS	HZ_PARTIES	AMS_EVENT_REGISTRATIONS.ATTENDANT_PARTY_ID
AMS_EVENT_REGISTRATIONS	JTF_RS_RESOURCE_EXTNS	AMS_EVENT_REGISTRATIONS.OWNER_USER_ID
AMS_EVENT_REGISTRATIONS	AMS_MEDIA_B	AMS_EVENT_REGISTRATIONS.INBOUND_MEDIA_ID
AMS_EVENT_REGISTRATIONS	AMS_EVENT_OFFERS_ALL_B	AMS_EVENT_REGISTRATIONS.EVENT_OFFER_ID
AMS_EVENT_REGISTRATIONS	HZ_PARTIES	AMS_EVENT_REGISTRATIONS.REGISTRANT_PARTY_ID
AMS_EVENT_REGISTRATIONS	FND_LANGUAGES	AMS_EVENT_REGISTRATIONS.ATTENDANT_LANGUAGE
AMS_EVENT_REGISTRATIONS	FND_APPLICATION	AMS_EVENT_REGISTRATIONS.APPLICATION_ID
AMS_EVENT_REGISTRATIONS	AMS_USER_STATUSES_B	AMS_EVENT_REGISTRATIONS.USER_STATUS_ID
AMS_EVENT_REGISTRATIONS	AMS_LIST_HEADERS_ALL	AMS_EVENT_REGISTRATIONS.TARGET_LIST_ID
AMS_EVENT_REGISTRATIONS	OE_ORDER_HEADERS_ALL	AMS_EVENT_REGISTRATIONS.ORDER_HEADER_ID
AMS_EVENT_REGISTRATIONS	OE_ORDER_LINES_ALL	AMS_EVENT_REGISTRATIONS.ORDER_LINE_ID
AMS_ACT_COMMUNICATIONS	AMS_EVENT_REGISTRATIONS	AMS_ACT_COMMUNICATIONS.ACT_COMMUNICATION_USED_BY_ID