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

Object Details

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

View Type

A Business Intelligence System view

This is the full view for the entity Calendar Period Event, describes an instance of a date alias in a calendar instance.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DATE_ALIAS	VARCHAR2	(10)	Yes	Name of an event.
SEQUENCE_NUMBER	NUMBER	(6)	Yes	System-generated number that is used to identify the date alias instance.
CALENDAR_TYPE	VARCHAR2	(10)	Yes	Type of calendar used within the organization.
CAL_INST_SEQ_NUM	NUMBER	(6)	Yes	System-generated number that is used to identify the calendar instance, the date alias instance occurs.
ABSOLUTE_VALUE	DATE			The actual date value allocated to an instance of a date alias.
DERIVED_VALUE	DATE			The derived date value allocated to an instance of a date alias.
ALIAS_VALUE	DATE			The alias date value allocated to an instance of a date alias.
DATE_ALIAS_DESCRIPTION	VARCHAR2	(60)	Yes	Description of an event.
START_DATE	DATE		Yes	Start Date when a calendar instance becomes effective.
END_DATE	DATE		Yes	End Date when the calendar instance is no longer effective.
ALTERNATE_CODE	VARCHAR2	(10)		Alternate short reference code for identifying a calendar instance.
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
,      SEQUENCE_NUMBER
,      CALENDAR_TYPE
,      CAL_INST_SEQ_NUM
,      ABSOLUTE_VALUE
,      DERIVED_VALUE
,      ALIAS_VALUE
,      DATE_ALIAS_DESCRIPTION
,      START_DATE
,      END_DATE
,      ALTERNATE_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_CALENDAR_PERIOD_EVENTS;

Dependencies

[top of page]

APPS.IGSFV_CALENDAR_PERIOD_EVENTS references the following:

APPS: IGS_CA_DA; IGS_CA_DA_INST; IGS_CA_GEN_001 - show dependent code; IGS_CA_GEN_002 - show dependent code; IGS_CA_INST_ALL

APPS.IGSFV_CALENDAR_PERIOD_EVENTS is not referenced by any database object