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_P_EVENT_OFFERS_V

Object Details

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

View Type

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.

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.AMS_P_EVENT_OFFERS_V references the following:

APPS: AMS_EVENT_OFFERS_ONLY_V; AMS_EVENT_REGISTRATIONS; AMS_JTF_RS_EMP_V; MTL_SYSTEM_ITEMS_KFV

APPS.AMS_P_EVENT_OFFERS_V is not referenced by any database object