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_HEADERS_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Unique identifier generated by the database
EVENT_HEADER_ID	NUMBER		Yes	Unique identifier.
EVENT_HEADER_NAME	VARCHAR2	(240)	Yes	Name of the event header
EVENT_MKTG_MESSAGE	VARCHAR2	(4000)		Marketing message associated with the event
DESCRIPTION	VARCHAR2	(4000)		Description of the 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)		Unique number used for locking purposes
EVENT_LEVEL	VARCHAR2	(30)	Yes	Level of the event
APPLICATION_ID	NUMBER	(15)	Yes	Unique identifier
EVENT_TYPE_CODE	VARCHAR2	(30)		Unique code
EVENT_TYPE	VARCHAR2	(80)		Type of the event
ACTIVE_FLAG	VARCHAR2	(1)		Indicates the state of the event
PRIVATE_FLAG	VARCHAR2	(1)		Indicates if the event is confidential
USER_STATUS_ID	NUMBER		Yes	Unique identifier
USER_STATUS	VARCHAR2	(120)		Status of the event user
SYSTEM_STATUS_CODE	VARCHAR2	(30)	Yes	Unique code used across systems
LAST_STATUS_DATE	DATE		Yes	Date of last user status
STREAM_TYPE_CODE	VARCHAR2	(30)		Unique code used across systems
SOURCE_CODE	VARCHAR2	(30)		Unique code identifying event source
EVENT_STANDALONE_FLAG	VARCHAR2	(1)		Indicates if the event is standalone.
DAY_OF_EVENT	VARCHAR2	(30)		Day the event takes place
AGENDA_START_TIME	DATE			Start time of the event agenda.
AGENDA_END_TIME	DATE			Time the event agenda ends.
REG_REQUIRED_FLAG	VARCHAR2	(1)	Yes	Indicates if registration is mandatory for this event
FUND_SOURCE_TYPE	VARCHAR2	(30)		Unique code to identify the event fund source
FUND_SOURCE_ID	NUMBER			Unique identifier
FUND_SOURCE_NAME	VARCHAR2	(30)		Name of the fund source.
FUND_AMOUNT_TC	NUMBER			Transactional fund amount
FUND_AMOUNT_FC	NUMBER			Functional fund amount
CURRENCY_CODE_TC	VARCHAR2	(15)		Transactional currency code
CURRENCY_CODE_FC	VARCHAR2	(15)		Functional currency code
OWNER_USER_ID	NUMBER		Yes	Unique identifier
URL	VARCHAR2	(4000)		Internet address of the event
PHONE	VARCHAR2	(25)		Contact phone
EMAIL	VARCHAR2	(120)		Contact electronic mail
PRIORITY_CODE	VARCHAR2	(30)		Unique code identifying event priority.
INBOUND_SCRIPT_NAME	VARCHAR2	(240)		Inbound script name
REG_INVITED_ONLY_FLAG	VARCHAR2	(1)	Yes	Indicates if the event is invitational
PARTNER_FLAG	VARCHAR2	(1)	Yes	Indicates partner involvement in the event.
OVERFLOW_FLAG	VARCHAR2	(1)		Indicates if registration overflow is allowed on this event.
DURATION	NUMBER	(15)		Duration of the event
DURATION_UOM_CODE	VARCHAR2	(3)		Unique code
ACTIVE_FROM_DATE	DATE			Date the event is active from.
ACTIVE_TO_DATE	DATE			Date the event is active to.
REG_MAXIMUM_CAPACITY	NUMBER	(15)		Maximum registration capacity for this event.
REG_MINIMUM_CAPACITY	NUMBER	(15)		Minimum registration capacity for the event.
MAIN_LANGUAGE_CODE	VARCHAR2	(4)		Identifies the event language code.
MAIN_LANGUAGE	VARCHAR2	(30)		Identifies the event language.
CERTIFICATION_CREDIT_TYPE_CODE	VARCHAR2	(30)		Identifies the certification credit type.
CERTIFICATION_CREDITS	NUMBER	(15)		Number of certification credits applicable.
FORECASTED_REVENUE	NUMBER	(15)		Forecasted revenue
ACTUAL_REVENUE	NUMBER	(15)		Actual revenue
FORECASTED_COST	NUMBER	(15)		Forecasted cost
ACTUAL_COST	NUMBER	(15)		Actual cost
COORDINATOR_ID	NUMBER			Co-ordinator unique identifier
REG_CHARGE_FLAG	VARCHAR2	(1)	Yes	Indicates the charge applicable for the event.
CANCELLATION_REASON_CODE	VARCHAR2	(30)		Unique code identifying the cancellation reason.
ORGANIZATION_ID	NUMBER	(32)		Operating unit identifier.
INVENTORY_ITEM_ID	NUMBER	(38)		Operating inventory item identifier
COUNTRY_CODE	VARCHAR2	(30)		Country Code
BUSINESS_UNIT_ID	NUMBER			Business Unit ID
ACCOUNTS_CLOSED_FLAG	VARCHAR2	(1)		Are accounts closed for this event?
EVENT_CALENDAR	VARCHAR2	(15)		Event Calendder Name
START_PERIOD_NAME	VARCHAR2	(15)		Start Period Name
END_PERIOD_NAME	VARCHAR2	(15)		End Period Name
GLOBAL_FLAG	VARCHAR2	(1)		Flag to indicate how to generate source code.
SETUP_TYPE_ID	NUMBER			Custom Setup Type Id
PROGRAM_ID	NUMBER			Profram Id
TASK_ID	NUMBER			Task Id
CREATE_ATTENDANT_LEAD_FLAG	VARCHAR2	(1)		The flag to indicate attendent as a lead
CREATE_REGISTRANT_LEAD_FLAG	VARCHAR2	(1)		Flag to indicate Registant as a lead
EVENT_PURPOSE_CODE	VARCHAR2	(30)		Purpose code of the event

Query Text

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


SELECT ROW_ID
,      EVENT_HEADER_ID
,      EVENT_HEADER_NAME
,      EVENT_MKTG_MESSAGE
,      DESCRIPTION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      EVENT_LEVEL
,      APPLICATION_ID
,      EVENT_TYPE_CODE
,      EVENT_TYPE
,      ACTIVE_FLAG
,      PRIVATE_FLAG
,      USER_STATUS_ID
,      USER_STATUS
,      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
,      FUND_SOURCE_TYPE
,      FUND_SOURCE_ID
,      FUND_SOURCE_NAME
,      FUND_AMOUNT_TC
,      FUND_AMOUNT_FC
,      CURRENCY_CODE_TC
,      CURRENCY_CODE_FC
,      OWNER_USER_ID
,      URL
,      PHONE
,      EMAIL
,      PRIORITY_CODE
,      INBOUND_SCRIPT_NAME
,      REG_INVITED_ONLY_FLAG
,      PARTNER_FLAG
,      OVERFLOW_FLAG
,      DURATION
,      DURATION_UOM_CODE
,      ACTIVE_FROM_DATE
,      ACTIVE_TO_DATE
,      REG_MAXIMUM_CAPACITY
,      REG_MINIMUM_CAPACITY
,      MAIN_LANGUAGE_CODE
,      MAIN_LANGUAGE
,      CERTIFICATION_CREDIT_TYPE_CODE
,      CERTIFICATION_CREDITS
,      FORECASTED_REVENUE
,      ACTUAL_REVENUE
,      FORECASTED_COST
,      ACTUAL_COST
,      COORDINATOR_ID
,      REG_CHARGE_FLAG
,      CANCELLATION_REASON_CODE
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      COUNTRY_CODE
,      BUSINESS_UNIT_ID
,      ACCOUNTS_CLOSED_FLAG
,      EVENT_CALENDAR
,      START_PERIOD_NAME
,      END_PERIOD_NAME
,      GLOBAL_FLAG
,      SETUP_TYPE_ID
,      PROGRAM_ID
,      TASK_ID
,      CREATE_ATTENDANT_LEAD_FLAG
,      CREATE_REGISTRANT_LEAD_FLAG
,      EVENT_PURPOSE_CODE
FROM APPS.AMS_EVENT_HEADERS_V;

Dependencies

[top of page]

APPS.AMS_EVENT_HEADERS_V references the following:

APPS: AMS_EVENT_HEADERS_VL; AMS_LOOKUPS; AMS_USER_STATUSES_VL; FND_LANGUAGES_VL

APPS.AMS_EVENT_HEADERS_V is referenced by following:

APPS: AMS_EVENTHEADER_PVT - show dependent code