[Home] [Help] [Dependency Information]
Object Name: | AMS_P_EVENT_OFFERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_P_EVENT_OFFERS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This is a public view created for the general information about marketing event offerings.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_HEADER_ID | CHAR | (0) | Unique identifier | |
EVENT_HEADER_NAME | CHAR | (0) | Name of the event header | |
EVENT_HEADER_DESCRIPTION | CHAR | (0) | Description of the event header information | |
EVENT_HEADER_SOURCE_CODE | CHAR | (0) | Unique code to identify the source of the event header | |
EVENT_HEADER_TYPE_CODE | CHAR | (0) | Unique code to identify event header type. | |
EVENT_OFFER_ID | NUMBER | Yes | Unique identifier | |
EVENT_OFFER_NAME | VARCHAR2 | (240) | Yes | Name of the event offered |
EVENT_OFFER_DESCRIPTION | VARCHAR2 | (4000) | Description of the event offered | |
EVENT_OFFER_SOURCE_CODE | VARCHAR2 | (30) | Unique code to identify the source of the event offer | |
EVENT_OFFER_TYPE_CODE | VARCHAR2 | (30) | Unique code to identify the type of the event offer | |
EVO_INV_ITEM_ID | NUMBER | (38) | Unique operating inventory item identifier | |
EVO_INV_ITEM_NUMBER | VARCHAR2 | (40) | Number of the operating inventory item | |
EVO_PRICELIST_ID | CHAR | (0) | Unique operating pricelist identifier | |
EVO_PRICELIST_NAME | CHAR | (0) | Name of the operating pricelist. | |
EVO_PRICELIST_LINE_ID | CHAR | (0) | Unique operating line item pricelist identifier | |
EVO_PRICELIST_CURRENCY_CODE | CHAR | (0) | Currency Code for Pricelist List price | |
EVO_LIST_PRICE | CHAR | (0) | List price of the event | |
EVO_LOCATION_ID | NUMBER | Unique operating location identifier | ||
EVO_LOCATION_TIMEZONE | VARCHAR2 | (80) | Time zone the event is being held | |
EVO_CITY | VARCHAR2 | (60) | Event location details | |
EVO_STATE | VARCHAR2 | (60) | Event Location Details | |
EVO_COUNTRY | VARCHAR2 | (60) | Event location details | |
EVO_LEVEL | VARCHAR2 | (30) | Yes | Level of the event held |
EVO_USER_STATUS_CODE | VARCHAR2 | (120) | Unique code to identify user status code | |
EVO_USER_STATUS_ID | NUMBER | Yes | Unique identifier of the user status | |
EVO_SYSTEM_STATUS_CODE | VARCHAR2 | (30) | Yes | Unique code to identify system status |
EVO_DELIVERY_METHOD_ID | NUMBER | Unique identifier for delivery methods | ||
EVO_DELIVERY_MEDIA_ID | NUMBER | Unique identifier for delivery media | ||
EVO_DELIVERY_METHOD_CODE | VARCHAR2 | (30) | Name of the delivery media | |
EVO_LANGUAGE_CODE | VARCHAR2 | (30) | Unique code to identify the language in which this event is held. | |
EVO_LANGUAGE_NAME | VARCHAR2 | (30) | Name of the language in which the event is held. | |
EVO_URL | VARCHAR2 | (4000) | Internet address of the event | |
EVO_COORDINATOR_ID | NUMBER | Unique identifier of the event coordinator | ||
EVO_COORDINATOR_NAME | VARCHAR2 | (360) | Name of the event coordinator | |
EVO_PRIORITY | VARCHAR2 | (30) | Priority of the event. | |
EVO_CERTIFICATION_TYPE | VARCHAR2 | (30) | Unique type identifying certification types | |
EVO_CERTIFICATION_CREDITS | NUMBER | (15) | Identifies credits the event attendee is due towards registration fees. | |
EVO_DURATION | NUMBER | (15) | Duration of the event | |
EVO_DURATION_UOM_CODE | VARCHAR2 | (3) | Unique code that identifies if the event is held in days, hours, weeks etc. | |
EVO_START_DATE | DATE | Start date of the event | ||
EVO_START_DATE_TIME | DATE | Start time of the event | ||
EVO_END_DATE | DATE | End date of the event | ||
EVO_END_DATE_TIME | DATE | End time of the event | ||
EVO_REG_START_DATE | DATE | Start date of the event registration | ||
EVO_REG_START_DATE_TIME | DATE | Start time of the event registration | ||
EVO_REG_END_DATE | DATE | End date of the event registration | ||
EVO_REG_END_DATE_TIME | DATE | End time of the event registration | ||
REG_EFFECTIVE_CAPACITY | NUMBER | (15) | Actual capacity of the event attendees | |
REG_MINIMUM_CAPACITY | NUMBER | (15) | Miniumum capacity required for the event to be held | |
REG_MINIMUM_REQ_BY_DATE | DATE | Minimum date the event registration should begin | ||
STREAM_TYPE_CODE | VARCHAR2 | (30) | Unique code that identifies the event stream | |
EVENT_STANDALONE_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if this is a one time only event |
REG_FROZEN_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if the registration has stopped |
REG_REQUIRED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if attendees are required to register for this event |
REG_CHARGE_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if payment if required for this event |
REG_INVITED_ONLY_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if attendance for this event is by invitation only. |
REG_WAITLIST_ALLOWED_FLAG | VARCHAR2 | (1) | Yes | Indicates if waitlist is allowed |
REG_OVERBOOK_ALLOWED_FLAG | VARCHAR2 | (1) | Yes | Indicates if overbooking is allowed |
REG_NUMBER_ENROLLED | NUMBER | Indicates the total number enrolled for the event | ||
REG_NUMBER_WAITLISTED | NUMBER | Number of registrants waitlisted | ||
REG_NUMBER_AVAILABLE | NUMBER | Number of available seats | ||
REG_NUMBER_REGISTERED | NUMBER | Number of registrants | ||
REG_NUMBER_CANCELLED | NUMBER | Number of Cancelled Registrations | ||
REG_NUMBER_ATTENDED | NUMBER | Number of Registrants attended |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_HEADER_ID
, EVENT_HEADER_NAME
, EVENT_HEADER_DESCRIPTION
, EVENT_HEADER_SOURCE_CODE
, EVENT_HEADER_TYPE_CODE
, EVENT_OFFER_ID
, EVENT_OFFER_NAME
, EVENT_OFFER_DESCRIPTION
, EVENT_OFFER_SOURCE_CODE
, EVENT_OFFER_TYPE_CODE
, EVO_INV_ITEM_ID
, EVO_INV_ITEM_NUMBER
, EVO_PRICELIST_ID
, EVO_PRICELIST_NAME
, EVO_PRICELIST_LINE_ID
, EVO_PRICELIST_CURRENCY_CODE
, EVO_LIST_PRICE
, EVO_LOCATION_ID
, EVO_LOCATION_TIMEZONE
, EVO_CITY
, EVO_STATE
, EVO_COUNTRY
, EVO_LEVEL
, EVO_USER_STATUS_CODE
, EVO_USER_STATUS_ID
, EVO_SYSTEM_STATUS_CODE
, EVO_DELIVERY_METHOD_ID
, EVO_DELIVERY_MEDIA_ID
, EVO_DELIVERY_METHOD_CODE
, EVO_LANGUAGE_CODE
, EVO_LANGUAGE_NAME
, EVO_URL
, EVO_COORDINATOR_ID
, EVO_COORDINATOR_NAME
, EVO_PRIORITY
, EVO_CERTIFICATION_TYPE
, EVO_CERTIFICATION_CREDITS
, EVO_DURATION
, EVO_DURATION_UOM_CODE
, EVO_START_DATE
, EVO_START_DATE_TIME
, EVO_END_DATE
, EVO_END_DATE_TIME
, EVO_REG_START_DATE
, EVO_REG_START_DATE_TIME
, EVO_REG_END_DATE
, EVO_REG_END_DATE_TIME
, REG_EFFECTIVE_CAPACITY
, REG_MINIMUM_CAPACITY
, REG_MINIMUM_REQ_BY_DATE
, STREAM_TYPE_CODE
, EVENT_STANDALONE_FLAG
, REG_FROZEN_FLAG
, REG_REQUIRED_FLAG
, REG_CHARGE_FLAG
, REG_INVITED_ONLY_FLAG
, REG_WAITLIST_ALLOWED_FLAG
, REG_OVERBOOK_ALLOWED_FLAG
, REG_NUMBER_ENROLLED
, REG_NUMBER_WAITLISTED
, REG_NUMBER_AVAILABLE
, REG_NUMBER_REGISTERED
, REG_NUMBER_CANCELLED
, REG_NUMBER_ATTENDED
FROM APPS.AMS_P_EVENT_OFFERS_V;
APPS.AMS_P_EVENT_OFFERS_V is not referenced by any database object
|
|
|