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_EVENT_OFFERS_VL

Object Details

Object Name:	AMS_EVENT_OFFERS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_EVENT_OFFERS_VL
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view is created for the general information about marketing event offerings.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Unique identifier generated by database
EVENT_OFFER_ID	NUMBER		Yes	Unique Identifier.
SETUP_TYPE_ID	NUMBER			This field identifies the setup type for this Event.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
OBJECT_VERSION_NUMBER	NUMBER	(9)		This column is used for locking purposes. A way to implement Optimistic
APPLICATION_ID	NUMBER	(15)	Yes	Application Identifier.
EVENT_HEADER_ID	NUMBER			This Event Header ID is of that Master Event on which this Event Offering Row is based on.
PRIVATE_FLAG	VARCHAR2	(1)	Yes	This flag is used for security. The owner can mark this Event Offering as private and then no one else can see the details.
ACTIVE_FLAG	VARCHAR2	(1)	Yes	Used for soft-deletes. The Delete will make this flag as 'N'. The Select statement will pull only those rows for which this flag is 'Y'
SOURCE_CODE	VARCHAR2	(30)		Event Offering Source Code. This is mainly to track Responses to the Source. The Responses for this Event Offering will specify this Source Code.
EVENT_LEVEL	VARCHAR2	(30)	Yes	'MAIN' for the Event Offering rows. 'SUB' for the Event Offering Agenda Rows.
EVENT_TYPE_CODE	VARCHAR2	(30)		Type of the Event. For example, Seminar / Exhibition / Trade Show. These values are seeded. This value gets copied from the corresponding Master Event. The Marketer can change it.
USER_STATUS_ID	NUMBER		Yes	This field keeps track of the System Status for this Event. This field gets updated as and when the Event proceeds in the approval chain.
LAST_STATUS_DATE	DATE		Yes	This field ties in with USER_STATUS_ID. This date is the date when the USER_STATUS_ID was last changed.
SYSTEM_STATUS_CODE	VARCHAR2	(30)	Yes	This field ties in with the USER_STATUS_ID. Added to this table for ease of reporting.
EVENT_DELIVERY_METHOD_ID	NUMBER			Channel which is same as the 'Delivery Method' through which this Event Offering is to be delivered to the customers.
EVENT_REQUIRED_FLAG	VARCHAR2	(1)		This field is not currently in use.
EVENT_LANGUAGE_CODE	VARCHAR2	(30)		Main language for this Event Offering.
EVENT_VENUE_ID	NUMBER			This is used mainly for the Agenda Items for the Event Offering. This field points to the Venue for the Agenda Item.
EVENT_LOCATION_ID	NUMBER			Location for the Event Offering.
OVERFLOW_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether it is OK to allow more registrations than the number of currently available seats. This flag allows Marketer to schedule another offering if Overflow is allowed.
PARTNER_FLAG	VARCHAR2	(1)	Yes	This field is not used in this release. This is for the future use.
EVENT_STANDALONE_FLAG	VARCHAR2	(1)	Yes	This flag indicates whether this is Standalone which means a One-time Only Event. For a Standalone Event, the marketer will not see any difference between the Master Event and the corresponding Event Offering.
REG_FROZEN_FLAG	VARCHAR2	(1)	Yes	Indicates whether registration for this Event Offering is frozen. If this flag is 'Y', no more registration will be allowed.
REG_REQUIRED_FLAG	VARCHAR2	(1)	Yes	Marks whether Registration is required for this Event Offering. For Open-door, walk-in events. This flag will be equal to 'N'.
REG_CHARGE_FLAG	VARCHAR2	(1)	Yes	This flag indicates whether the Registrant / Attendee needs to pay for the Event.
REG_INVITED_ONLY_FLAG	VARCHAR2	(1)	Yes	This flag indicates whether the Registration is open for only those on the Invitee List.
REG_WAITLIST_ALLOWED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether Wait-list is allowed for this Event Offering.
REG_OVERBOOK_ALLOWED_FLAG	VARCHAR2	(1)	Yes	Tells whether it is OK to overbook this Event Offering.
AUTO_REGISTER_FLAG	VARCHAR2	(1)		Indicates whether it is OK to move the registrant from the waitlist and register him / her automatically for the Event Offering. If this flag is 'N', the registrant will get a notification requesting him / her to register for the Event Offering since he / she has now a seat available for the event.
PARENT_EVENT_OFFER_ID	NUMBER			This field is used only for the Agenda Item Rows. This field is the EVENT_OFFER_ID of the parent Event Offering for this Agenda Item Row.
EVENT_DURATION	NUMBER	(15)		Event Offering Duration. This is just a number. It makes sense when it is tied with the EVENT_DURATION_UOM_CODE.
EVENT_DURATION_UOM_CODE	VARCHAR2	(3)		Ties in with the EVENT_ DURATION_UOM. This is the Unit of Measure for the Duration of the Event Offering.
EVENT_START_DATE	DATE			Start Date of this Event Offering.
EVENT_START_DATE_TIME	DATE			This is mainly used for the Agenda Item Rows. This is the Start Time for the Agenda Item.
EVENT_END_DATE	DATE			End Date of the Event Offering.
EVENT_END_DATE_TIME	DATE			This is used mainly for the Agenda Item Rows. This is the End Time of the Agenda Item.
REG_START_DATE	DATE			Date when the Registrations Can start for this Event Offering.
REG_START_TIME	DATE			The time on the Registration Start Date, when the Registration can start.
REG_END_DATE	DATE			The Date when the Registration must stop.
REG_END_TIME	DATE			The Time on the REG_END_DATE when the Registration should stop.
REG_MAXIMUM_CAPACITY	NUMBER	(15)		Registration Maximum Capacity for this Event Offeringl. This field gets copied from the corresponding Master Event. The Marketer will be able to change it.
REG_OVERBOOK_PCT	NUMBER	(15)		If REG_OVERBOOK_ALLOWED_FLAG is 'Y'. This field defines the percentage of allowed Overbooking.
REG_EFFECTIVE_CAPACITY	NUMBER	(15)		This is a derived field. It tells the Effective Capacity, after looking at the REG_MAXIMUM_CAPACITY, REG_OVERBOOK_ALLOWED_FLAG and REG_OVERBOOK_PCT.
REG_WAITLIST_PCT	NUMBER	(15)		If REG_WAITLIST_ALLOWED_FLAG is 'Y', this field defines what is the percentage of entries allowed in the waitlist. This percentage is with respect to the REG_MAXIMUM_CAPACITY.
REG_MINIMUM_CAPACITY	NUMBER	(15)		Registration Minimum Capacity defined at the Event Offering level. This field gets copied from the corresponding Master Event. The Marketer will be able to change it.
REG_MINIMUM_REQ_BY_DATE	DATE			Date by which the Minimum Registration Capacity must be filled.
ORGANIZATION_ID	NUMBER	(32)		Ties in with the Inventory Item ID.
INVENTORY_ITEM_ID	NUMBER	(38)		This is the Inventory Item ID for the Event Offering when this Event Offering is charged for and the orders will then come against this Inventory Item ID. This is part of the Order Capture Integration.
PRICELIST_HEADER_ID	NUMBER			Pricelist Header ID of the Base Pricelist generated for this Event Offering.
PRICELIST_LINE_ID	NUMBER			Ties in with the Pricelist Header ID.
ORG_ID	NUMBER	(32)		This is for the multi-org. Organization Identifier.
WAITLIST_ACTION_TYPE_CODE	VARCHAR2	(30)		Action Type to be used when the Waitlist is prioritized. For example, it could be First-come-First-served.
STREAM_TYPE_CODE	VARCHAR2	(30)		Used only for Agenda Rows where EVENT_LEVEL is 'SUB'. This field marks the Agenda Item Stream Code.
OWNER_USER_ID	NUMBER		Yes	User ID of the Owner of the Event Offering.
EVENT_FULL_FLAG	VARCHAR2	(1)		Indicates whether the Event is filled to the capacity.
FORECASTED_REVENUE	NUMBER	(15)		Forecasted Revenue for this Event Offering.
ACTUAL_REVENUE	NUMBER	(15)		Actual Revenue for this Event Offering.
FORECASTED_COST	NUMBER	(15)		Forecasted Cost for this Event Offering.
ACTUAL_COST	NUMBER	(15)		Actual Cost for this Event Offering.
FUND_SOURCE_TYPE_CODE	VARCHAR2	(30)		Indicates what type of object is funding this Event Offering. It could be a Budget Fund, Campaign or the Master Event.
FUND_SOURCE_ID	NUMBER			Ties in with the FUND_SOURCE_TYPE_CODE. This will be the Source Code of the entity that funds this Event Offering.
FUND_AMOUNT_TC	NUMBER			Fund Amount in Transactional Currency.
FUND_AMOUNT_FC	NUMBER			Fund amount in Functional Currency.
CURRENCY_CODE_TC	VARCHAR2	(15)		Transactional Currency Code.
CURRENCY_CODE_FC	VARCHAR2	(15)		Functional Currency Code.
CERT_CREDIT_TYPE_CODE	VARCHAR2	(30)		If this Event Offering is part of one of the Certification Programs, this field denotes the Certification Credit Type for this event offering.
CERTIFICATION_CREDITS	NUMBER	(15)		If this Event Offering is part of one of the Certification Programs, this field denotes the number of Certification Credits the attendee will get after completely attending this Event Offering.
COORDINATOR_ID	NUMBER			This field is used mainly for Agenda Item rows. This field holds the user id of the Coordinator for this Agenda Item.
PRIORITY_TYPE_CODE	VARCHAR2	(30)		Priority of the Event Offering. This value is just recorded. There is no business logic around it.
CANCELLATION_REASON_CODE	VARCHAR2	(30)		If this Event Offering is cancelled for some reason, the cancellation reason is recorded here. The values are seeded.
URL	VARCHAR2	(4000)		URL associated with the Event Offering. This could be for the web site created for this Event Offering. This field gets copied from the corresponding Master Event. The Marketer can change it.
PHONE	VARCHAR2	(25)		Phone number for the customers to call in for this Event Offering. This field gets copied from the corresponding Master Event. The Marketer can change it.
EMAIL	VARCHAR2	(120)		email ID associated with this Event Offering. Customers can send emails to this email address to gain more information about the Event Offering. This field gets copied from the corresponding Master Event. The Marketer can change it.
TIMEZONE_ID	NUMBER	(15)		Time zone under which the Event Offering location falls in.
INBOUND_SCRIPT_NAME	VARCHAR2	(240)		The name of the questionnaire, which must be filled up by the call center when a customer calls in for this Event Offering. This field gets copied from the corresponding Master Event. The Marketer can change it.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfiled structure defining column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment.
EVENT_OFFER_NAME	VARCHAR2	(240)	Yes	Name of the event offer
DESCRIPTION	VARCHAR2	(4000)		Description of the event
EVENT_MKTG_MESSAGE	VARCHAR2	(4000)		The marketing message associated with this event
COUNTRY_CODE	VARCHAR2	(30)		Country code
BUSINESS_UNIT_ID	NUMBER			Identifier of the Business Unit this campaign belongs to
ACCOUNTS_CLOSED_FLAG	VARCHAR2	(1)		Flag to indicate whether the Account for this event offer is closed
EVENT_CALENDAR	VARCHAR2	(15)		Calendar Name
START_PERIOD_NAME	VARCHAR2	(15)		Starting period name within the Event calendar
END_PERIOD_NAME	VARCHAR2	(15)		Ending period name within the Event calendar
GLOBAL_FLAG	VARCHAR2	(1)		Is it a global Event Offer
TASK_ID	NUMBER			Task ID
PARENT_TYPE	VARCHAR2	(30)		Parent for One off event
PARENT_ID	NUMBER			Parent ID of one off event
CREATE_ATTENDANT_LEAD_FLAG	VARCHAR2	(1)		Create the Event attendee as a Lead
CREATE_REGISTRANT_LEAD_FLAG	VARCHAR2	(1)		Create Registrant as Lead
EVENT_OBJECT_TYPE	VARCHAR2	(30)		Hold Object type code of the event
REG_TIMEZONE_ID	NUMBER			Time Zone ID
EVENT_PASSWORD	VARCHAR2	(120)		This field holds password for Web based events, if the Event require any login
RECORD_EVENT_FLAG	VARCHAR2	(1)		Flag to indicate whether it is OK to Record the Event.
ALLOW_REGISTER_IN_MIDDLE_FLAG	VARCHAR2	(1)		Flag to Allow User to Flag to indicate whether it is OK to Register a person in the middle of the event
PUBLISH_ATTENDEES_FLAG	VARCHAR2	(1)		Flag to indicate whether it is OK to Publish the Attendees list
DIRECT_JOIN_FLAG	VARCHAR2	(1)		Flag to indicate whether it is OK to Join the event without registration
EVENT_NOTIFICATION_METHOD	VARCHAR2	(30)		This fleld will tell what type of notification to be sent out
ACTUAL_START_TIME	DATE			Start time of the Web based event
ACTUAL_END_TIME	DATE			End time of the Web based event
SERVER_ID	NUMBER			Sever where the event is conducted. This field used for WEB based events
OWNER_FND_USER_ID	NUMBER			Login User id for the session
MEETING_DIAL_IN_INFO	VARCHAR2	(4000)		Dial in information of the event
MEETING_EMAIL_SUBJECT	VARCHAR2	(4000)		If the Notification of the Event is through Email then this filed holds the text of the Subject field
MEETING_SCHEDULE_TYPE	VARCHAR2	(30)		Meeting Schedule type
MEETING_STATUS	VARCHAR2	(30)		Status of the meeting
PUBLISH_FLAG	VARCHAR2	(1)		Flag to indicate whether it is OK to publish the event for public
MEETING_ENCRYPTION_KEY_CODE	VARCHAR2	(150)		Encryption Key code for the password
MEETING_MISC_INFO	VARCHAR2	(4000)		Other information
NUMBER_OF_ATTENDEES	NUMBER	(15)		Number of Attendees
EVENT_PURPOSE_CODE	VARCHAR2	(30)		Objective of the event schedule

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      EVENT_OFFER_ID
,      SETUP_TYPE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      APPLICATION_ID
,      EVENT_HEADER_ID
,      PRIVATE_FLAG
,      ACTIVE_FLAG
,      SOURCE_CODE
,      EVENT_LEVEL
,      EVENT_TYPE_CODE
,      USER_STATUS_ID
,      LAST_STATUS_DATE
,      SYSTEM_STATUS_CODE
,      EVENT_DELIVERY_METHOD_ID
,      EVENT_REQUIRED_FLAG
,      EVENT_LANGUAGE_CODE
,      EVENT_VENUE_ID
,      EVENT_LOCATION_ID
,      OVERFLOW_FLAG
,      PARTNER_FLAG
,      EVENT_STANDALONE_FLAG
,      REG_FROZEN_FLAG
,      REG_REQUIRED_FLAG
,      REG_CHARGE_FLAG
,      REG_INVITED_ONLY_FLAG
,      REG_WAITLIST_ALLOWED_FLAG
,      REG_OVERBOOK_ALLOWED_FLAG
,      AUTO_REGISTER_FLAG
,      PARENT_EVENT_OFFER_ID
,      EVENT_DURATION
,      EVENT_DURATION_UOM_CODE
,      EVENT_START_DATE
,      EVENT_START_DATE_TIME
,      EVENT_END_DATE
,      EVENT_END_DATE_TIME
,      REG_START_DATE
,      REG_START_TIME
,      REG_END_DATE
,      REG_END_TIME
,      REG_MAXIMUM_CAPACITY
,      REG_OVERBOOK_PCT
,      REG_EFFECTIVE_CAPACITY
,      REG_WAITLIST_PCT
,      REG_MINIMUM_CAPACITY
,      REG_MINIMUM_REQ_BY_DATE
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      PRICELIST_HEADER_ID
,      PRICELIST_LINE_ID
,      ORG_ID
,      WAITLIST_ACTION_TYPE_CODE
,      STREAM_TYPE_CODE
,      OWNER_USER_ID
,      EVENT_FULL_FLAG
,      FORECASTED_REVENUE
,      ACTUAL_REVENUE
,      FORECASTED_COST
,      ACTUAL_COST
,      FUND_SOURCE_TYPE_CODE
,      FUND_SOURCE_ID
,      FUND_AMOUNT_TC
,      FUND_AMOUNT_FC
,      CURRENCY_CODE_TC
,      CURRENCY_CODE_FC
,      CERT_CREDIT_TYPE_CODE
,      CERTIFICATION_CREDITS
,      COORDINATOR_ID
,      PRIORITY_TYPE_CODE
,      CANCELLATION_REASON_CODE
,      URL
,      PHONE
,      EMAIL
,      TIMEZONE_ID
,      INBOUND_SCRIPT_NAME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      EVENT_OFFER_NAME
,      DESCRIPTION
,      EVENT_MKTG_MESSAGE
,      COUNTRY_CODE
,      BUSINESS_UNIT_ID
,      ACCOUNTS_CLOSED_FLAG
,      EVENT_CALENDAR
,      START_PERIOD_NAME
,      END_PERIOD_NAME
,      GLOBAL_FLAG
,      TASK_ID
,      PARENT_TYPE
,      PARENT_ID
,      CREATE_ATTENDANT_LEAD_FLAG
,      CREATE_REGISTRANT_LEAD_FLAG
,      EVENT_OBJECT_TYPE
,      REG_TIMEZONE_ID
,      EVENT_PASSWORD
,      RECORD_EVENT_FLAG
,      ALLOW_REGISTER_IN_MIDDLE_FLAG
,      PUBLISH_ATTENDEES_FLAG
,      DIRECT_JOIN_FLAG
,      EVENT_NOTIFICATION_METHOD
,      ACTUAL_START_TIME
,      ACTUAL_END_TIME
,      SERVER_ID
,      OWNER_FND_USER_ID
,      MEETING_DIAL_IN_INFO
,      MEETING_EMAIL_SUBJECT
,      MEETING_SCHEDULE_TYPE
,      MEETING_STATUS
,      PUBLISH_FLAG
,      MEETING_ENCRYPTION_KEY_CODE
,      MEETING_MISC_INFO
,      NUMBER_OF_ATTENDEES
,      EVENT_PURPOSE_CODE
FROM APPS.AMS_EVENT_OFFERS_VL;

Dependencies

[top of page]

APPS.AMS_EVENT_OFFERS_VL references the following:

APPS: AMS_EVENT_OFFERS_ALL_B; AMS_EVENT_OFFERS_ALL_TL

APPS.AMS_EVENT_OFFERS_VL is referenced by following:

APPS: AMS_ACT_LIST_PVT - show dependent code; AMS_AGENDAS_PVT - show dependent code; AMS_APPROVAL_PVT - show dependent code; AMS_APPROVAL_SUBMIT_PVT - show dependent code; AMS_APPROVAL_UTIL_PVT - show dependent code; AMS_CAMPAIGNRULES_PVT - show dependent code; AMS_CAMP_SCHEDULE_PVT - show dependent code; AMS_COPYACTIVITIES_PVT - show dependent code; AMS_COPYELEMENTS_PVT - show dependent code; AMS_CPYUTILITY_PVT - show dependent code; AMS_DELIVERABLE_PVT - show dependent code; AMS_EVENTHEADER_PVT - show dependent code; AMS_EVENTOFFER_PVT - show dependent code; AMS_EVENTSCHEDULE_COPY_PVT - show dependent code; AMS_EVENT_OBJECTS_COPY_PVT - show dependent code; AMS_EVENT_OFFERS_AGENDA_V; AMS_EVENT_OFFERS_ONLY_V; AMS_EVENT_OFFERS_OV_V; AMS_EVENT_OFFERS_REG_V; AMS_EVENT_OFFERS_V; AMS_EVHRULES_PVT - show dependent code; AMS_PROGRAM_COMPONENTS_V; AMS_P_CAMPAIGN_SCHEDS_V; AMS_P_EVENT_CAMPAIGNS_V; AMS_P_EVENT_DELIVERABLES_V; AMS_P_EVENT_REG_CONTACTS_V; AMS_P_EVENT_REG_ROSTER_V; AMS_P_OSO_SOURCE_CODES_V; AMS_P_SOURCE_CODES_V; AMS_SOURCE_CODES_DETAILS_V; AMS_UTILITY_PVT - show dependent code; AMS_WFCMPAPR_PVT - show dependent code; AMS_WFTRIG_PVT - show dependent code; AST_AMS_SOURCE_PKG - show dependent code; AST_EVENT_HISTORY_V; AST_EV_HIS_ORG_V; AST_EV_HIS_PER_V; AST_LM_EVENTS_SRC_V; AST_LM_EVENTS_V; AST_OFL_EVENT_ATTENDEES_PARAM - show dependent code; AST_OFL_EVENT_INFO_PARAM - show dependent code; AST_SOURCE_ONLY_V; BIM_DIMV_CHANNELS; BIM_DIMV_EVENT_HIER; BIM_DIMV_EVENT_OFFERS; BIM_DIMV_MEDIA_CHANNELS; BIM_EDW_EVENTS_M_SIZE - show dependent code; OZF_ACTBUDGETRULES_PVT - show dependent code; OZF_ACTBUDGETS_PVT - show dependent code; OZF_FUND_CHECKBOOK_V; OZF_FUND_EXTENSION_PVT - show dependent code; OZF_FUND_RECONCILE_PVT - show dependent code; OZF_UTILITY_PVT - show dependent code