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

VIEW: AMS.AMS_EVENT_REGISTRATIONS#

Object Details
Object Name: AMS_EVENT_REGISTRATIONS#
Object Type: VIEW
Owner: AMS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
EVENT_REGISTRATION_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9)
APPLICATION_ID NUMBER (15) Yes
OWNER_USER_ID NUMBER
Yes
CONFIRMATION_CODE VARCHAR2 (30) Yes
EVENT_OFFER_ID NUMBER
Yes
ACTIVE_FLAG VARCHAR2 (1) Yes
DATE_REGISTRATION_PLACED DATE
Yes
USER_STATUS_ID NUMBER
Yes
SYSTEM_STATUS_CODE VARCHAR2 (30) Yes
LAST_REG_STATUS_DATE DATE
Yes
REG_SOURCE_TYPE_CODE VARCHAR2 (30)
REGISTRATION_SOURCE_ID NUMBER (15)
SOURCE_CODE VARCHAR2 (30)
REGISTRATION_GROUP_ID NUMBER

REGISTRANT_PARTY_ID NUMBER
Yes
REGISTRANT_ACCOUNT_ID NUMBER

REGISTRANT_CONTACT_ID NUMBER
Yes
ATTENDANT_PARTY_ID NUMBER

ATTENDANT_ACCOUNT_ID NUMBER

ATTENDANT_CONTACT_ID NUMBER
Yes
ORIGINAL_REGISTRANT_CONTACT_ID NUMBER
Yes
PROSPECT_FLAG VARCHAR2 (1) Yes
ATTENDED_FLAG VARCHAR2 (1) Yes
CONFIRMED_FLAG VARCHAR2 (1) Yes
EVALUATED_FLAG VARCHAR2 (1) Yes
ATTENDANCE_RESULT_CODE VARCHAR2 (4000)
WAITLISTED_PRIORITY NUMBER (15)
TARGET_LIST_ID NUMBER

INBOUND_MEDIA_ID NUMBER

INBOUND_CHANNEL_ID NUMBER

CANCELLATION_CODE VARCHAR2 (30)
CANCELLATION_REASON_CODE VARCHAR2 (30)
ATTENDANCE_FAILURE_REASON VARCHAR2 (30)
ATTENDANT_LANGUAGE VARCHAR2 (4)
SALESREP_ID NUMBER

ORDER_HEADER_ID NUMBER

ORDER_LINE_ID NUMBER

DESCRIPTION VARCHAR2 (4000)
MAX_ATTENDEE_OVERRIDE_FLAG VARCHAR2 (1)
INVITE_ONLY_OVERRIDE_FLAG VARCHAR2 (1)
PAYMENT_STATUS_CODE VARCHAR2 (30)
AUTO_REGISTER_FLAG VARCHAR2 (1)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
SECURITY_GROUP_ID NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

ATTENDEE_ROLE_TYPE VARCHAR2 (30)
NOTIFICATION_TYPE VARCHAR2 (30)
LAST_NOTIFIED_TIME DATE

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
,      SYSTEM_STATUS_CODE
,      LAST_REG_STATUS_DATE
,      REG_SOURCE_TYPE_CODE
,      REGISTRATION_SOURCE_ID
,      SOURCE_CODE
,      REGISTRATION_GROUP_ID
,      REGISTRANT_PARTY_ID
,      REGISTRANT_ACCOUNT_ID
,      REGISTRANT_CONTACT_ID
,      ATTENDANT_PARTY_ID
,      ATTENDANT_ACCOUNT_ID
,      ATTENDANT_CONTACT_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
,      AUTO_REGISTER_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTENDEE_ROLE_TYPE
,      NOTIFICATION_TYPE
,      LAST_NOTIFIED_TIME
,      EVENT_JOIN_TIME
,      EVENT_EXIT_TIME
,      MEETING_ENCRYPTION_KEY_CODE
FROM AMS.AMS_EVENT_REGISTRATIONS#;

Dependencies

[top of page]

AMS.AMS_EVENT_REGISTRATIONS# references the following:

SchemaAMS
TableAMS_EVENT_REGISTRATIONS
AMS.AMS_EVENT_REGISTRATIONS# is referenced by following:

SchemaAPPS
SynonymAMS_EVENT_REGISTRATIONS