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_AGENDA_V

Object Details

Object Name:	AMS_EVENT_HEADERS_AGENDA_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_EVENT_HEADERS_AGENDA_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
DESCRIPTION	VARCHAR2	(4000)		Description of the event.
PARENT_ID	NUMBER			Unique identifier
PARENT_NAME	VARCHAR2	(240)		Name of the parent event
PARENT_DESCRIPTION	VARCHAR2	(4000)		Description of the parent 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
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
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
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
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.
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.
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.

Query Text

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


SELECT ROW_ID
,      EVENT_HEADER_ID
,      EVENT_HEADER_NAME
,      DESCRIPTION
,      PARENT_ID
,      PARENT_NAME
,      PARENT_DESCRIPTION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      EVENT_LEVEL
,      APPLICATION_ID
,      ACTIVE_FLAG
,      PRIVATE_FLAG
,      USER_STATUS_ID
,      USER_STATUS
,      SYSTEM_STATUS_CODE
,      LAST_STATUS_DATE
,      STREAM_TYPE_CODE
,      EVENT_STANDALONE_FLAG
,      DAY_OF_EVENT
,      AGENDA_START_TIME
,      AGENDA_END_TIME
,      REG_REQUIRED_FLAG
,      OWNER_USER_ID
,      URL
,      PHONE
,      EMAIL
,      INBOUND_SCRIPT_NAME
,      REG_INVITED_ONLY_FLAG
,      PARTNER_FLAG
,      ACTIVE_FROM_DATE
,      ACTIVE_TO_DATE
,      REG_MAXIMUM_CAPACITY
,      REG_MINIMUM_CAPACITY
,      MAIN_LANGUAGE_CODE
,      MAIN_LANGUAGE
,      CERTIFICATION_CREDIT_TYPE_CODE
,      CERTIFICATION_CREDITS
,      COORDINATOR_ID
,      REG_CHARGE_FLAG
,      CANCELLATION_REASON_CODE
FROM APPS.AMS_EVENT_HEADERS_AGENDA_V;

Dependencies

[top of page]

APPS.AMS_EVENT_HEADERS_AGENDA_V references the following:

APPS: AMS_EVENT_HEADERS_VL; AMS_USER_STATUSES_VL; FND_LANGUAGES_VL

APPS.AMS_EVENT_HEADERS_AGENDA_V is not referenced by any database object