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.IGSBV_CAL_PRD_EVNT_TYPES

Object Details

Object Name:	IGSBV_CAL_PRD_EVNT_TYPES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSBV_CAL_PRD_EVNT_TYPES
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This is the base view for the entity Calendar Period Event Types that describes the available date aliases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DATE_ALIAS	VARCHAR2	(10)	Yes	Name of an event.
DESCRIPTION	VARCHAR2	(60)	Yes	Description of the date alias.
DATE_ALIAS_CATEGORY	VARCHAR2	(10)	Yes	Name of a date alias category. A date alias category is a classification of date aliases for athe purpose of grouping common date or event types.
ABBREVIATION	VARCHAR2	(30)		Abbreviated description of an event.
_LA:S_CALENDAR_CATEGORY	CHAR	(50)		System-defined categorization of calendar types. A date alias may be assigned a calendar category in order to restrict the assignment of a date alias instance to a calendar instance of the specified calendar category.
CLOSED_INDICATOR	VARCHAR2	(1)	Yes	Specifies if the date alias is closed. If the date alias is 'closed' then the system prevents the use of the date alias in new date alias instance records.
NOTES	VARCHAR2	(2000)		Additional information or details about the date alias.
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column.
CREATION_DATE	DATE		Yes	Standard Who Column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column.
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column.

Query Text

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


SELECT DATE_ALIAS
,      DESCRIPTION
,      DATE_ALIAS_CATEGORY
,      ABBREVIATION
,      _LA:S_CALENDAR_CATEGORY
,      CLOSED_INDICATOR
,      NOTES
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_CAL_PRD_EVNT_TYPES;

Dependencies

[top of page]

APPS.IGSBV_CAL_PRD_EVNT_TYPES references the following:

APPS: IGS_CA_DA

APPS.IGSBV_CAL_PRD_EVNT_TYPES is not referenced by any database object