[Home] [Help] [Dependency Information]
Object Name: | AMS_P_EVENT_REG_ROSTER_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_P_EVENT_REG_ROSTER_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 an Event Offering and its registrations.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_OFFER_ID | NUMBER | Yes | Uniques identifier | |
EVENT_OFFER_NAME | VARCHAR2 | (240) | Yes | Name of event offered |
EVENT_LOCATION_ID | NUMBER | Unique identifier for event location | ||
CITY | VARCHAR2 | (60) | Event location details | |
STATE | VARCHAR2 | (60) | Event location details | |
PROVINCE | VARCHAR2 | (60) | Event location details | |
COUNTRY | VARCHAR2 | (60) | Yes | Event location details |
EVENT_START_DATE | DATE | Start date of the event | ||
EVENT_START_TIME | DATE | Start time of the event | ||
EVENT_END_DATE | DATE | End date of the event | ||
EVENT_END_TIME | DATE | End time of the event | ||
REGISTRANT_PARTY_ID | NUMBER | Yes | Unique registration party identifier | |
REGISTRANT_PARTY_NAME | VARCHAR2 | (360) | Yes | Name of the registering party |
REGISTRANT_ACCOUNT_ID | NUMBER | Unique identifier for registering party expense | ||
REGISTRANT_CONTACT_ID | NUMBER | Yes | Unique registrant contact id | |
REGISTRANT_CONTACT_NAME | VARCHAR2 | (0) | Name of the registrant contact | |
EVENT_REGISTRATION_ID | NUMBER | Yes | Unique identifier for registration | |
CONFIRMATION_CODE | VARCHAR2 | (30) | Yes | Unique code to indicate confirmation status |
CANCELLATION_CODE | VARCHAR2 | (30) | Unique code to indicate cancellation status | |
WAITLIST_PRIORITY | NUMBER | (15) | Indicates priority for waitlisted registrants | |
REGISTRATION_STATUS_ID | NUMBER | Yes | Unique registration status identifier | |
REG_STATUS_CODE | VARCHAR2 | (30) | Yes | Unique code indicating registration status |
REG_STATUS_NAME | VARCHAR2 | (120) | Resgistration status description | |
REGISTRATION_GROUP_ID | NUMBER | Unique registration group identifier | ||
INVENTORY_ITEM_ID | NUMBER | (38) | Unique operating inventory item identifier | |
ORDER_HEADER_ID | NUMBER | Unique identifier for the header of the order for this event | ||
ORDER_LINE_ID | NUMBER | Unique identifier for the line information of the order for this event |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_OFFER_ID
, EVENT_OFFER_NAME
, EVENT_LOCATION_ID
, CITY
, STATE
, PROVINCE
, COUNTRY
, EVENT_START_DATE
, EVENT_START_TIME
, EVENT_END_DATE
, EVENT_END_TIME
, REGISTRANT_PARTY_ID
, REGISTRANT_PARTY_NAME
, REGISTRANT_ACCOUNT_ID
, REGISTRANT_CONTACT_ID
, REGISTRANT_CONTACT_NAME
, EVENT_REGISTRATION_ID
, CONFIRMATION_CODE
, CANCELLATION_CODE
, WAITLIST_PRIORITY
, REGISTRATION_STATUS_ID
, REG_STATUS_CODE
, REG_STATUS_NAME
, REGISTRATION_GROUP_ID
, INVENTORY_ITEM_ID
, ORDER_HEADER_ID
, ORDER_LINE_ID
FROM APPS.AMS_P_EVENT_REG_ROSTER_V;
APPS.AMS_P_EVENT_REG_ROSTER_V is not referenced by any database object
|
|
|