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]

TABLE: AMS.AMS_EVENT_HEADERS_ALL_B

Object Details

Object Name:	AMS_EVENT_HEADERS_ALL_B
Object Type:	TABLE
Owner:	AMS
FND Design Data:	AMS.AMS_EVENT_HEADERS_ALL_B
Subobject Name:
Status:	VALID

AMS_EVENT_HEADERS_ALL_B stores the definition of an Event. An event could be a seminar, class or an Exhibition. This table only holds the Events definition and could be seen as form of template. This table contains certain base information that is copied to the Event Offer as default information.The Event Offering is the one that is offered and used by a Channel or for which a person register.
This table also holds the Master Event Agenda details.
These agenda details get copied as the Agenda for the corresponding Event Offerings. User then changes the agenda details for the Event Offerings.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_EVENT_HEADERS_ALL_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EVENT_HEADER_ID
AMS_EVENT_HEADERS_ALL_B_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SOURCE_CODE
AMS_EVENT_HEADERS_ALL_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EVENT_TYPE_CODE
AMS_EVENT_HEADERS_ALL_B_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SETUP_TYPE_ID
AMS_EVENT_HEADERS_ALL_B_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATE_DATE
AMS_EVENT_HEADERS_ALL_B_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SYSTEM_STATUS_CODE
AMS_EVENT_HEADERS_ALL_B_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROGRAM_ID
AMS_EVENT_HEADERS_ALL_B_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	USER_STATUS_ID
AMS_EVENT_HEADERS_ALL_B_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DURATION_UOM_CODE
AMS_EVENT_HEADERS_ALL_B_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INBOUND_SCRIPT_NAME
AMS_EVENT_HEADERS_ALL_B_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OWNER_USER_ID
AMS_EVENT_HEADERS_ALL_B_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLICATION_ID
AMS_EVENT_HEADERS_ALL_B_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_ID
AMS_EVENT_HEADERS_ALL_B_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_EVENT_HEADER_ID
AMS_EVENT_HEADERS_ALL_B_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EVENT_HEADER_ID	NUMBER		Yes	Unique identifier.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
SETUP_TYPE_ID	NUMBER			This field identifies the setup type for this Event.
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 Locking.
EVENT_LEVEL	VARCHAR2	(30)	Yes	'MAIN' or 'SUB'. MAIN for the Master Event Row. SUB for the Agenda Row.
APPLICATION_ID	NUMBER	(15)	Yes	Application identifier.
EVENT_TYPE_CODE	VARCHAR2	(30)		Type of the Event. For example, Seminar / Exhibition / Trade Show. These values are seeded. This value gets copied to corresponding Event Offerings. The Marketer can change it at the Event Offering level.
ACTIVE_FLAG	VARCHAR2	(1)		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'
PRIVATE_FLAG	VARCHAR2	(1)		This flag is used for security. The owner can mark this Events as private and then no one else can see this Event.
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.
SYSTEM_STATUS_CODE	VARCHAR2	(30)	Yes	This field ties in with the USER_STATUS_ID. Added to this table for ease of reporting.
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.
STREAM_TYPE_CODE	VARCHAR2	(30)		Used only for Agenda Rows where EVENT_LEVEL is 'SUB'. This field marks the Agenda Item Stream Code.
SOURCE_CODE	VARCHAR2	(30)		Master Event Source Code. This is mainly to track Responses to the Source. The Responses for this Event will specify this Source Code.
EVENT_STANDALONE_FLAG	VARCHAR2	(1)		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.
DAY_OF_EVENT	VARCHAR2	(30)		This field is used only for the Agenda Rows where EVENT_LEVEL is 'SUB'. This field specifies the Day of the Event. Day One, Day Two and so on.
AGENDA_START_TIME	DATE			This field is used only for the Agenda Rows where EVENT_LEVEL is 'SUB'. Agenda Item Start Time is stored here.
AGENDA_END_TIME	DATE			This field is used only for the Agenda Rows where EVENT_LEVEL is 'SUB'. Agenda Item End Time is stored here.
REG_REQUIRED_FLAG	VARCHAR2	(1)	Yes	Marks whether Registration is required for this Event. 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.
PARTNER_FLAG	VARCHAR2	(1)	Yes	This field is not used in this release. This is for the future use.
OVERFLOW_FLAG	VARCHAR2	(1)		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 of the same event if Overflow is allowed.
PARENT_EVENT_HEADER_ID	NUMBER			This field is used only for the Agenda Rows where EVENT_LEVEL is 'SUB'. This field ties the Agenda Items with it's parent Master Event.
DURATION	NUMBER	(15)		Event Duration. This is just a number. It makes sense when it is tied with the DURATION_UOM_CODE.
DURATION_UOM_CODE	VARCHAR2	(3)		Ties in with the DURATION_UOM. This is the Unit of Measure for the Duration of the Event.
ACTIVE_FROM_DATE	DATE			This is the date when the Master Event will be active from.
ACTIVE_TO_DATE	DATE			This is the date when the Master Event will be active up to. All the corresponding Event Offering dates should be within the ACTIVE_FORM_DATE and ACTIVE_TO_DATE for it's parent Master Event.
REG_MAXIMUM_CAPACITY	NUMBER	(15)		Registration Maximum Capacity defined at the Master Event level. This field gets copied to the corresponding Event Offerings. The Marketer will be able to change the Maximum Registration Capacity for each of the Event Offerings.
REG_MINIMUM_CAPACITY	NUMBER	(15)		Registration Minimum Capacity defined at the Master Event level. This field gets copied to the corresponding Event Offerings. The Marketer will be able to change the Minimum Registration Capacity for each of the Event Offerings.
MAIN_LANGUAGE_CODE	VARCHAR2	(4)		Main Language Code for the Master Event.
CERT_CREDIT_TYPE_CODE	VARCHAR2	(30)		If this Event is part of one of the Certification Programs, this field denotes the Caertification Credit Type for this event.
CERTIFICATION_CREDITS	NUMBER	(15)		If this Event 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.
INVENTORY_ITEM_ID	NUMBER	(38)		This is the Inventory Item ID for the Master Event when this Master Event is charged for and the orders will then come against this Inventory Item ID. This is part of the Order Capture Integration.
ORGANIZATION_ID	NUMBER	(32)		This field ties in with the Inventory Item ID.
ORG_ID	NUMBER	(32)		This is for the multi-org. Organization ID.
FORECASTED_REVENUE	NUMBER	(15)		Forecasted Revenue for the Master Event.
ACTUAL_REVENUE	NUMBER	(15)		Actual Revenue for the Master Event.
FORECASTED_COST	NUMBER	(15)		Forecasted Cost for this Master Event.
ACTUAL_COST	NUMBER	(15)		Actual Cost for this Master Event.
COORDINATOR_ID	NUMBER			This field is used only for the Agenda Rows. For the rows where EVENT_LEVEL is 'SUB'. This is the Coordinator for the Agenda Item.
FUND_SOURCE_TYPE_CODE	VARCHAR2	(30)		Indicates what type of object is funding this Master Event. It could be a Budget Fund, Campaign or another 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 Master Event.
FUND_AMOUNT_TC	NUMBER			Allocated Fund Amount in Transactional Currency.
CURRENCY_CODE_TC	VARCHAR2	(15)		Transactional Currency Code.
FUND_AMOUNT_FC	NUMBER			Allocated Fund Amount. In Functional Currency.
CURRENCY_CODE_FC	VARCHAR2	(15)		Functional Currency Code.
OWNER_USER_ID	NUMBER		Yes	User ID of the Owner of the Master Event.
PRIORITY_TYPE_CODE	VARCHAR2	(30)		Master Event Priority. This value is just recorded. There is no business logic around it.
CANCELLATION_REASON_CODE	VARCHAR2	(30)		When the Master Event is cancelled, the cancellation reason is recorded here. These values are seeded.
PHONE	VARCHAR2	(25)		Phone number for the customers to call in for this Master Event. This field gets copied to the corresponding Event Offerings. The Marketer can change it for each Event Offering.
EMAIL	VARCHAR2	(120)		email ID associated with this Master Event. Customers can send emails to this email address to gain more information about the Event. This field gets copied to the corresponding Event Offerings. The Marketer can change it for each Event Offering.
URL	VARCHAR2	(4000)		URL associated with the Master Event. This could be for the web site created for this Master Event. This field gets copied to the corresponding Event Offerings. The Marketer can change it for each Event Offering.
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 Master Event. This field gets copied to the corresponding Event Offerings. The Marketer can change it for each Event Offering.
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.
SECURITY_GROUP_ID	VARCHAR2	(240)		Used in hosted environments
COUNTRY_CODE	VARCHAR2	(30)		Country code
BUSINESS_UNIT_ID	NUMBER			Identifier of the Business Unit this event belongs to
ACCOUNTS_CLOSED_FLAG	VARCHAR2	(1)		Flag to indicate whether the Accounts for the Event or closed
EVENT_CALENDAR	VARCHAR2	(15)		Event Calendar
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)		Flag to indicate if the Event is run globally.
EVH_SCHEDULE_ID	NUMBER			Obsolete
PROGRAM_ID	NUMBER			Program ID
TASK_ID	NUMBER			TASK ID used to create a task for calendar
CREATE_ATTENDANT_LEAD_FLAG	VARCHAR2	(1)		Create the Event attendee as a Lead
CREATE_REGISTRANT_LEAD_FLAG	VARCHAR2	(1)		Create Registrant as Lead
EVENT_PURPOSE_CODE	VARCHAR2	(30)		Holds the purpose code for the event

Query Text

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


SELECT EVENT_HEADER_ID
,      LAST_UPDATE_DATE
,      SETUP_TYPE_ID
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      EVENT_LEVEL
,      APPLICATION_ID
,      EVENT_TYPE_CODE
,      ACTIVE_FLAG
,      PRIVATE_FLAG
,      USER_STATUS_ID
,      SYSTEM_STATUS_CODE
,      LAST_STATUS_DATE
,      STREAM_TYPE_CODE
,      SOURCE_CODE
,      EVENT_STANDALONE_FLAG
,      DAY_OF_EVENT
,      AGENDA_START_TIME
,      AGENDA_END_TIME
,      REG_REQUIRED_FLAG
,      REG_CHARGE_FLAG
,      REG_INVITED_ONLY_FLAG
,      PARTNER_FLAG
,      OVERFLOW_FLAG
,      PARENT_EVENT_HEADER_ID
,      DURATION
,      DURATION_UOM_CODE
,      ACTIVE_FROM_DATE
,      ACTIVE_TO_DATE
,      REG_MAXIMUM_CAPACITY
,      REG_MINIMUM_CAPACITY
,      MAIN_LANGUAGE_CODE
,      CERT_CREDIT_TYPE_CODE
,      CERTIFICATION_CREDITS
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      ORG_ID
,      FORECASTED_REVENUE
,      ACTUAL_REVENUE
,      FORECASTED_COST
,      ACTUAL_COST
,      COORDINATOR_ID
,      FUND_SOURCE_TYPE_CODE
,      FUND_SOURCE_ID
,      FUND_AMOUNT_TC
,      CURRENCY_CODE_TC
,      FUND_AMOUNT_FC
,      CURRENCY_CODE_FC
,      OWNER_USER_ID
,      PRIORITY_TYPE_CODE
,      CANCELLATION_REASON_CODE
,      PHONE
,      EMAIL
,      URL
,      INBOUND_SCRIPT_NAME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      COUNTRY_CODE
,      BUSINESS_UNIT_ID
,      ACCOUNTS_CLOSED_FLAG
,      EVENT_CALENDAR
,      START_PERIOD_NAME
,      END_PERIOD_NAME
,      GLOBAL_FLAG
,      EVH_SCHEDULE_ID
,      PROGRAM_ID
,      TASK_ID
,      CREATE_ATTENDANT_LEAD_FLAG
,      CREATE_REGISTRANT_LEAD_FLAG
,      EVENT_PURPOSE_CODE
FROM AMS.AMS_EVENT_HEADERS_ALL_B;

Dependencies

[top of page]

AMS.AMS_EVENT_HEADERS_ALL_B does not reference any database object

AMS.AMS_EVENT_HEADERS_ALL_B is referenced by following:

APPS: AMS_EVENT_HEADERS_ALL_B