[Home] [Help] [Dependency Information]
Object Name: | AMS_P_EVENT_REG_CONTACTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_P_EVENT_REG_CONTACTS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This is a public view to retrieve information on Registrant from Event Registrations.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_OFFER_ID | NUMBER | Yes | Unique identifier. | |
EVENT_OFFER_NAME | VARCHAR2 | (240) | Yes | Name of the event offered. |
EVENT_REGISTRATION_ID | NUMBER | Yes | Unique identifier. | |
CONFIRMATION_CODE | VARCHAR2 | (30) | Yes | Unique code representing confirmation status |
CANCELLATION_CODE | VARCHAR2 | (30) | Unique code representing cancellation status | |
REGISTRANT_PARTY_ID | NUMBER | Yes | Unique identifier | |
REGISTRANT_PARTY_NAME | VARCHAR2 | (360) | Yes | Name of the registering party |
REGISTRANT_ACCOUNT_ID | NUMBER | Unique identifier of the registering party account. | ||
REGISTRANT_CONTACT_ID | NUMBER | Yes | Unique code to registrant contact details. | |
REGISTRANT_CONTACT_NAME | VARCHAR2 | (0) | Name of the registrant | |
DATE_REGISTRATION_PLACED | DATE | Yes | Rgistration date | |
REGISTRATION_STATUS_ID | NUMBER | Yes | Unique identifier indicating registration status | |
REGISTRATION_STATUS_NAME | VARCHAR2 | (120) | Regsitration status. |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_OFFER_ID
, EVENT_OFFER_NAME
, EVENT_REGISTRATION_ID
, CONFIRMATION_CODE
, CANCELLATION_CODE
, REGISTRANT_PARTY_ID
, REGISTRANT_PARTY_NAME
, REGISTRANT_ACCOUNT_ID
, REGISTRANT_CONTACT_ID
, REGISTRANT_CONTACT_NAME
, DATE_REGISTRATION_PLACED
, REGISTRATION_STATUS_ID
, REGISTRATION_STATUS_NAME
FROM APPS.AMS_P_EVENT_REG_CONTACTS_V;
APPS.AMS_P_EVENT_REG_CONTACTS_V is not referenced by any database object
|
|
|