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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.AMS_EVENT_REGISTRATIONS_V

Object Details

Object Name:	AMS_EVENT_REGISTRATIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_EVENT_REGISTRATIONS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
EVENT_REGISTRATION_ID	NUMBER		Event Registration Unique Identifier
LAST_UPDATE_DATE	DATE		Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Standard WHO Column
CREATION_DATE	DATE		Standard WHO Column
CREATED_BY	NUMBER	(15)	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard WHO Column
OBJECT_VERSION_NUMBER	NUMBER	(9)	This column is used for locking purposes. A way to implement Optimistic Locking.
APPLICATION_ID	NUMBER	(15)	Application Identifier.
OWNER_USER_ID	NUMBER		The person who took the registration. This is the user ID of the person who recorded the registration in the System.
CONFIRMATION_CODE	VARCHAR2	(30)	If the registration is confirmed, this field holds the Confirmation Code.
EVENT_OFFER_ID	NUMBER		Event Offer ID of the Event Offering for which this registration is done.
ACTIVE_FLAG	VARCHAR2	(1)	This is the flag to indicate a deleted record. We do only soft-deletes in the system. The Select statements pull up only those records for which the ACTIVE_FLAG is 'Y'.
DATE_REGISTRATION_PLACED	DATE		Date on which this Registration was done.
USER_STATUS_ID	NUMBER		This field keeps track of the System Status for this Registration Record. This field gets updated as and when the Registration proceeds from Waitlisted to Confirmed Registration to Cancelled Registration.
USER_STATUS	VARCHAR2	(120)	This field keeps track of the System Status for this Registration Record. This field gets updated as and when the Registration proceeds from Waitlisted to Confirmed Registration to Cancelled Registration.
SYSTEM_STATUS_CODE	VARCHAR2	(30)	This field ties in with the USER_STATUS_ID. Added to this table for ease of reporting.
LAST_REG_STATUS_DATE	DATE		This field ties in with USER_STATUS_ID. This date is the date when the USER_STATUS_ID was last changed.
REG_SOURCE_TYPE_CODE	VARCHAR2	(30)	The source of the registration. This tells which type of party this registration has come from. Is this a partner or a reseller?
REGISTRATION_SOURCE_ID	NUMBER	(15)	This field ties in with the REG_SOURCE_TYPE_CODE. This ID is of the registration source. It could be party_id or vendor_id.
SOURCE_CODE	VARCHAR2	(30)	Source Code (of the source which led to this registration). Example, an event source code.
REGISTRATION_GROUP_ID	NUMBER		ID of the Group registering for the Event Offering.
REGISTRANT_PARTY_ID	NUMBER		ID of the Party registering for the Event Offering.
REGISTRANT_CUSTOMER_NAME	VARCHAR2	(360)
REGISTRANT_ACCOUNT_ID	NUMBER		Account ID of the Registrant, as defined in the Customer Model.
REGISTRANT_CONTACT_ID	NUMBER		Contact ID of the registrant as defined in the Customer Model.
REG_CONTACT_FIRST_NAME	VARCHAR2	(150)	First name of the Registrant.
REG_CONTACT_LAST_NAME	VARCHAR2	(150)	Last Name of the Registrant.
ATTENDANT_PARTY_ID	NUMBER		Part ID of the attendant as defined in the Customer Model.
ATTENDANT_CONTACT_ID	NUMBER		Contact ID of the Attendant as defined in the Customer Model.
ATTENDANT_ACCOUNT_ID	NUMBER		Account ID of the Attendant as defined in the Customer Model.
ORIGINAL_REGISTRANT_CONTACT_ID	NUMBER		This field is used when we substitute another Party for the current Registrant. We hold on to the contact ID of the original Registrant. This contact ID is as defined in the Customer Model.
PROSPECT_FLAG	VARCHAR2	(1)	Whether this registrant is a Prospect.
ATTENDED_FLAG	VARCHAR2	(1)	Whether the registrant has attended the Event Offering.
CONFIRMED_FLAG	VARCHAR2	(1)	For OSM upgrade. Tells whether the Registration is confirmed.
EVALUATED_FLAG	VARCHAR2	(1)	Whether the attendant returned the Evaluation Sheet or is there any evaluation obtained from this registrant.
ATTENDANCE_RESULT_CODE	VARCHAR2	(4000)	Attendance Result Code. These values are seeded.
WAITLISTED_PRIORITY	NUMBER	(15)	Waitlist priority number if this registrant was on the waitlist for this Event Offering.
TARGET_LIST_ID	NUMBER		List ID of the list from which the Registrant was taken from. This could have been an Invitee List.
INBOUND_MEDIA_ID	NUMBER		Channel through which the Inbound Call came in.
INBOUND_CHANNEL_ID	NUMBER		ID of the channel.
CANCELLATION_CODE	VARCHAR2	(30)	Cancellation Code.
CANCELLATION_REASON_CODE	VARCHAR2	(30)	Reason for Cancellation. The values are seeded.
ATTENDANCE_FAILURE_REASON	VARCHAR2	(30)	Reason why the registrant could not attend.
ATTENDANT_LANGUAGE	VARCHAR2	(4)	Language code of the Attendant's language.
SALESREP_ID	NUMBER		ID of the Salesrep who referred the Registrant.
ORDER_HEADER_ID	NUMBER		Order Header ID. This is the link to the order which was placed when this Registrant registered for this Event Offering.
ORDER_LINE_ID	NUMBER		Ties in with the Order Header ID.
DESCRIPTION	VARCHAR2	(4000)	General description or comments.
MAX_ATTENDEE_OVERRIDE_FLAG	VARCHAR2	(1)	Whether the Cal Center can override the MAXIMUM ATTENDEE in order to register the registrant. Can he / she be registered even if the Maximum Capacity has been reached?
INVITE_ONLY_OVERRIDE_FLAG	VARCHAR2	(1)	Can a person who is not on Invitee List be registered for this Invite-Only Event Offering?
PAYMENT_STATUS_CODE	VARCHAR2	(30)	Currently this is a seed value, the values are FREE and PAID.
PAYMENT_STATUS	VARCHAR2	(80)	Payment Status.
EVENT_JOIN_TIME	DATE
EVENT_EXIT_TIME	DATE
MEETING_ENCRYPTION_KEY_CODE	VARCHAR2	(150)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EVENT_REGISTRATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      APPLICATION_ID
,      OWNER_USER_ID
,      CONFIRMATION_CODE
,      EVENT_OFFER_ID
,      ACTIVE_FLAG
,      DATE_REGISTRATION_PLACED
,      USER_STATUS_ID
,      USER_STATUS
,      SYSTEM_STATUS_CODE
,      LAST_REG_STATUS_DATE
,      REG_SOURCE_TYPE_CODE
,      REGISTRATION_SOURCE_ID
,      SOURCE_CODE
,      REGISTRATION_GROUP_ID
,      REGISTRANT_PARTY_ID
,      REGISTRANT_CUSTOMER_NAME
,      REGISTRANT_ACCOUNT_ID
,      REGISTRANT_CONTACT_ID
,      REG_CONTACT_FIRST_NAME
,      REG_CONTACT_LAST_NAME
,      ATTENDANT_PARTY_ID
,      ATTENDANT_CONTACT_ID
,      ATTENDANT_ACCOUNT_ID
,      ORIGINAL_REGISTRANT_CONTACT_ID
,      PROSPECT_FLAG
,      ATTENDED_FLAG
,      CONFIRMED_FLAG
,      EVALUATED_FLAG
,      ATTENDANCE_RESULT_CODE
,      WAITLISTED_PRIORITY
,      TARGET_LIST_ID
,      INBOUND_MEDIA_ID
,      INBOUND_CHANNEL_ID
,      CANCELLATION_CODE
,      CANCELLATION_REASON_CODE
,      ATTENDANCE_FAILURE_REASON
,      ATTENDANT_LANGUAGE
,      SALESREP_ID
,      ORDER_HEADER_ID
,      ORDER_LINE_ID
,      DESCRIPTION
,      MAX_ATTENDEE_OVERRIDE_FLAG
,      INVITE_ONLY_OVERRIDE_FLAG
,      PAYMENT_STATUS_CODE
,      PAYMENT_STATUS
,      EVENT_JOIN_TIME
,      EVENT_EXIT_TIME
,      MEETING_ENCRYPTION_KEY_CODE
FROM APPS.AMS_EVENT_REGISTRATIONS_V;

Dependencies

[top of page]

APPS.AMS_EVENT_REGISTRATIONS_V references the following:

APPS: AMS_EVENT_REGISTRATIONS; AMS_LOOKUPS; AMS_USER_STATUSES_VL; HZ_PARTIES; HZ_RELATIONSHIPS

APPS.AMS_EVENT_REGISTRATIONS_V is referenced by following:

APPS: IEX_UWQ_SEL_PKG - show dependent code; OKL_UWQ_SEL_PKG - show dependent code